3.7 upgrade error on step 4 on upgrade

[raubin]

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO adminmessage
(varname, dismissable, script, action, execurl, method, dateline, status)
VALUES
('after_upgrade_37_moderator_permissions', 1, 'moderator.php', 'showlist', 'moderator.php?do=showlist', 'get', 1211554056, 'undone');

MySQL Error : Duplicate entry '0' for key 1
Error Number : 1062
Request Date : Friday, May 23rd 2008 @ 10:47:36 AM
Error Date : Friday, May 23rd 2008 @ 10:47:36 AM
Script : http://www.spanishrealestateforum.com/install/upgrade_370b2.php?step=4
Referrer : http://www.spanishrealestateforum.com/install/upgrade_370b2.php?step=4
IP Address : 84.76.150.131
Username :
Classname : vB_Database
MySQL Version : 5.0.22


Does anyone know what this problem is?

Thanks

[snakes1100]

You can try to repair the database table, then run that step again, if that doesnt work, reload a backup of the database and start the upgrade again.

I would also suggest you upgrade the mysql running on the server if its a dedicated server.

[raubin]

can I go into the admin whilst i am in the middle of the upgrade?

[snakes1100]

You should use phpmyadmin or in ssh myisamchk -r to repair it.

[raubin]

Its not having any of it, keeps coming back with error in phpmyadmin, will need to read up how to do it properly, thanks for your help.

[ComputerVitals]

yeah.

Log into you phpmyAdmin and run this command


ALTER TABLE `adminmessage` CHANGE `adminmessageid` `adminmessageid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;


If you have a prefix to your database like bb or vB
Then you'll want to change the 'adminmessage' to 'vB_adminmessage'
Notice the vB Change that to what your prefix is.

Once you run that command restart your upgrade and it will pick up where it left off.

[raubin]

Have got it fixed using SQLyog - not me obviously, not that clued up on databases!

But will bookmark this for future reference! Thanks again :D