PDA

View Full Version : "Fix Unique Indexes" Error - Duplicate key name 'wordid'


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

Steve Machol
Fri 12th Jan '07, 3:27pm
Why are you running "Fix Unique Indexes"? This is not needed unless the indexes have been messed up and from the results you got this is not needed.

Byron
Fri 12th Jan '07, 3:32pm
Is there any problem with my database?

Why does it says "Duplicate key name 'wordid'"?

Steve Machol
Fri 12th Jan '07, 3:40pm
As I said that is because there is nothing wrong with your indexes and you shouldn't be running that anyway. Sorry I didn't make that clear.