chrisg Posted May 13, 2018 Share Posted May 13, 2018 Hello, last friday I upgraded out shop from verison 5.0.8 to 6.2.0-b1 and now if a customer places an order he can put in the address data and at after address verification he gets error 404 at the page he should see his ordered goods. if I look at the error log I can see the data of the order and at the end of the message there is the message - Duplicate entry '' for key 'custom_oid' how can I repair this? many thanks in advance. Quote Link to comment Share on other sites More sharing options...
chrisg Posted May 13, 2018 Author Share Posted May 13, 2018 Just one more add to my post. the customer is added to the database but without any order even if the customer did not wanted to create an account. the errror is displayed instead of the page ...../index.php?_a=complete Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted May 13, 2018 Share Posted May 13, 2018 Please delete the unique key 'custom_oid' on the CubeCart_order_summary table. And replace it with a standard key or normal index. This was a bug in the beta. 1 Quote Link to comment Share on other sites More sharing options...
chrisg Posted May 13, 2018 Author Share Posted May 13, 2018 Hi Al, thank you for the fast Reply. I am not an expert in mysql. So you mean I can simply delete the custom_oid entry and create a new one with the same Name or different Name? Or is the a simple update to resolve this? Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted May 13, 2018 Share Posted May 13, 2018 This page shows two ways to do it: https://stackoverflow.com/questions/3487691/dropping-unique-constraint-from-mysql-table If you have phpMySdmin then thats the easiest way. Quote Link to comment Share on other sites More sharing options...
chrisg Posted May 13, 2018 Author Share Posted May 13, 2018 I just dropped the unique index and now it works again. thank you very much! Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted May 13, 2018 Share Posted May 13, 2018 Well done! Sorry about this beta bug. Quote Link to comment Share on other sites More sharing options...
chrisg Posted May 13, 2018 Author Share Posted May 13, 2018 No Problem if it can be resolved this easy. Thank you for creating this great and easy to use product. 1 Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted May 13, 2018 Share Posted May 13, 2018 Thanks for the kind motivating feedback. 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.