Tell me about it - there's 21 databases on that vps I have to go through and see what's broke. Most of them I'm going to drop the tables and re-create.

The first thing you can try is to reset the auto_increment field to what it should be. First, you'd need to find the max id for the table. For example, the posts table.

select MAX(POST_ID) from ubbt_POSTS

That will come back with some number, say 12345. Add one to that number and use it in the following query:

ALTER TABLE ubbt_POSTS AUTO_INCREMENT=123456;

If that doesn't fix it then it might require altering the row to drop the auto_increment field and then readding it.

ALTER TABLE ubbt_POSTS CHANGE POST_ID POST_ID int(11) unsigned primary key

then:

ALTER TABLE ubbt_POSTS CHANGE POST_ID POST_ID int(11) unsigned auto_increment primary key



Even though the tables are already messed up, I'd recommend doing a backup before doing anything, just in case something happens and it makes it worse.

Thank you, that's what I did 44 times last night - actually with the first one I edited the column manually with phpmyadmin then just copied the resulting mysql command into ultraedit ( ) to save for the second forum I started to write an altertable script for practice, but at 1am I decided I don't need to practice that much

I have to sort out photopost on those 2 sites then basically drop the other databases on the other sites and re-install.

I don't think we'll be re-creating the vps any time soon again

"backup before upgrading" comes to mind all too clearly lol...