Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

users cant checkout create orders Rate Topic   - - - - -

 
  • rinx
  • Member
  • Members
  • Join Date: 21-Jan 10
  • 52 posts

Posted 19 March 2010 - 07:00 PM #1

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

 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3954 posts

Posted 19 March 2010 - 07:04 PM #2

Run a search for "16777215"

 
  • adodric
  • Senior Member
  • Members
  • Join Date: 14-May 09
  • 320 posts

Posted 19 March 2010 - 07:09 PM #3

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

 
  • rinx
  • Member
  • Members
  • Join Date: 21-Jan 10
  • 52 posts

Posted 19 March 2010 - 07:11 PM #4

Run a search for "16777215"
did it
i had to refresh before i tried ordering again
what a mess

 
  • creativeuser
  • Senior Member
  • Members
  • Join Date: 20-May 09
  • 150 posts

Posted 03 November 2010 - 03:29 PM #5

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

 
  • timst
  • Member
  • Members
  • Join Date: 13-Feb 09
  • 110 posts

Posted 06 October 2011 - 10:43 PM #6

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>


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.
V 4.2.2

 
  • malvcomm
  • Junior Member
  • Trial users
  • Join Date: 20-Aug 09
  • 13 posts

Posted 06 March 2012 - 08:12 PM #7

Hi,

I get a similar problem to the previous poster...

Error: Duplicate entry '1143-ab18ac09343ec064bce20a5923cc70f5' for key 'PRIMARY' <b>(1062)</b>
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.

 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4886 posts

Posted 06 October 2012 - 01:55 PM #8

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>


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.


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

Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2