Guest Posted December 11, 2005 Posted December 11, 2005 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', '[email protected]', '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') [TEP STOP]
Guest Posted December 11, 2005 Posted December 11, 2005 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
Guest Posted December 11, 2005 Posted December 11, 2005 ...and the number of customers (in admin) shows 0, but in the database i see a LOT more
developer_x Posted December 11, 2005 Posted December 11, 2005 Installed any new contribution? Or executed a new sql query? Irfan,
Guest Posted December 11, 2005 Posted December 11, 2005 nope. this is the first time i've seen this error and i've not made any changes
Guest Posted December 12, 2005 Posted December 12, 2005 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
Guest Posted December 12, 2005 Posted December 12, 2005 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....
Recommended Posts
Archived
This topic is now archived and is closed to further replies.