12 Jan Edited #1

SQL error in the logs-tab

Ultimate subscriber
Hi all!

Whenever I go to the log tab I am getting this error: MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_woanet.l.lid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query:
SELECT l.*, u.username, u.usergroup, u.displaygroup, u.avatar, GROUP_CONCAT(l.type, '|', l.date ORDER BY l.date DESC) types FROM mybb_bankpipe_log l LEFT JOIN mybb_users u ON (u.uid = l.uid) GROUP BY l.invoice ORDER BY l.date DESC LIMIT 0, 20

[Image: z7iU3zj.png]

And I am unable to view the logs.

Regards,
Hugo
Shade 12 Jan
#2
Read MYSQL Error.
Hugo 12 Jan
#3
Solution:

1). Go to phpmyadmin
2). click on variables

[Image: 55061440-a8672200-50d8-11e9-877c-0ac11396c3ee.JPG]

3). Scroll down and search "sql mode"
4). Remove only "ONLY_FULL_GROUP_BY" part

[Image: 55061578-faa84300-50d8-11e9-95b5-32241806ee57.JPG]

Solution found here: https://github.com/coral-erm/coral/issue...-477042892