The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Error when clicking access mask in admincp
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 |
#2
|
|||
|
|||
I don't know why that would happen or what the repair functions actually do, but - Here's part of install/mysql-schema.php:
Code:
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) ) |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
Quote:
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. |
#5
|
|||
|
|||
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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|