Guest howsthisart Posted January 24, 2007 Share Posted January 24, 2007 wondering if anyone could help me... i have a modded store and i have being updating the site by manually changing the code as outlined in the changelog...the one that i was working on was 3.012 -3.013...and i occured a problem with mysql. When i login into the admin i get the following error: 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 < 1169132334' at line 1 QUERY = SELECT adminId FROM storeCubeCart_admin_users WHERE username = 'xxxxxxxxxxxxxxxx' AND password = 'xxxxxxxxxxxxxxxxxx' AND failLevel < AND blockTime < 1169132334 in an attempt to fix the problem i reinstalled cubecart version 3.013 in a new folder and took the newly created mysql tables and reinstalled them on my existing site, hoping to rectify the problem, seeing as it worked on the new version, but to no joy.... is there anything that i can do to recitify this problem, as i don't really want to re-install all my mods... any suggestion would be truly grateful....thankx in advance :) Quote Link to comment Share on other sites More sharing options...
roban Posted January 24, 2007 Share Posted January 24, 2007 FROM storeCubeCart_admin_users Is this the name of the table? Or is it CubeCart_admin_users Quote Link to comment Share on other sites More sharing options...
Guest howsthisart Posted January 24, 2007 Share Posted January 24, 2007 storeCubeCart_admin_users that is the name of the table. Quote Link to comment Share on other sites More sharing options...
roban Posted January 24, 2007 Share Posted January 24, 2007 have you tried deleting 1169132334 Quote Link to comment Share on other sites More sharing options...
Guest howsthisart Posted January 24, 2007 Share Posted January 24, 2007 have you tried deleting 1169132334 i've looked at the MySQL and there is nothing in there regarding the 1169132334. 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.