MyBB Central

Full Version: Problem while setting mods
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Code:
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 moderator for forum sections. But I'm getting the above error. I'm using latest mybb.
Please help me out.
mybb_moderators table
Code:
C R E A T E T A B L E I F N O T E X I S T S ` m y b b _ m o d e r a t o r s ` (
` m i d ` s m a l l i n t
( 5 ) u n s i g n e d N O T N U L L a u t o _ i n c r e m e n t ,
` f i d ` s m a l l i n t
( 5 ) u n s i g n e d N O T N U L L d e f a u l t ' 0 ' ,
` u i d ` i n t
( 1 0 ) u n s i g n e d N O T N U L L d e f a u l t ' 0 ' ,
` c a n e d i t p o s t s ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
` c a n d e l e t e p o s t s ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
` c a n v i e w i p s ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
` c a n o p e n c l o s e t h r e a d s ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
` c a n m a n a g e t h r e a d s ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
` c a n m o v e t o n o n m o d f o r u m ` i n t
( 1 ) N O T N U L L d e f a u l t ' 0 ' ,
P R I M A R Y K E Y ( ` m i d ` ) ,
K E Y ` u i d ` ( ` u i d ` , ` f i d ` )
) E N G I N E = M y I S A M D E F A U L T C H A R S E T = u t f 8 A U T O _ I N C R E M E N T = 5 3 ;
Check your plugins, you may be running one from 1.4
it wouldn't let him activate the plugin if it was 1.4 and his 1.6 board
If the developer made an error when coding, and did not set the compatibility line correctly, or if OP changed the compatibility line then it would.

Kthx.
Still looking for the solution. Please help!