another MySQL error

[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:
[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]

[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