MyBB Community Forums

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'm.mid' in 'field list'
Query:
    SELECT m.mid, m.uid, u.username FROM mybb_moderators m LEFT JOIN mybb_users u ON (m.uid=u.uid) WHERE fid='**' 

I'm trying to add chapters moderator but I'm getting the above warning. mybb_moderators template was repaired, I was discharged, but why do I always get the same error. Do you have any idea that the solution?

My forum is 1.4.4 and latin 5

Anybody?

---

Up-to-date...

---

up-to-date again

---

Up-to-date

wrong mybb_moderators table fixed. with

CREATE TABLE IF NOT EXISTS `mybb_moderators` (
  `mid` smallint(5) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `caneditposts` int(1) NOT NULL default '0',
  `candeleteposts` int(1) NOT NULL default '0',
  `canviewips` int(1) NOT NULL default '0',
  `canopenclosethreads` int(1) NOT NULL default '0',
  `canmanagethreads` int(1) NOT NULL default '0',
  `canmovetononmodforum` int(1) NOT NULL default '0',
  PRIMARY KEY  (`mid`),
  KEY `uid` (`uid`,`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

query

(2009-05-07, 10:44 PM)dared Wrote: [ -> ]wrong mybb_moderators table fixed. with

CREATE TABLE IF NOT EXISTS `mybb_moderators` (
  `mid` smallint(5) unsigned NOT NULL auto_increment,
  `fid` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `caneditposts` int(1) NOT NULL default '0',
  `candeleteposts` int(1) NOT NULL default '0',
  `canviewips` int(1) NOT NULL default '0',
  `canopenclosethreads` int(1) NOT NULL default '0',
  `canmanagethreads` int(1) NOT NULL default '0',
  `canmovetononmodforum` int(1) NOT NULL default '0',
  PRIMARY KEY  (`mid`),
  KEY `uid` (`uid`,`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=53 ;

query

Dared, teşekkür ederim tekrardan Uzun zamandır halledilmemişti, işin içinden sen çıktın

Thanks a lot for your help