No announcement yet.

Fix Unique Indexes Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Fix Unique Indexes Error

    I'm trying to run fix unique indexes to see if that fixes numerous odd issues (can't use page manager in anything other than my own profile settings page, latest activity not working, only parts of page being correctly controlled by layout/colour changes), but get the following error: (xxx entries were edited out by me, the actual error contained correct information)

    Creating unique index... Database error in vBulletin 5.0.5: Invalid SQL: ALTER TABLE access ADD PRIMARY KEY userid (userid, nodeid); MySQL Error : Multiple primary key defined Error Number : 1068 Request Date : Saturday, October 12th 2013 @ 11:01:52 AM Error Date : Saturday, October 12th 2013 @ 11:01:52 AM Script : http:///forum/core/admincp/repair.php?do=fixunique Referrer : IP Address : Username : hamish Classname : vB_Database_MySQL MySQL Version : 5.5.30-cll

    Has anyone had any such issues, and how did they resolve this?

Related Topics