Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Problem with Flash Carousel Menu v2.0d


DanielaQ

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

Link to comment
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

Link to comment
Share on other sites

  • 4 weeks later...
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...