checkout confirmation error - no contributions installed

[Guest]

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]

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]

...and the number of customers (in admin) shows 0, but in the database i see a LOT more

[Guest]

could this be caused by a server upgrade?

[developer_x]

Installed any new contribution? Or executed a new sql query?

[Guest]

nope. this is the first time i've seen this error and i've not made any changes

[Guest]

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]

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