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

[kh99]

I don't know why that would happen or what the repair functions actually do, but - Here's part of install/mysql-schema.php:

CREATE TABLE " . TABLE_PREFIX . "access (
	userid INT UNSIGNED NOT NULL DEFAULT '0',
	forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY userid (userid, forumid)
)

So there definitely should be a forumid and userid column. Seeing as that table doesn't have any rows in it (because you said you deleted them all) I think if it were me I might just try to recreate it using the SQL above (replacing the " . TABLE_PREFIX. " with the actual table prefix, of course).

[jpietrowiak]

Now that I am thinking of it. What do you think about me somehow exporting the one table out of my old forum and importing to the moved forum. Think this would mess to much up? I don't know what the access table or mask is even for.

I checked tables and in the current table I have this below

aid int(11) No None AUTO_INCREMENT Browse distinct values Change Drop Primary Unique Index Fulltext
mask varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
type varchar(255) utf8_general_ci No Browse distinct values Change Drop Primary Unique Index Fulltext
status tinyint(4) No 0

In the ok table I have the below

userid int(10) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
forumid smallint(5) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext
accessmask smallint(5) UNSIGNED No 0 Browse distinct values Change Drop Primary Unique Index Fulltext

Any idea what could have added the extra columns and eliminated the good ones? Have not tried to restore or do as you said yet.

[kh99]

Originally Posted by jpietrowiak

Any idea what could have added the extra columns and eliminated the good ones? Have not tried to restore or do as you said yet.

Not really - I mean, I could guess, like maybe an older version of vB was different, or the database you imported to already had a table named access (since the table you have doesn't seem to match any vB table)...or something else you installed after changed it (do you have a table prefix?).

I guess you could import the old table as long as the forumids and userids are the same as the old database (as they would be if you imported the old data into your current db). I'm not absolutely sure but I think that table stores special access "exceptions" for specific users, so unless you had something like that set up then the table was probably empty anyway.

[jpietrowiak]

Thanks for the reply. I tried importing the old access table with no luck. So I ran the sql statement you provided and every thing seems to function correctly the two pages no longer error out when I run them. Hope it does not affect anything like it is. I don't think i had any custom settings in there so it should be ok. But I have to wonder why the values were there and why the other ones were gone as I just moved from one domain & host to another one.

Thanks for your help. Couldn't of done it without ya.

Jamey