Jump to content
Sign in to follow this  
DanielaQ

Problem with Flash Carousel Menu v2.0d

Recommended Posts

Hi friends around the world!

I get this very nice contribuicion, but already beginning to have a

problem that will not allow me to move forward on the installation.

 

The first problem:

When i import the file rotator.sql, I get an error as if it were bad

in the last line ... I copy the code I have in the sql I downloaded.

 

If someone has installed this application, could be copied

rotator.sql ? I also send the error.

 

My rotator.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;

 

The error:

error_rotator.gif

 

 

Thank you very much!

 

Daniela

Share this post


Link to post
Share on other sites
PLEASEE!!! ANYONE HAVE THE SAME PROBLEM??

Only an idea...check your version of mysql and make sure CREATE command is using the correct syntax. Should be universal, however, you know picky mysql can be. Off the top of my head(not knowing what version you have) look at the ENGINE, CHARSET, and COLLATE options to begin with.

 

Installed this same contrib and have it working on PHP5 and MySQL 5.0.67.

 

Frank

Share this post


Link to post
Share on other sites
Only an idea...check your version of mysql and make sure CREATE command is using the correct syntax. Should be universal, however, you know picky mysql can be. Off the top of my head(not knowing what version you have) look at the ENGINE, CHARSET, and COLLATE options to begin with.

 

Installed this same contrib and have it working on PHP5 and MySQL 5.0.67.

 

Frank

 

 

I have the same problem and with a little luck i change the last line in the rotator.sql

 

FROM

 

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

 

TO

 

) TYPE=MyISAM;

 

This work for me

Share this post


Link to post
Share on other sites

Ok, i modified the file and uploaded without problems.. now i'm starting with the rest of procces.

Hope no have more porblems.

Thank U!!!

 

 

Daniela

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  

×