Jump to content



Member Since 13 Feb 2009
Offline Last Active Feb 04 2020 06:58 PM

#125111 Sitemap Problems

Posted by timst on 01 November 2011 - 09:48 PM

I think its this:

#123076 users cant checkout create orders

Posted by timst on 06 October 2011 - 10:43 PM

This is an old post, but it just saved MY ... umm you know what.

I'm going to post here just in case someone else runs into this.

The tables below have mediumint set as their properties with a max length of 8 characters.
If you set your "Next order number" too high, (above 8 characters and the value of 16777215
or higher) you will get this error and the customer will not be able to place an order.
You'll see an error in the Logs that goes something like this:

Error: Duplicate entry '1105782063-16777215' for key 'PRIMARY' <b>(1062)</b>


I changed the value from mediumint to bigint in each of the tables and extended the length of each field to 20 characters... I was then able to place orders again.

CS cart... Maybe this needs to be changed in the DB design?

Anyway, hopefully someone can use this info in the future.