[Forum] Warning: Found row where the auto_increment column has the value 0

[Abhik]

Hello,
When I Repair/Optimize my database, I am getting this warning on postedithistory table. It wasn't there few days ago when I last repaired my database.

How can I fix that?

postedithistory Check  Warning: Found row where the auto_increment column has the value 0
postedithistory Check  Status: OK
postedithistory Optimize  Status: Table is already up to date

[Abhik]

Anybody here to help me out? I am getting this error message every time I try to repair the database.

[Wayne Luke]

Why are you repeatedly repairing the database? These tools shouldn't be run on a regular basis and can actually cause your database to crash if the wrong set of circumstances happen. You should only run Repair and Optimize if you're told to do so by support or run Optimize if you have recently deleted a large amount of information in your database, and then only on the affected tables. These are not things you should run every few days, every week or on any regular interval.

To change a value in the database, you need to change that row.

[BirdOPrey5]

It's not an error just a warning- if the table functions as it's supposed to there is no problem.

Otherwise it is pretty specific what it is saying- you need to check the table to see which fields are set to auto increment and see which ones have a value of zero in that field and see if anything looks suspicious.

The other question is why are you repairing the tables regularly? There is no reason to repair a table that isn't broken.