I tried upgrading. It took more than 30 minutes on part 12, so I restarted the upgrade. It did not work. I got this error at the end of my upgrade:
Database error in vBulletin 3.8.4:
and now I am getting this error in my email:
please help
Database error in vBulletin 3.8.4:
Invalid SQL:
ALTER TABLE vb_post ADD INDEX ipaddress (ipaddress);
MySQL Error : Duplicate key name 'ipaddress'
Error Number : -1
Request Date : Friday, March 5th 2010 @ 12:59:00 AM
Error Date : Friday, March 5th 2010 @ 01:10:08 AM
Script : http://www.xxx.com/install/upgrade_400a1.php?step=12
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :
ALTER TABLE vb_post ADD INDEX ipaddress (ipaddress);
MySQL Error : Duplicate key name 'ipaddress'
Error Number : -1
Request Date : Friday, March 5th 2010 @ 12:59:00 AM
Error Date : Friday, March 5th 2010 @ 01:10:08 AM
Script : http://www.xxx.com/install/upgrade_400a1.php?step=12
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,
editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory
FROM vb_post AS post
LEFT JOIN vb_editlog AS editlog ON (editlog.postid = post.postid)
WHERE post.postid = 395903;
MySQL Error : Can't open file: 'vb_post.MYI' (errno: 144)
Error Number : 1016
Request Date : Friday, March 5th 2010 @ 01:39:29 AM
Error Date : Friday, March 5th 2010 @ 01:39:29 AM
Script : http://www.xxx.com/showthread.php?p=395903
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :
Invalid SQL:
SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,
editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory
FROM vb_post AS post
LEFT JOIN vb_editlog AS editlog ON (editlog.postid = post.postid)
WHERE post.postid = 395903;
MySQL Error : Can't open file: 'vb_post.MYI' (errno: 144)
Error Number : 1016
Request Date : Friday, March 5th 2010 @ 01:39:29 AM
Error Date : Friday, March 5th 2010 @ 01:39:29 AM
Script : http://www.xxx.com/showthread.php?p=395903
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :