another MySQL error
 

when deleting a forum, I'm getting this:

Invalid SQL: DELETE FROM access WHERE forumid IN (0,116)
mysql error: Unknown column 'forumid' in 'where clause'

mysql error number: 1054

Check the database table `access` to make sure there is a column `forumid.`

Checked the tables access. No forumid there.

Something's wrong with your database then. There should be a forumid column in the access table.

Did you delete it?

Nope. Had this problem since day one with vBulletin. Posted over at vb.com, and never got an response.

If you had this problem all along then something didn't go right when you installed the database. I would post at vb.com and tell them specifically that this column is missing in the access table and ask for the query to get it back.

Try re-installing your forums.

posting over at vb.com now. thanks

If I look in the table forum, there is a field called forumid. Should that be there?

it should be in both tables ;)

so far, no help from the people over at vb.com. Can someone else here tell me what i need to do to get the access table fixed?

Just use phpMyAdmin to create a field on the table with the same properties as the `forumid` field on the other table.

See what that does.

FireFly, please help!

ok, i'm not firefly, but thats what ya want:
run this query in PHPMyAdmin:
[sql]DROP TABLE IF EXISTS access;
CREATE TABLE access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
UNIQUE KEY userid (userid,forumid)
) TYPE=MyISAM;
[/sql]

Xenon-

Thanks a million. Will running that command have any ill effects on the current database?

This is what I have under the access table:
userid, access_title.

it will delete the acces-table, but as you said this error occured since the first day you won't loos any data :)

But, what about access_title?

i don't know the access_title field, i think this has been added with one hack you have installed. if you use this hack, you have to redo the sql-query for this hack

Xenon-

Thanks very much for your help. Ran the MySQL command, and its all good now. :)

good to here that :)