3 replies [Last post]
Nick's picture
Offline
Joined: 08/17/2007
Juice: 95
Was this information Helpful?

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?

torgosPizza's picture
Offline
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.
Joined: 08/14/2007
Juice: 4110
Re: uc_orders table: order_id

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.

--
Help directly fund development: Donate via PayPal!

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Re: Re: uc_orders table: order_id

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.

Nick's picture
Offline
Joined: 08/17/2007
Juice: 95
Re: Re: uc_orders table: order_id

Edit: Doh

Thanks Ryan, the new info helps

edit: that was much easier Smiling