Ferguson230 Posted September 7, 2018 Share Posted September 7, 2018 I just got a new order a few minutes ago, I only noticed it because PayPal sent me an email. When I log into the admin control panel and click on orders, it doesn't show up. When I check on the error logs, I see it over there. I have attached a screenshot. How do I fix this? Thanks. Link to comment Share on other sites More sharing options...
bsmither Posted September 7, 2018 Share Posted September 7, 2018 Sorry, not seeing the image. Link to comment Share on other sites More sharing options...
Ferguson230 Posted September 8, 2018 Author Share Posted September 8, 2018 Sorry about that. I have attached it in this one. Link to comment Share on other sites More sharing options...
bsmither Posted September 8, 2018 Share Posted September 8, 2018 The actual error is annotated at the very end of that log entry. Would you have any plugins or Code Snippets that would affect, in any way, what gets databased regarding the order details? Link to comment Share on other sites More sharing options...
Ferguson230 Posted September 8, 2018 Author Share Posted September 8, 2018 Not really, I only placed a mylivechat javascript code in the main.php for the front end. Do you think that could be the cause? Link to comment Share on other sites More sharing options...
Ferguson230 Posted September 8, 2018 Author Share Posted September 8, 2018 And at the end of the error log, it says - Duplicate entry '' for key 'custom_oid'. Link to comment Share on other sites More sharing options...
bsmither Posted September 8, 2018 Share Posted September 8, 2018 This has been fixed in the next version. https://github.com/cubecart/v6/issues/1987 To fix it now, use an external database utility to execute the following SQL statement: ALTER TABLE `CubeCart_order_summary` CHANGE `custom_oid` `custom_oid` VARCHAR(50) NULL DEFAULT NULL; (Be sure to use a table prefix if necessary.) Currently, this column requires a unique, non-null value for 'custom_oid', but empty strings are being used. Even an empty string can be considered as duplicated content. By setting this column to hold a null value as default, the database engine will no longer complain. Link to comment Share on other sites More sharing options...
Ferguson230 Posted September 8, 2018 Author Share Posted September 8, 2018 Thanks Brian. I will do a test order and see how it goes. Link to comment Share on other sites More sharing options...
Ferguson230 Posted September 9, 2018 Author Share Posted September 9, 2018 ThanksĀ Brian, it works now. You've always been very helpful, I really appreciate you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.