6 replies [Last post]
Dubs's picture
Offline
Joined: 11/20/2007
Juice: 79
Was this information Helpful?

Hi there,

Firstly, thanks for a great system!

OK, the question..... Is there a way to change to next available order number. We've put some test orders in, and the next order would be 5. We want to bring the number in line with our existing system, whose current order number is 15724. Is there a way to do this?

Many thanks,

David

Ryan's picture
Offline
Joined: 08/07/2007
Juice: 15438
Welcome aboard. You can

Welcome aboard. Smiling You do this by modifying the appropriate row in the sequences table in your database. You should be able to tell which one.

Mariano's picture
Offline
Joined: 09/04/2007
Juice: 110
Re: Welcome aboard. You can

In case you haven't found it, browse to the 'sequences' table, and then look for the 'uc_orders_order_id' row.

Dubs's picture
Offline
Joined: 11/20/2007
Juice: 79
Thank you!

Thanks for such a quick reply! That seems to have done the trick Smiling

drjonez's picture
Offline
Joined: 03/13/2009
Juice: 35
Re: Thank you!

has this changed? There's no 'sequences' table that i can find.

Thank you

Lyle's picture
Offline
AdministratoreLiTe!
Joined: 08/07/2007
Juice: 6846
Re: Re: Thank you!

Right, the sequences table was removed in Drupal 6. Now you have to adjust the auto_increment value if you have MySQL. I'm not exactly sure how that works with PostgreSQL. I think that column should have some kind of serial index for its primary key.

drjonez's picture
Offline
Joined: 03/13/2009
Juice: 35
Nevermind Found this: In

Nevermind

Found this:

In drupal 6 the sequences table was eliminated, in favor of autoincrement database tables.

So the code for the D6 version of ubercart (using MySQL) is
alter table uc_orders auto_increment = 6858;