Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

checkout confirmation error - no contributions installed


Recommended Posts

what could cause this?



1062 - Duplicate entry '2147483647' for key 1


insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('1605', 'gsdg sdgsdg', '', 'sdgsdf', '', 'sdgsffs', 'sdgsdf', 'Alberta', 'Canada', '111', 'ss@ss.com', '1', 'gsdg sdgsdg', '', 'sdgsdf', '', 'sdgsffs', 'sdgsdf', 'Alberta', 'Canada', '1', 'gsdg sdgsdg', '', 'sdgsdf', '', 'sdgsffs', 'sdgsdf', 'Alberta', 'Canada', '1', 'Money Order or U.S. Cash', '', '', '', '', now(), '1', 'USD', '1.00000000')



Link to comment
Share on other sites

i did a search for 2147483647 in the database. here are the results:

1 match(es) inside table orders

1 match(es) inside table orders_products

2 match(es) inside table orders_status_history

3 match(es) inside table orders_total



i will assume something is not auto-incrementing? i checked "orders" and here is the result:

orders_id int(11) No auto_increment

orders_products_id int(11) No auto_increment

orders_status_history_id int(11) No auto_increment




orders_total has this:

Edit Delete 1 1 Sub-Total: $709.98 709.9800 ot_subtotal 1

Edit Delete 2 1 Flat Rate (Standard Mail): $5.00 5.0000 ot_shipping 2

Edit Delete 3 1 Total: <b>$714.98</b> 714.9800 ot_total 4

Edit Delete 24 2147483647 Total: <b>$22.74</b> 22.7400 ot_total 4

Edit Delete 23 2147483647 Basic Mail Rate (Shipping to United States: 4 Zone... $5.75 5.7500 ot_shipping 2

Edit Delete 22 2147483647 Sub-Total: $16.99 16.9900 ot_subtotal 1

Link to comment
Share on other sites

upon doing a forum search i determined 2147483647 is the max. order # oscommerce can handle.



i edited all instances of 2147483647 to something like 1507



i created a new order and clicked confirm order: same result.


for some reason, a file or the database is telling oscommerce to rack up the order_id to 2147483647


how can i stop this? i only want it to raise by 1 digit



replacing checkout_proces.php with a stock checkout_process.php made no difference

Link to comment
Share on other sites

sorry for double posting, but i cannot edit my post :)



deleting all previous orders:

started a fresh cart, checked out fine.


started a new fresh cart, checkout produced that Duplicate entry '2147483647' for key 1 error....

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...