Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Unknown column 'm.mid' in 'field list'
#1
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 Wink
#2
Anybody?
Up-to-date...
up-to-date again Undecided
Up-to-date Sad
#3
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
#4
(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 Wink Uzun zamandır halledilmemişti, işin içinden sen çıktın Big Grin

Thanks a lot for your help Wink


Forum Jump:


Users browsing this thread: 1 Guest(s)