DanielaQ Posted November 11, 2008 Share Posted November 11, 2008 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: Thank you very much! Daniela Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted November 11, 2008 Author Share Posted November 11, 2008 PLEASEE!!! ANYONE HAVE THE SAME PROBLEM?? Quote Link to comment Share on other sites More sharing options...
rescuestat Posted November 17, 2008 Share Posted November 17, 2008 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 Quote Link to comment Share on other sites More sharing options...
hugodon Posted December 10, 2008 Share Posted December 10, 2008 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 Quote Link to comment Share on other sites More sharing options...
DanielaQ Posted December 12, 2008 Author Share Posted December 12, 2008 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.