Page 1 of 1

sqlmode for mysql 5.7.28-ubuntu group by

Posted: Mon Dec 09, 2019 7:51 pm
by jtoonen
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?

Re: sqlmode for mysql 5.7.28-ubuntu group by

Posted: Mon Dec 09, 2019 9:56 pm
by Janusz
Hi,
I am using Debian and did not observed any issues as you are describing.
No special settings in mysqld.
I had some problems when testing some time ago on Windows with XAMPP
https://forums.nubuilder.cloud/viewtopic. ... ows#p18804

Anyway linux is a good choice - I have some applications on Debian and on Windows server. On debian it works great - on windows there is some delay in response - you can get used to it - but difference is visible when you have side by side both versions.

fyi - configuration of my debian server
apache2 2.4.38-3+deb10u3
PHP 7.3.12-1+0~20191128.49+debian10
mysql Ver 15.1 Distrib 10.4.10-MariaDB, for debian-linux-gnu