Software error: Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'koha_jeya.me.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/share/koha/lib/Koha/Objects.pm line 120 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.
This looks like a MySQL compatibility error. Are you using MySQL 5.7 or later? See here: https://wiki.koha-community.org/wiki/Koha_on_Debian#Install_the_Database
(In reply to Katrin Fischer from comment #1) > This looks like a MySQL compatibility error. Are you using MySQL 5.7 or > later? > > See here: > https://wiki.koha-community.org/wiki/Koha_on_Debian#Install_the_Database Hi Katrin Fischer, Thanks for your kind reply. Yes I am using mysql on ubuntu but I remember I follow the steps and run the command to install mysql $ sudo apt-get install mysql-server. Do I need to uninstall first before install for apt-get install? So now what can I do? Do i need to reinstall everything or can do some work around to overcome this issue? Thank you, Jeyakumar
I think it's possible to switch to MariaDB, but I am not sure about the steps. Please ask on the mailing list (koha or koha-devel) or on IRC.