Page 1 of 1

mysql8 compatibility issue/fix

Posted: Fri Apr 30, 2021 9:56 am
by malc
Posting solution here because I didn't find it.


Dashboard fails to load, everything else works just great. Error logs have:

2021-04-30T09:30:16+00:00 [853634] ERROR default - [User=**** (****@***.com)] Uncaught exception: Exception: There was an error executing your query\nExpression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/rrt/lib/Database/MySQL/MySqlConnection.php:124

Booked: v2.10.1 / mysql Ver 8.0.23-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))


The code in `Database/MySQL/MySqlConnection.php` *tries* to set more relaxed sqlmode, but silently fails because 'NO_AUTO_CREATE_USER' is no longer a valid option.

Code: Select all

Fix (for me@mysql8 at least) - remove the option.

Code: Select all

A more robust fix would be to check the result of that command and fall thru various compatibility options until one works.

Thanks for a great tool,

Re: mysql8 compatibility issue/fix

Posted: Mon May 03, 2021 6:17 pm
by herby1620
Booked 2.10.1??
Shouldn't you talk to the vendor? You paid for it?