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 : http://www.xxx.xxx.com/forum/core/ad...r.php?do=list& IP Address : xxx.xxx.xxx.xxx Username : hamish Classname : vB_Database_MySQL MySQL Version : 5.5.30-cll
Has anyone had any such issues, and how did they resolve this?
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 : http://www.xxx.xxx.com/forum/core/ad...r.php?do=list& IP Address : xxx.xxx.xxx.xxx Username : hamish Classname : vB_Database_MySQL MySQL Version : 5.5.30-cll
Has anyone had any such issues, and how did they resolve this?