another MySQL error

[Smoothie]

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

[GSHelpBoy]

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

[Smoothie]

Checked the tables access. No forumid there.

[Steve Machol]

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

[GSHelpBoy]

Did you delete it?

[Smoothie]

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

[Steve Machol]

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.

[GSHelpBoy]

Try re-installing your forums.

[Smoothie]

posting over at vb.com now. thanks

[Smoothie]

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

[Xenon]

it should be in both tables ;)

[Smoothie]

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?

[GSHelpBoy]

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.

[Smoothie]

FireFly, please help!

[Xenon]

ok, i'm not firefly, but thats what ya want:
run this query in PHPMyAdmin:
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;

[Smoothie]

Xenon-

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

[Smoothie]

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

[Xenon]

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

[Smoothie]

But, what about access_title?

[Xenon]

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

[Smoothie]

Xenon-

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

[Xenon]

good to here that :)