Jump to content
Sign in to follow this  

SQL error in Flash Carousel Menu v2.0d

Recommended Posts

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:




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



Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this