MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'forum_forums.mybb_moderators' doesn't exist
Query:
SELECT m.mid, m.uid, u.username FROM mybb_moderators m LEFT JOIN mybb_users u ON (m.uid=u.uid) WHERE fid='29'

How can i restore it or inject a new one, im assuming its in phpmyadmin.

Just create a table called mybb_moderators

What fields needs to be in it?

I'm not that sure tbh, let me check the wiki.

Alrighty.

(2010-09-05, 07:44 PM)Kaleb M Wrote: [ -> ]What fields needs to be in it?

http://wiki.mybb.com/index.php/Database_...moderators

Woot. Good job guys and thanks!

Thought i was done, but once i enter the username of the mod i get a new error.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'm.isgroup' in 'where clause'
Query:
SELECT m.*, u.username, u.usergroup, u.displaygroup FROM mybb_moderators m LEFT JOIN mybb_users u ON (m.id=u.uid) WHERE m.isgroup = '0' ORDER BY u.username

Have you recently added any plugins to your forum?? You shouldn't be missing this number of core tables.

The Wiki is out of date, sorry.

[attachment=19757]