SQL ERROR while installation Simple Visitor Newsletter

[t.trotzer]

Hi,

 

while i was installing the Simple Visitor Newsletter with HTML Support contribute, I got this error while updating my database;

 

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` )

 

This is the whole scipt I tryed to start;

 

CREATE TABLE `visitor` (

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

PRIMARY KEY ( `email` )

) ENGINE = MYISAM ;

 

CREATE TABLE `customers_temp` (

`customers_id` int(11) NOT NULL auto_increment,

`customers_firstname` varchar(32) NOT NULL default '',

`customers_lastname` varchar(32) NOT NULL default '',

`customers_email_address` varchar(96) NOT NULL default '',

PRIMARY KEY (`customers_id`)

) TYPE=MyISAM ;

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )

VALUES (

'', 'Bulk Mailer Limit', 'BULKMAILER_LIMIT', '5', 'Defines how many e-mails will be sent at a time', '3', '20', NULL , NOW( ) , NULL , NULL

);

 

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )

VALUES (

'', 'Bulk Mailer Interval [seconds]', 'BULKMAILER_INTERVAL', '12', 'Defines time between each bulk e-mails send', '3', '20', NULL , NOW( ) , NULL , NULL

);

[arietis]

while i was installing the Simple Visitor Newsletter with HTML Support contribute, I got this error while updating my database;

 

CREATE TABLE `visitor` (

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

PRIMARY KEY ( `email` )

) ENGINE = MYISAM

 

does your host's installation of the database support collation in swedish? check with your host and see which collation methods they support.

 

standard osc does not specify any character sets or collation on indexed text fields. so if you're not using this on any other indexed column, you might be able to safely remove the 'CHARACTER SET latin1 COLLATE latin1_swedish_ci ' from that table declaration. that would at least allow you to get past the install. later, once you find out what collation is supported, you can always do an alter table and update it.

[t.trotzer]

thanks alot!

 

I feel like a dump, but my skills are really poor and I have invested so much work until now..

 

can be looked at http://www.rothermel-reisen.com/osc/

 

Do maybe also have an idea what to do, when people enter there e-mail adresse, the thank window destroys my design... not so urgent but would still nice to know, what I can do..

 

thanks!

[arietis]

hey, we all have to start somewhere, right? a few years ago i didn't know any sql either. but you're trying to learn, that's what matters.

 

as far as fixing the thank you page goes, you'll have to take a look at the html and figure out why it's broken. you might just be missing a closing tag or something.