Jump to content
Sign in to follow this  

Unique Order Number Help

Recommended Posts

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', 'fgpqli00@gmail.com', '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.

Pet Tips - Petlv.com

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this