[SOLVED] Order ID History in MySQL Database - Where is it stored!

[guitarplayer]

Hello,


I've deleted some recent orders from the Database but the Order ID doesn't continue from the last proper order.

Example :

Orders were at Order ID nº 110 but I have deleted some, so orders are now at Order ID nº 95

But when I do a new test order, the Order ID continues from nº 110.

Does anyone know whereabouts in the Database the Next Order ID is stored?


Best regards,

Guitar Player.

[rocky]

The next autoincrement value is not stored in the database as data, it is part of the structure of the table. I think the following query should reset the autoincrement:

ALTER TABLE ps_orders AUTO_INCREMENT = 1

[SK01]

After 2 years I am bringing this thread up

Where do i need to make the changes, in which file?

[MrBaseball34]

You don' tmake changes in a file, per se.
You run the SQL script that rocky provided against your database using phpMyAdmin or some other SQL utility that connects to your database.

[SK01]

When i try to run this script:

ALTER TABLE ps_orders AUTO_INCREMENT = 420

It says:

#1146 - Table 'database_name.ps_orders' doesn't exist

Anyone know what I am doing wrong here?

[rocky]

The table doesn't exist, so my guess is that your database prefix isn't ps_. You should change the prefix to your database prefix.

[SK01]

Oh yes, i think you are right. I will try check for the right prefix and solve the problem. By the way, you got PM..

[SK01]

Worked perfectly! Thanks!!

[thehandlestudio]

The next autoincrement value is not stored in the database as data, it is part of the structure of the table. I think the following query should reset the autoincrement:

ALTER TABLE ps_orders AUTO_INCREMENT = 1

Hi Rocky,

So if my next order id was 3887 ?
Do I put 3887 instead of the number 1 in your query?

Regards,

Mark.

[rocky]

Yes, set the autoincrement to whatever you want the next order ID to be.

[thehandlestudio]

Thanks for the help.

Regards,

Mark.