Byron
Fri 12th Jan '07, 3:11pm
I upgraded to the latest version. When I try to run "Fix Unique Indexes", I get the following error. Please help.
Fix Unique Indexes
Table access already has a unique index
Table adminhelp already has a unique index
Table attachmentpermission already has a unique index
Table bbcode already has a unique index
Table forumpermission already has a unique index
Table phrase already has a unique index
Replacing unique index on table postindex
Creating unique index...
Database error in vBulletin 3.6.4:
Invalid SQL:
ALTER TABLE postindex ADD UNIQUE KEY wordid (wordid, postid);
MySQL Error : Duplicate key name 'wordid'
Error Number : 1061
Date : Friday, January 12th 2007 @ 11:02:55 AM
Script : http://www.****.com/forums/admincp/repair.php?do=fixunique
Referrer : http://www.****.com/forums/admincp/repair.php?do=list
Fix Unique Indexes
Table access already has a unique index
Table adminhelp already has a unique index
Table attachmentpermission already has a unique index
Table bbcode already has a unique index
Table forumpermission already has a unique index
Table phrase already has a unique index
Replacing unique index on table postindex
Creating unique index...
Database error in vBulletin 3.6.4:
Invalid SQL:
ALTER TABLE postindex ADD UNIQUE KEY wordid (wordid, postid);
MySQL Error : Duplicate key name 'wordid'
Error Number : 1061
Date : Friday, January 12th 2007 @ 11:02:55 AM
Script : http://www.****.com/forums/admincp/repair.php?do=fixunique
Referrer : http://www.****.com/forums/admincp/repair.php?do=list