[Bug 19147] New: Error when create new patron
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 Bug ID: 19147 Summary: Error when create new patron Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs@lists.koha-community.org Reporter: j.jeyakumar@gmail.com QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 Jeyakumar <j.jeyakumar@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |j.jeyakumar@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |katrin.fischer@bsz-bw.de --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 --- Comment #2 from Jeyakumar <j.jeyakumar@gmail.com> --- (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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 giuseppe.angilella@ct.infn.it changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |giuseppe.angilella@ct.infn. | |it -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19147 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org