Guest shoppaman Posted August 6, 2011 Share Posted August 6, 2011 CC5 UPGRADE FROM CC4 My customers are complaining that they cannot log in. I've tried to reset the passwords. Same problem. System error log for my test user: File: [customers.index.inc.php] Line: [91] "UPDATE `CubeCart_customer` SET `title` = 'Mr',`first_name` = 'Derek',`last_name` = 'Geldenhuys',`email` = '[email protected]',`phone` = `phone` + 27 15 2988135,`mobile` = '',`password` = 'I REMOVED THIS INFO FROM COPY / PASTE',`salt` = '662fcac5',`registered` = '1312622929' WHERE `customer_id` = '1';" - 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 '15 2988135,`mobile` = '',`password` = '9b39033cddb4dc0f105ee43f1b4061182841e6864' at line 1 Please help Quote Link to comment Share on other sites More sharing options...
Guest hennaboy Posted August 6, 2011 Share Posted August 6, 2011 Ive said this many times. You upgraded a live store without prior testing to ensure that nothing was wrong? I should imagine you didnt back up your CC4 store and database either? I dont think I need to tell you how unprofessional that is as you are learning the hard way. It is the responsibility of the end user to ensure they have tested it fully before upgrading a live store. Remove all the salts and it may resolve the issue. Test on a single user FIRST. If it works which I think it will do then empty all the salt values from your customer table. Easiest way to do this is run a SQL command in phpmyadmin. Quote Link to comment Share on other sites More sharing options...
Guest shoppaman Posted August 6, 2011 Share Posted August 6, 2011 Ive said this many times. You upgraded a live store without prior testing to ensure that nothing was wrong? I should imagine you didnt back up your CC4 store and database either? I dont think I need to tell you how unprofessional that is as you are learning the hard way. It is the responsibility of the end user to ensure they have tested it fully before upgrading a live store. Remove all the salts and it may resolve the issue. Test on a single user FIRST. If it works which I think it will do then empty all the salt values from your customer table. Easiest way to do this is run a SQL command in phpmyadmin. Thank you for your reply. And yes I did backup CC4. It's not professional because all of us are not guru's like you. And the supplier of this product should not sell it if it's not been properly tested. I did follow the exact instructions to execute the upgrade. In fact it's illegal to sell something in South Africa that does not work. You are welcome to go and read our consumer protection act. Quote Link to comment Share on other sites More sharing options...
Guest hennaboy Posted August 6, 2011 Share Posted August 6, 2011 Funny. As im pretty sure it was not sold in SA you came to their site to purchase. Still doesnt get past the point that if your store was important you would have tested it first. 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.