Jump to the post that solved this thread.
Not Solved Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators
#1
Not Solved
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
Reply
#2
Not Solved
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
Support PMs will be ignored!
Reply
#3
Not Solved
Thanks very much for the quick response, that seems to have fixed things for now :]
Reply
#4
Not Solved
The fix in the pull request seems to be working for me.
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)