I want it work! please!

[DanielaQ]

Hello my friends around the world!!

I tried to install this contribution a lot of times.. and never was sucessful.

Months later.. i try to do it.. but i allways have the same error when i try to import the rotator.sql.

The error is:

 

 

Error

consulta SQL:

 

CREATE TABLE `rotator` (

 

`rotator_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`products_id` int( 11 ) NOT NULL default '0',

`rotator_date_added` datetime default NULL ,

`rotator_last_modified` datetime default NULL ,

`expires_date` datetime default NULL ,

`date_status_change` datetime default NULL ,

`status` int( 1 ) default '1',

PRIMARY KEY ( `rotator_id` ) ,

KEY `idx_products_id` ( `products_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;

 

MySQL ha dicho:

 

#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 'DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci' at line 11

 

[ Volver ]

 

Can anyone help me please??

I'm using the osCommerce 2.2-MS2 / PHP Version 4.3.11

 

Thanks!!!