Guest fleer_allstar Posted October 19, 2006 Share Posted October 19, 2006 I just manually upgraded to .13 and now I cannot login my Admin section? 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 'AND blockTime < 1161130567' at line 1 QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'houstonaxl' AND password = 'e7ffec49eb01e2dab35c19fe5b6969a1' AND failLevel < AND blockTime < 1161130567 this is what I get when I try to log in? did I miss something or do I need to change something in my database? This is my first Manual upgrade to CC but as far as I can tell the retail side works ok with the exception of RandomProduct Images won't show I had modded that with the Scrolling PopularProducts with Images so I'll try to fix it later...But I need to login to my Admin?!?!?! Anyone else have this problem or can someone tell me how to fix it or even offer to fix it for me????? HELP! :( Quote Link to comment Share on other sites More sharing options...
Guest fleer_allstar Posted October 19, 2006 Share Posted October 19, 2006 Ok I have narrowed down that the problem is in 1 of 3 files /admin/login.php /admin/logout.php /admin/includes/auth.inc.php I am going over the upgrades now to see where the problem is. Quote Link to comment Share on other sites More sharing options...
kinetic Posted October 19, 2006 Share Posted October 19, 2006 Ok I have narrowed down that the problem is in 1 of 3 files /admin/login.php /admin/logout.php /admin/includes/auth.inc.php I am going over the upgrades now to see where the problem is. you did not follow the manual upgrade instructions for 3.0.13 section b b. Run the following sql commands using a tool such as phpMyAdmin Replace {PREFIX} with your store tables prefix if you have one. ALTER TABLE `{PREFIX}CubeCart_admin_users` ADD `failLevel` INT( 1 ) NOT NULL DEFAULT '0', ADD `blockTime` INT( 10 ) NOT NULL DEFAULT '0', ADD `lastTime` INT( 10 ) NOT NULL DEFAULT '0'; CREATE TABLE `{PREFIX}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; you need to inject the new table via phpmyadmin MANUALLY Quote Link to comment Share on other sites More sharing options...
Guest airjer Posted October 20, 2006 Share Posted October 20, 2006 The above reply is wrong as I've done this.... it says there is a duplicate field. Quote Link to comment Share on other sites More sharing options...
Guest airjer Posted October 20, 2006 Share Posted October 20, 2006 Quote Link to comment Share on other sites More sharing options...
Guest fleer_allstar Posted October 23, 2006 Share Posted October 23, 2006 Ok I have narrowed down that the problem is in 1 of 3 files /admin/login.php /admin/logout.php /admin/includes/auth.inc.php I am going over the upgrades now to see where the problem is. you did not follow the manual upgrade instructions for 3.0.13 section b b. Run the following sql commands using a tool such as phpMyAdmin Replace {PREFIX} with your store tables prefix if you have one. ALTER TABLE `{PREFIX}CubeCart_admin_users` ADD `failLevel` INT( 1 ) NOT NULL DEFAULT '0', ADD `blockTime` INT( 10 ) NOT NULL DEFAULT '0', ADD `lastTime` INT( 10 ) NOT NULL DEFAULT '0'; CREATE TABLE `{PREFIX}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; you need to inject the new table via phpmyadmin MANUALLY Kinetic I checked these entries are already in my SQL database. and still can't change the Login files to .13?? Quote Link to comment Share on other sites More sharing options...
Guest Posted October 23, 2006 Share Posted October 23, 2006 Now I used the upgrade.php to insert the new database info... And I get that same exact error. I just removed the line in the login.php file which looks for the failLevel and Blocktime, and now it will atleast let me login. What would be the difference between using the upgrade.php verses manually running that database commands? Quote Link to comment Share on other sites More sharing options...
Guest canda Posted October 26, 2006 Share Posted October 26, 2006 I copy and paste the SQL statement in PHPAdmin and confirm the column is there, it works for me straight away Quote Link to comment Share on other sites More sharing options...
Guest tynyffridd Posted October 26, 2006 Share Posted October 26, 2006 DITTO as some others here (this is not my first update, but the first to throw a wobbly)---> Manual upgrade to 3.13 + db update as per instructions (phpmyadmin 2.8.2.4 & mysql 4.1.21-standard-log & php 4.4.4) Store front works as usual (havent yet tried test purchase) Admin don't work for me either either - 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 'AND blockTime < 1161888588' at line 1 QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'logon' AND password = 'password' AND failLevel < AND blockTime < 1161888588 What now? any ideas? Seems a bit hit and miss - works for some and yet not for others.... Quote Link to comment Share on other sites More sharing options...
Guest Posted December 5, 2006 Share Posted December 5, 2006 Ive just ran a few searches after going through the upgrade process from 3.0.11 to .14 ... encountered some problems and a solution seemed to be a little difficult to find, so ...... For those having the 1064 error when attempting ADMIN LOGIN after UPGRADE to 3.0.13..... 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 'AND blockTime < 1161888588' at line 1 Get the attached files to the following post : http://www.cubecart.com/site/forums/index....showtopic=23229 Unzip....upload files as instructed in the README.txt file...and you should then be fine...and upgraded to 3.0.14 I thought maybe others might have missed the "3.0.13 - 3.0.14 ChangedFilesONLY" just like I did....and this worked for me!! 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.