Yet Another Database Error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sinjix_media
    Senior Member
    • Apr 2006
    • 199
    • 3.5.x

    Yet Another Database Error

    Code:
    Database error in vBulletin 3.6.8:
    
    Invalid SQL:
    ALTER TABLE forumpermission ADD UNIQUE KEY ugid_fid (usergroupid, forumid);
    
    MySQL Error  : Duplicate key name 'ugid_fid'
    Error Number : 1061
    Date         : Thursday, November 29th 2007 @ 03:42:43 PM
    Script       : http://www.forums.ny-dev.com/admincp/repair.php?do=fixunique
    Referrer     : http://www.forums.ny-dev.com/admincp/repair.php?do=list
    IP Address   : ip.ipp.ipp.ip
    Username     : username
    Classname    : database
    3D Resources - A list of resources for 3D Developers
    After Effects Resources - A list of resources for design in motion with Adobe After Effects
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74132

    #2
    That key already exists. You should be able to disregard this error. Did a staff member tell you to run the fix unique indexes autorepair? This shouldn't have to be run regularly.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...