onArcade Forums

Hi ,

While adding new games and deleting some (adult games)
i found out that the mysql DB has now gaps in the auto_increment value.

For instance:
ID : 1 = game1
ID :15 = game2
ID: 16 = game3

the numbers 2 till 14 are not there anymore (deleted those games)
Is it now possible to reset the DB to get it back in order so
the incremental value is back to 1234 ....

Hope someone can help.
Greetz,

PS: found on google some info but its not what i need.

I think this rather fit in the onArcade 2 Support (if it's onArcade 2.0).

actually it is.
But this applies to all mysql dbs, just with OnA v2 i have this.

Solved in the meantime ,
i made a little php script to update all the rows with a count.

Greetz.