URGENT HELP - SHOP DOWN

[t.trotzer]

Hello, I really need urgent help, and I am sure, its only a small thing.

 

I installed today the "Simple Visitor Newsletter".

 

If run the SQL Script;

 

CREATE TABLE `visitor` (

`email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,

PRIMARY KEY ( `email` )

) ENGINE = MYISAM

 

This is the error I got back...

 

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE latin1_swedish_ci NOT NULL ,

PRIMARY KEY ( `email` )

 

The funny thing is, if I run this script on MySQL-Version 5.0.67, then it works. But I have to us the existing DB MySQL-Version 4.0.27 Version.

 

I would be really thankfull for a short feeback!

 

Thank you very much!

 

Thorbjörn

[♥geoffreywalton]

Easiest way is to create it manually using phpmyadmin.

 

Create the table

 

Create the field

 

Use the parameters above to set the table and field attributes.