[CaptainAwesome]

Originally Posted by ozzy47

That error is most commonly caused by plugins or addons that incorrectly set auto increment fields within vBulletin.

I would suggest reading this, https://www.vbulletin.com/docs/html/...l_duplicatekey

Specifically the query starting as:

ALTER TABLE `user` CHANGE `userid`

Am i suppose to run them all, because the one line you mentioned didn't work. I copied and pasted the line as follows:

ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;

And when i ran it, i got the screen attached.