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.
Hi. 

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 'm.id' in 'field list'
Query:
SELECT mr.*, IF(mr.is_group = 1, m.id, mr.member_id) as member_id FROM ibf_moderators mr LEFT JOIN ibf_members m ON(mr.group_id = m.mgroup) LIMIT 0, 1000

Screenshot: http://puu.sh/jSRH8/76befd5d4c.png

Thank you
Unfortunately I hadn't yet time to rework the moderation modules, they're all not properly working: https://github.com/mybb/merge-system/issues/180
However you could try this change which should fix the SQL error. Not sure though whether they're merged correctly afterwards: https://github.com/mybb/merge-system/pull/181
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.