Guest aaw Posted August 27, 2006 Share Posted August 27, 2006 Having trouble updating the database to V3.0.12 get the following error: SQL-query: CREATE TABLE `CubeCart_SpamBot` ( `uniqueId` varchar( 32 ) NOT NULL , `spamCode` varchar( 5 ) NOT NULL , `userIp` varchar( 15 ) NOT NULL , `time` int( 10 ) NOT NULL default '0', PRIMARY KEY ( `uniqueId` ) , UNIQUE KEY `uniqueId` ( `uniqueId` ) ) TYPE = MyISAMCREATE TABLE `CubeCart_config` ( `name` varchar( 100 ) NOT NULL default '', `array` text NOT NULL , KEY `name` ( `name` ) ) TYPE = MYISAM MySQL said: #1064 - You have an error in your SQL syntax near 'MyISAMCREATE TABLE `CubeCart_config` ( `name` varchar(100) NOT NULL default ' at line 8 ---------------------------------------------------- Anyone else having problems with this upgrade Quote Link to comment Share on other sites More sharing options...
roban Posted August 27, 2006 Share Posted August 27, 2006 I don't know where you got that query from. Try this: CREATE TABLE `CubeCart_SpamBot` (`uniqueId` varchar(32) NOT NULL, `spamCode` varchar(5) NOT NULL, `userIp` varchar(15) NOT NULL,`time` int(10) NOT NULL default '0', PRIMARY KEY (`uniqueId`), UNIQUE KEY `uniqueId` (`uniqueId`) ) ENGINE=MyISAM Quote Link to comment Share on other sites More sharing options...
Guest aaw Posted August 27, 2006 Share Posted August 27, 2006 the database was generated at https://www.cubecart.com/build I tried your insert and it did not work. ======================================================= I got this: SQL-query: CREATE TABLE `CubeCart_SpamBot` ( `uniqueId` varchar( 32 ) NOT NULL , `spamCode` varchar( 5 ) NOT NULL , `userIp` varchar( 15 ) NOT NULL , `time` int( 10 ) NOT NULL default '0', PRIMARY KEY ( `uniqueId` ) , UNIQUE KEY `uniqueId` ( `uniqueId` ) ) ENGINE = MYISAM , TABLE `CubeCart_config` ( `name` varchar( 100 ) NOT NULL default '', `array` text NOT NULL , KEY `name` ( `name` ) ) TYPE = MYISAM MySQL said: #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM, TABLE `CubeCart_config` ( `name` varchar(100) NOT NULL defau' at line 8 Quote Link to comment Share on other sites More sharing options...
roban Posted August 27, 2006 Share Posted August 27, 2006 Where is this coming from? TABLE `CubeCart_config` ( `name` varchar( 100 ) NOT NULL default '', `array` text NOT NULL , That's not even in the query. What steps are you taking to import this query? The table should not exist and if it does, drop it. Just select your databse from the left column in phpMyAdmin and run the query from there. Quote Link to comment Share on other sites More sharing options...
Guest Tweety38 Posted August 28, 2006 Share Posted August 28, 2006 I got the same error and i got the script from https://www.cubecart.com/build also seems the build doesn't work right. i just uploaded everything and in step 5 filled out the info and that made the table for me BUT filezilla wont let me delete the install folder now . help roban sherry Quote Link to comment Share on other sites More sharing options...
Guest aaw Posted August 28, 2006 Share Posted August 28, 2006 Was about to think I was the only one having this problem, but thanks sherry for writing in. I have done upgrades to cube carts for sometime without a problem, but it seems that the Spambot addition is not accepted in its present form by the MySQL Database Upload on my server. I have tried the v11 to v12 upgrad; the website says it is version 12 but the SpamBot Tables did not import to the database. I have tried the https://www.cubcart.com/build website and the database did not import. I have now cleaned off the site by deleting the "store" file and the MySQL database; uploaded as a new installation of V12, and now it will not install the database. Any ideas what may be going wrong? Could it be the MySQL version on the server is wrong for the Spambot Tables? Quote Link to comment Share on other sites More sharing options...
roban Posted August 28, 2006 Share Posted August 28, 2006 when I installed this update I manually created the table. My advice to you is not to install this update...yet! Wait for the next major version upgrade due out tomorrow. Quote Link to comment Share on other sites More sharing options...
Guest Tweety38 Posted August 29, 2006 Share Posted August 29, 2006 aaw, don't do the build try to just upload everything and when u get to the admin page u should be able to do the database from there i think. as long as u have created the database and have the name of it and the password for it. just fill out the info and it should build it for u . at least it does for me. aaw are u installing on startlogic.com ?that is the site that gives me that error to . sherry Quote Link to comment Share on other sites More sharing options...
Guest Utah Concealed Posted September 5, 2006 Share Posted September 5, 2006 The problem is with this line: ) TYPE = MyISAMCREATE TABLE `CubeCart_config` ( Place a ; and new line between MyISAM and CREATE and it should create the table without problems. 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.