MyBB Community Forums
Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Merge System Support (https://community.mybb.com/forum-180.html)
+--- Thread: Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators (/thread-176841.html)



Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators - Wishlah - 2015-08-29

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


RE: Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators - Jones H - 2015-08-29

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


RE: Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators - Wishlah - 2015-08-29

Thanks very much for the quick response, that seems to have fixed things for now :]


RE: Merging from IPB 3.4.6 to MyBB 1.8 - SQL Error @ Moderators - FiretronP75 - 2016-06-10

The fix in the pull request seems to be working for me.