Users cant checkout create orders

i get error

Database error: Duplicate entry ‘16777215’ for key 1 (1062)

when i del order # 16777215 it works but issues a new order with the same # 16777215

and then once again i cant place any new orders i changed the

Initial order ID value to 2457572

Run a search for “16777215”

Sounds like orders are using a medium int for the order number which caps out at #16777215.

Run a search for “16777215”

did it

i had to refresh before i tried ordering again

what a mess

i get the same error, have you sold your problem ?

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' (1062)





cscart_new_orders

cscart_order_data

cscart_order_details

cscart_orders

cscart_profile_fields_data





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.

Hi,



I get a similar problem to the previous poster…



Error: Duplicate entry '1143-ab18ac09343ec064bce20a5923cc70f5' for key 'PRIMARY' (1062)

Query: INSERT INTO cscart_stat_product_search (sess_id, search_string, md5, quantity) VALUES ('1143', 'a:11:{s:5:"match";s:3:"any";s:10:"pcode_only";s:1:"Y";s:5:"pfull";s:1:"N";s:9:"pkeywords";s:1:"N";s:5:"pname";s:1:"N";s:6:"pshort";s:1:"N";s:1:"q";s:9:"RYB-721-4";s:16:"search_performed";s:1:"Y";s:6:"status";s:1:"A";s:7:"subcats";s:1:"N";s:4:"type";s:6:"simple";}', 'ab18ac09343ec064bce20a5923cc70f5', '0')

Backtrace››

/home/neccde5/public_html/core/fn.database.php (db_error): 311

/home/neccde5/public_html/addons/statistics/controllers/customer/products.post.php (db_query): 59

/home/neccde5/public_html/core/fn.control.php (include): 567

/home/neccde5/public_html/core/fn.control.php (fn_run_controller): 422

/home/neccde5/public_html/index.php (fn_dispatch): 28



This happens infrequently, but it overloads my dedicated server (high CPU activity of 12 with 4 cores).



CS-Cart support previously indicated that this has more to do with tmp tables, but clearing them doesn't prevent this error.



cs-cart 2.1.3



Any advise would be greatly appreciated. Thank you.

[quote name='timst' timestamp='1317940986' post='123076']

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' (1062)





cscart_new_orders

cscart_order_data

cscart_order_details

cscart_orders

cscart_profile_fields_data





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.

[/quote]



I had this problem on V3, I altered my initial order ID in settings general to a lower figure and seems to be OK Now.



John