MyBB Community Forums

Full Version: Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

I'm up to the Moderators module in the merger and receive the following error.
I have since reinstalled MyBB and made a new database in case it was just something 
random that went wrong but still receiving the same error unfortunately. Help please :]
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column '' in 'field list'
SELECT mr.*, IF(mr.is_group = 1,, mr.member_id) as member_id FROM ibf_moderators mr LEFT JOIN ibf_members m ON(mr.group_id = m.mgroup) LIMIT 0, 1000


Thank you
Unfortunately I hadn't yet time to rework the moderation modules, they're all not properly working:
However you could try this change which should fix the SQL error. Not sure though whether they're merged correctly afterwards:
Thanks very much for the quick response, that seems to have fixed things for now :]
The fix in the pull request seems to be working for me.