Bug 19147

Summary: Error when create new patron
Product: Koha Reporter: Jeyakumar <j.jeyakumar>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: giuseppe.angilella, j.jeyakumar
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Crowdfunding committed: 0
Crowdfunding contact: Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Jeyakumar 2017-08-18 08:10:41 UTC
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.
Comment 1 Katrin Fischer 2017-08-18 10:21:15 UTC
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
Comment 2 Jeyakumar 2017-08-19 12:27:15 UTC
(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
Comment 3 Katrin Fischer 2017-08-19 12:52:07 UTC
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.