Guest Posted October 17, 2006 Share Posted October 17, 2006 I use CC 3.0.12 without any problem. I decided to create a new directory and new mysql database to 'play' with CC 3.0.13, but when I attempt to install, it creates the CubeCart_SpamBot table then crashes with the error below. Re-uploaded all files and tried again with same results. ??? Daniel. Quote Link to comment Share on other sites More sharing options...
roban Posted October 17, 2006 Share Posted October 17, 2006 add a ; at the end of the query. It's in the upgrade. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2006 Share Posted October 17, 2006 add a ; at the end of the query. It's in the upgrade. I did a fresh install using a new empty database. There already is a ';' in my existing schema.inc.php file as shown below. $db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_blocker` ( `id` int(11) NOT NULL auto_increment, `browser` text NOT NULL, `ip` varchar(11) NOT NULL, `username` varchar(50) NOT NULL, `blockTime` int(10) NOT NULL default '0', `blockLevel` int(1) NOT NULL default '0', `loc` char(1) NOT NULL, `lastTime` int(10) NOT NULL, KEY `id` (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1"); Daniel. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2006 Share Posted October 17, 2006 I'm getting exactly the same error after a new install. Any ideas? Quote Link to comment Share on other sites More sharing options...
roban Posted October 17, 2006 Share Posted October 17, 2006 If the spambot table exists you will get the error. drop the existing table prior to installation. Quote Link to comment Share on other sites More sharing options...
Guest kaskudoo Posted October 17, 2006 Share Posted October 17, 2006 getting the same error as well MySQL Error Occured 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=latin1 AUTO_INCREMENT=1' at line 11 QUERY = CREATE TABLE `try02CubeCart_blocker` ( `id` int(11) NOT NULL auto_increment, `browser` text NOT NULL, `ip` varchar(11) NOT NULL, `username` varchar(50) NOT NULL, `blockTime` int(10) NOT NULL default '0', `blockLevel` int(1) NOT NULL default '0', `loc` char(1) NOT NULL, `lastTime` int(10) NOT NULL, KEY `id` (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 i tried with brand new database. the spambot table did get established during installation routine it seems (i went into database and dropped the spambot table) - no success though it always comes back with this error. this is on a very fresh install of cubecart .13 and a brand new empty database provider godaddy, php 4.x, gd 2.x, curl enabled i also verified all correct info on database name and so forth .... i did install cc .12 before without problem :whistle: Quote Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2006 Share Posted October 17, 2006 OK. On a 'full' install I went to my /install/db/schema.inc.php file and found the following block of code: $db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_blocker` ( `id` int(11) NOT NULL auto_increment, `browser` text NOT NULL, `ip` varchar(11) NOT NULL, `username` varchar(50) NOT NULL, `blockTime` int(10) NOT NULL default '0', `blockLevel` int(1) NOT NULL default '0', `loc` char(1) NOT NULL, `lastTime` int(10) NOT NULL, KEY `id` (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1"); Find the very last semi-colon in this block of code and add a space between the ')' and ';' characters. That caused the install to create my database without errors. Make sure you drop any existing tables first. Daniel. Quote Link to comment Share on other sites More sharing options...
Guest kaskudoo Posted October 17, 2006 Share Posted October 17, 2006 i did the change like this: $db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_blocker` ( `id` int(11) NOT NULL auto_increment, `browser` text NOT NULL, `ip` varchar(11) NOT NULL, `username` varchar(50) NOT NULL, `blockTime` int(10) NOT NULL default '0', `blockLevel` int(1) NOT NULL default '0', `loc` char(1) NOT NULL, `lastTime` int(10) NOT NULL, KEY `id` (`id`) ) TYPE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1")_SPACE_; (i added a space between the last "(" and ";" but it did NOT do the trick - i still end up with the same error message .... i made sure that the database was completely empty before i started the install process thanks for your help though! Quote Link to comment Share on other sites More sharing options...
Guest Posted October 17, 2006 Share Posted October 17, 2006 Well, you can always use the schema.inc.php file from CC 3.0.12 to do the install, then upgrade the database using PhpMyAdmin to create the CubeCart_Blocker table. Quote Link to comment Share on other sites More sharing options...
Guest kaskudoo Posted October 18, 2006 Share Posted October 18, 2006 mh, i am afraid i do not know phpmyadmin at all ..... all i can do is create a database and thats pretty much it (i did manage to drop the created spamthingtable after the unsuccessful installs) i just keep on running into probs with CC .... w/ version .12 the paypal thing didn't work right - and that just made me want version .13 even more, since the api for paypal is completely rewritten ..... argh that i cannot install it now edit: i tried to take the older schema file and installation worked - however, i was not able to login to the admin panel of cubecart (gave me some other sql error) Quote Link to comment Share on other sites More sharing options...
Guest shambala Posted October 18, 2006 Share Posted October 18, 2006 I had 3.12 installed, then I uploaded the correct things, ran the first sql command fine: ALTER TABLE But when it came to the: CREATE TABLE it just sat there then said page cannot be displayed. The exact code was: CREATE TABLE `CubeCart_blocker` ( `id` int(11) NOT NULL auto_increment, `browser` text NOT NULL, `ip` varchar(15) NOT NULL, `username` varchar(50) NOT NULL, `blockTime` int(10) NOT NULL default '0', `blockLevel` int(1) NOT NULL default '0', `loc` char(1) NOT NULL, `lastTime` int(10) NOT NULL, KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1") ; Quote Link to comment Share on other sites More sharing options...
Guest shambala Posted October 18, 2006 Share Posted October 18, 2006 I tried running the upgrade but get this. 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted October 18, 2006 Share Posted October 18, 2006 I tried running the upgrade but get this. 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Thats either an error with the details you put in for the hostname or an issue with your hosting. Quote Link to comment Share on other sites More sharing options...
Guest kaskudoo Posted October 18, 2006 Share Posted October 18, 2006 i was able to install 3.0.12 and upgrade it to 3.0.13 i tried numerous times to do a fresh install and it wouldn't work .... i am just glad tht i finally got it ...... next thing on the list is the paypal thing :whistle: 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.