SQL error in the logs-tab

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



And I am unable to view the logs.

Regards,
Hugo

Read MYSQL Error.

Solution:

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



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



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