Home » Forums » Ubercart » Support

uc_orders table: order_id

Submitted by Nick on Mon, 10/08/2007 - 13:47
Nick
Posts: 55
 Joined: 08/17/2007

I came across this link about Configuring Your Store and I just had a few questions about it.

At the bottom it says

"Also, you may not want your fledgling store to appear so young to your customers. However, as soon as someone checks out with an order number in the single digits, you're exposed. You might consider manually modifying your database to force order numbers to start at a higher value. Currently, this is done by adjusting the auto_increment value on the table uc_orders."

This may be a stupid question, but I was looking in phpmyadmin at the uc_orders table and I can't seem to figure out where the auto_increment value goes.

Field: order_id
Type: MEDIUMINT
Length/Values: 9
Collation:
Attributes:
Null: not null
Default:
Extra:
Comments:

Extra is currently blank, but it has a drop down menu where I can choose "auto_increment." When I choose that, I set Default to: 157193

When I save it though, Default stays blank and when I place a new order, it doesn't start at 157193.

Can anyone shed some light on this issue?
permalink #1 Mon, 10/08/2007 - 13:58
torgosPizza

Posts: 1293
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

Don't set the default value. You can set the next value of Auto_increment in the "Operations" tab of phpMyAdmin. And you will need to keep the "Extra" drop-down set to auto_increment in the uc_orders table (for order_id).

Hope this helps.

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #2 Mon, 10/08/2007 - 14:01
Ryan

Posts: 5269
 Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

lol Actually, that page is quite outdated. I'll fix it... auto_increment isn't even being used any more. Eye-wink

EDIT: Fixed it with the updated method.

permalink #3 Mon, 10/08/2007 - 14:20
Nick
Posts: 55
 Joined: 08/17/2007

Edit: Doh

Thanks Ryan, the new info helps

edit: that was much easier Smiling