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 Posted October 19, 2006 Share Posted October 19, 2006 a URL would be handy and the text in global.inc.php, but please remove any user names and passwords before you post this info :( Quote Link to comment Share on other sites More sharing options...
Robsta Posted October 25, 2006 Share Posted October 25, 2006 Shouldn't this be in the CC3 section? Quote Link to comment Share on other sites More sharing options...
roban Posted October 25, 2006 Share Posted October 25, 2006 Shouldn't this be in the CC3 section? Good thinking! Moved Quote Link to comment Share on other sites More sharing options...
Guest adman Posted December 9, 2006 Share Posted December 9, 2006 a URL would be handy and the text in global.inc.php, but please remove any user names and passwords before you post this info I too am having the same problem. This is my global.inc and nmy url is www.artclaynz.co.nz/store any help would be great <?php $glob['dbdatabase'] = 'artclay_store'; $glob['dbhost'] = 'localhost'; $glob['dbpassword'] = ; $glob['dbprefix'] = ''; $glob['dbusername'] = 'artclay_forum'; $glob['installed'] = '1'; $glob['rootDir'] = '/home/artclay/public_html/store'; $glob['rootRel'] = '/~artclay/store/'; $glob['storeURL'] = 'http://artclaynz.co.nz/store'; ?> Quote Link to comment Share on other sites More sharing options...
Guest behosted Posted December 13, 2006 Share Posted December 13, 2006 having the same problem MySQL Error Occured 1054: Unknown column 'failLevel' in 'where clause' QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'admin' AND password = 'b73292a282834896eb85492c93e308d1' AND failLevel < 5 AND blockTime < 1166004000 I added then the failLevel and blockTime to that table and now I got MySQL Error Occured 1146: Table 'goede_cube3.CubeCart_blocker' doesn't exist QUERY = DELETE from CubeCart_blocker WHERE lastTime<1166001192 Before I go further, is there any script to update the db with the right tables and stuff? I upgraded from 3.0.7 to 3.014 Quote Link to comment Share on other sites More sharing options...
roban Posted December 13, 2006 Share Posted December 13, 2006 <?php $glob['dbdatabase'] = 'artclay_store'; $glob['dbhost'] = 'localhost'; $glob['dbpassword'] = ; $glob['dbprefix'] = ''; $glob['dbusername'] = 'artclay_forum'; $glob['installed'] = '1'; $glob['rootDir'] = '/home/artclay/public_html/store'; $glob['rootRel'] = '/~artclay/store/'; $glob['storeURL'] = 'http://artclaynz.co.nz/store'; ?> $glob['rootRel'] = '/store/'; Quote Link to comment Share on other sites More sharing options...
Guest behosted Posted December 13, 2006 Share Posted December 13, 2006 I did the following upgrades : 3.0.{6-10}-3.0.11 after that 3.0.11-3.0.12 and then 3.0.12-3.0.13 But still get MySQL Error Occured 1146: Table 'goede_cube3.CubeCart_blocker' doesn't exist QUERY = DELETE from CubeCart_blocker WHERE lastTime<1166004879 [edit] Ok Got it working missed this post http://www.cubecart.com/site/forums/index....showtopic=23229 [/edit] Quote Link to comment Share on other sites More sharing options...
Guest Posted December 14, 2006 Share Posted December 14, 2006 I upgraded from 3.06 and get this: MySQL Error Occured 1054: Unknown column 'failLevel' in 'where clause' QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = 'XXXX' AND password = 'XXXXXXXXXXXXXXXXXXXXXXXX' AND failLevel < 5 AND blockTime < 1166114223 What should I do now? Should I go back and upgrade 1 by 1? The store is working, I just can't get into the admin side of things.... Quote Link to comment Share on other sites More sharing options...
Guest KPalicz Posted February 21, 2007 Share Posted February 21, 2007 I am having the same problem and I am using 3.0.15 nm, I figured it out. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2007 Share Posted February 24, 2007 What did you do?? I am having the same problem and I am using 3.0.15 nm, I figured it out. Quote Link to comment Share on other sites More sharing options...
Guest Posted February 25, 2007 Share Posted February 25, 2007 Every thing alright now, I didn't do the upgrade.php scripts!! Gotta read the instructions...all works great now. 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.