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:
CODE
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
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
