Browsed by
Tag: MySQL

MariaDB/MySQL group by error

MariaDB/MySQL group by error

After we upgraded our MySql/MariaDB installation to 5.7.16 our CiviCRM gave us some “unknown DB errors”. We traced it back to a group by error thrown by MySql. As of version 5.7.5 the default SQL modes includes the ONLY_FULL_GROUP_BY option. To fix this issue you can of course change your code, but if that isn’t an option, you can remove this mode setting. First select your existing modes: mysql> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; This will output all enabled modes. Copy both…

Read More Read More