sqlmode for mysql 5.7.28-ubuntu group by
Posted: Mon Dec 09, 2019 7:51 pm
Hello
I am totally new to NuBuilder. Demo's looked very promissing. Tried to install and got stuck.
After login my main screen was nog complete.
Found in de debug log an error regarding an unallowed group by.
Fixed it by adding to /etc/mysql/my.cnf at the bottom the lines:
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
After changing that my main screen was displayed correctly.
Might help for other mysql unix installers.
Have one debug error left select where = 1.
Is that normal?
I am totally new to NuBuilder. Demo's looked very promissing. Tried to install and got stuck.
After login my main screen was nog complete.
Found in de debug log an error regarding an unallowed group by.
Fixed it by adding to /etc/mysql/my.cnf at the bottom the lines:
[mysqld]
sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
After changing that my main screen was displayed correctly.
Might help for other mysql unix installers.
Have one debug error left select where = 1.
Is that normal?