Guest Posted April 23, 2007 Share Posted April 23, 2007 I have manually upgraded CC3 from about .07 upwards and currently I am at 3.0.12 ... Where I am stuck at now. There have been MANY posts I have found of people having this error after trying to login to the ADMIN area in the store: 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 < 1177365145' at line 1 QUERY = SELECT adminId FROM CubeCart_admin_users WHERE username = '********' AND password = '*********' AND failLevel < AND blockTime < 1177365145 Searching through the message forums, I have found at least 10 posts with this problem but the only solution ever seen was 'RUN THE UPGRADE.PHP SCRIPT!' ... I have done this, went back and verified the database was modified with the correct parameters, etc. BUT I still am getting this error and cannot get around it. Even when other CC users posts they have run the scripts, there is never another message following giving any more suggestions. Has anyone been getting this error when upgrading to 3.0.13 and how did you fix it?? TIA. -Tim 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.