Error when clicking access mask in admincp

[jpietrowiak]

Hi All,
Hope someone can help with this. This error comes up when I click the access masks under USER in admincp and we get a vbulletin database error. The forum seems to be running ok but noticed this when I was trying to find something else.

Update: I tried deleting all access masks since I could still get to that link on top and still came up with same error. I also tried my old forum before I moved to new domain and that works ok. So I think it has something to do with moving it and updating links some how in the database. The forum has been running fine for a few weeks now so i don't want to restore backups when I moved it. I was playing with the MYSQL database and manually editing some links to where the forum is now. What can I do to fix it.


Database error in vBulletin 3.8.6:

Invalid SQL:
SELECT COUNT(*) AS count,forumid,accessmask FROM access GROUP BY forumid,accessmask;

MySQL Error : Unknown column 'forumid' in 'field list'
Error Number : 1054

Thanks

--------------- Added [DATE]1292219501[/DATE] at [TIME]1292219501[/TIME] ---------------

Ok tried going through some of the other stuff for repairing this problem. I also have the same thing occur when I click under maintenance to "Fix Unique Indexes" same error occurs.

Invalid SQL:
SELECT userid, forumid, COUNT(*) AS occurences
FROM access
GROUP BY userid, forumid
HAVING occurences > 1;

MySQL Error : Unknown column 'userid' in 'field list'
Error Number : 1054