Phrkd Posted August 5, 2020 Share Posted August 5, 2020 Hello, could anyone shed some light on my predicament? When this shop was set up a custom order number was created as GFNS00000 a few orders and invoices were created using this format. Shortly after the order number format was changed to the default format along the lines of 200805-111111-2222. The store has been running for 7 months with little to no problems, except that on occasion an order goes awry and the error message is this: Duplicate entry 'GFNS01121' for key 'custom_oid' - I can't work out why it's trying to assign an old order number? Many thanks in advance.. Link to comment Share on other sites More sharing options...
Noodleman Posted August 5, 2020 Share Posted August 5, 2020 custom order ID's are broken, I wouldn't use them https://github.com/cubecart/v6/issues?q=is%3Aissue++custom+order+number Link to comment Share on other sites More sharing options...
Phrkd Posted August 5, 2020 Author Share Posted August 5, 2020 2 minutes ago, Noodleman said: custom order ID's are broken, I wouldn't use them https://github.com/cubecart/v6/issues?q=is%3Aissue++custom+order+number They're not being used any more, not for 7 months, but I'm still getting issues.. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 5, 2020 Share Posted August 5, 2020 You need to check directly in the database what details are being stored against the orders and which orders have the coi value set - it might be possible to remove all the old coi values Ian Link to comment Share on other sites More sharing options...
bsmither Posted August 5, 2020 Share Posted August 5, 2020 In CubeCart_order_summary, locate the record that did or would have caused this warning message. Note the value in the 'id' column. The incremental part of the custom_oid uses this value, then adds an optional offset. But if the Custom Order ID feature is switched off, as I understand it, no calculation is made and no value id is inserted for this column. Strange. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.