Guest Posted December 29, 2009 Share Posted December 29, 2009 I installed this unique order number(latest one) contribution in my shop.I tried to test it,but I got the following error message in my second order test(and my first order number is not the right format but 2147483647), 1062 - Duplicate entry '2147483647' for key 1 insert into orders (orders_id, 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 ('122809223650', '', 'Mortimer Green', '', '3 Lewis Road', 'Northallerton', 'Northallerton', 'DL6 3RX', 'Angus', 'United Kingdom', '01609779813', '[email protected]', '1', 'Mortimer Green', '', '3 Lewis Road', 'Northallerton', 'Northallerton', 'DL6 3RX', 'Angus', 'United Kingdom', '1', 'Mortimer Green', '', '3 Lewis Road', 'Northallerton', 'Northallerton', 'DL6 3RX', 'Angus', 'United Kingdom', '1', 'paypal_standard', '', '', '', '', now(), '1', 'GBP', '1.00000000') I don't know what happend and how to solve it,I also installed One Page Checkout,I'm not sure if there are some affects with it .I hope I can get your help. My English is not very good,hope you understand. Thank you. Quote Link to comment Share on other sites More sharing options...
Guest Posted December 30, 2009 Share Posted December 30, 2009 Any one can help? thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.