Auto increment error in Useractivation table

[PersianImmortal]

When I run the Repair/optimize function, previously all the tables were fine. Today after receiving a VBulletin error email, I checked and it seems the useractivation table has an issue:

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

I've run the repair/optimize function several times, as well as the Database repair function in MySQL on my server.

I've watched as some new users have joined my forums and the membership number seems to increment properly, so is this an issue, and if so how can it be resolved?

[Steve Machol]

Do you get this same message if you run repair/optimize again?

[PersianImmortal]

Yes, every time I run Repair/optimize the same error pops up. Which is why I'm curious if it requires me to actually manually correct this.

My TweakGuides Forums (http://forums.tweakguides.com) appear to be working correctly, and I ran a dummy test user through the registration process and everything appears to be working fine, but I'm worried about the potential impact of this error.

By the way, no plugins/hacks installed which impact on user registration/verification, and no new plugins or hacks installed for weeks now. Aside from upgrading to 3.5.4 (without any issues) recently, nothing else has been done with the forum software.

/EDIT - Here's the table view from PHPMyAdmin:
http://img514.imageshack.us/img514/4088/untitled13vz.jpg

[Steve Machol]

Fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.

[PersianImmortal]

Found the following which explains the error:

Some things reported by check table, can't be corrected automatically:

· Found row where the auto_increment column has the value 0.

This means that you have in the table a row where the AUTO_INCREMENT index column contains the value 0. (It's possible to create a row where the AUTO_INCREMENT column is 0 by explicitly setting the column to 0 with an UPDATE statement)

This isn't an error in itself, but could cause trouble if you decide to dump the table and restore it or do an ALTER TABLE on the table. In this case the AUTO_INCREMENT column will change value, according to the rules of AUTO_INCREMENT columns, which could cause problems like a duplicate key error.

To get rid of the warning, just execute an UPDATE statement to set the column to some other value than 0.

Basically there's a record with a 0 auto_increment value which I will manually have to change. Since it's not having any visible adverse effects on my forum I will do this when I get the chance.

Thanks for your help Steve.