3.7 upgrade error on step 4 on upgrade
 

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.co...0b2.php?step=4
Referrer : http://www.spanishrealestateforum.co...0b2.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

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.

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

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

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.

yeah.

Log into you phpmyAdmin and run this command

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.

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