Hello, I tried this, but if

svihel's picture
Offline
Joined: 05/29/2008
Juice: 140
Hello, I tried this, but if

Hello,
I tried this, but if I use number which contains more than 7 digits and then try to make an order it will give me this error:

    * user warning: Duplicate entry '8388607' for key 1 query: INSERT INTO uc_orders (order_id, uid, order_status, order_total, primary_email, delivery_first_name, delivery_last_name, delivery_phone, delivery_company, delivery_street1, delivery_street2, delivery_city, delivery_zone, delivery_postal_code, delivery_country, billing_first_name, billing_last_name, billing_phone, billing_company, billing_street1, billing_street2, billing_city, billing_zone, billing_postal_code, billing_country, payment_method, data, created, modified) VALUES (20092629, 2, 'in_checkout', 0, 'svihel@gmail.com', '', '', '', '', '', '', '', 0, '', 0, '', '', '', '', '', '', '', 0, 0, 0, '', '', 1234373160, 1234373160) in C:\wamp\www\testovaci-shop\includes\database.mysql.inc on line 174.
    * user warning: Duplicate entry '16777215-flatrate_1' for key 1 query: INSERT INTO uc_order_quotes (oid, method, accessorials, rate, quote_form) VALUES (20092629, 'flatrate_1', '0', 0, '') in C:\wamp\www\testovaci-shop\includes\database.mysql.inc on line 174.

I looked at the database and the value uc_orders_order_id should contain 10 digits, I even later tried to heighten this number but it didn't help. BTW reason why I want such a big number is because I need this to my accounting to have order number like year_month_ordernumber, so for example this - 2009020054.

I'm using Ubercart 5.x-1.7

How do I set/reset the starting order number for my store? By: TR (13 replies) Wed, 01/30/2008 - 23:58