2018-06-08, 11:42 PM
Hi, i am currently trying to make this plugin still work on mybb 1.8.15 but it appears i can't watch the profile of any user that used the invitation system to register. I receive this error.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1140 - In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'users.mybb_invitecodes.createdby'; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT COUNT(*) as
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1140 - In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'users.mybb_invitecodes.createdby'; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT COUNT(*) as
count, createdby FROM mybb_invitecodes WHERE code='gUGJvACD'