[Bug 16583] New: Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 Bug ID: 16583 Summary: Strangeness in the staff client on ubuntu 16.04 and MySQL 5.7 Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: Linux Status: NEW Severity: major Priority: P2 Component: Staff Client Assignee: koha-bugs@lists.koha-community.org Reporter: liz@catalyst.net.nz QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Have noticed some strangeness with a clean install of Koha on MySQL 5.7: When adding a rule at /cgi-bin/koha/admin/smart-rules.pl, if any box is left empty the first empty field pops an error similar to this: DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'chargeperiod' at row 1 at /usr/share/koha/intranet/cgi-bin/admin/smart-rules.pl line 170 When attempting to add a borrower category, it thinks a duplicate has been added with the resultant error message "An error occurred when inserting this patron category. The patron category might already exist." The code for the category did not already exist. I am reporting this bug on behalf of Son Nguyen - he may choose to add any other information he has to this report. -- 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=16583 Son Nguyen <ngson2000@yahoo.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ngson2000@yahoo.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bgkriegel@gmail.com --- Comment #1 from Bernardo Gonzalez Kriegel <bgkriegel@gmail.com> --- Hi Liz, we'll have plenty of trouble with (In reply to Liz Rea from comment #0)
Have noticed some strangeness with a clean install of Koha on MySQL 5.7:
we'll have plenty of trouble with 5.7
When adding a rule at /cgi-bin/koha/admin/smart-rules.pl, if any box is left empty the first empty field pops an error similar to this:
DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'chargeperiod' at row 1 at /usr/share/koha/intranet/cgi-bin/admin/smart-rules.pl line 170
In this case the problem is that we depended on a type conversion done by MySQL, empty '' string -> 0. In smart-rules.pl for example, every empty box is sent as an empty string to the database, which used to transform that to 0. With 5.7+ version this is not the default behavior :(
When attempting to add a borrower category, it thinks a duplicate has been added with the resultant error message
"An error occurred when inserting this patron category. The patron category might already exist."
There are some cases where the strange use of 'GROUP BY' not really needed triggers the error. This is one of them. Thoughts: a) try to support the 'strict' mode of MySQL 5.7+ b) suggest that anyone interested reconfigure server to a less 'strict' mode c) ignore the problem because is not in Debian, yet. I've patches for these problems, and others not yet reported. Just need to know what are we going to do. -- 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=16583 Ian Palko <library@stas.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |library@stas.org --- Comment #2 from Ian Palko <library@stas.org> --- Have we any consensus on exactly what is to be done with the Koha/MySQL 5.7 difficulties? The source is that while MySQL since 5.1 has had a strict mode, it was only with 5.7 that "strict mode" became default. We're not the only ones with issues. It seems to me that the long-term solution is to cleanup the Koha SQL usage to be more strict, thus avoiding the need of tweaking the config files to make Koha work. An alternate would be to modify the Koha code to always pass SQL through some translator script which would make it conform to strict mode, but that seems a bit sloppy. Perhaps the best immediate solution is to change MySQL config files to make 5.7 it behave like 5.6. In any case, I like Bernardo, would like to know what the wide-spread plan is to make this happen. -- 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=16583 Nicholas van Oudtshoorn <vanoudt@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |vanoudt@gmail.com --- Comment #3 from Nicholas van Oudtshoorn <vanoudt@gmail.com> --- Are there any plans for debian to migrate from MySQL to MariaDB? Latest mariadb works fine with Koha under fedora... -- 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=16583 --- Comment #4 from Ian Palko <library@stas.org> --- (In reply to Nicholas van Oudtshoorn from comment #3)
Are there any plans for debian to migrate from MySQL to MariaDB? Latest mariadb works fine with Koha under fedora...
This is because MariaDB still is configured to accept the less-than-strict way things have been implemented in Koha. Since MySQL 5.1 there has been a strict mode. I would have caused the same problems back then, but "strict mode" was not the default. It became default in 5.7. MySQL 5.7 will work fine with Koha if it is put in the less-strict mode. It also would work fine if we translate the less-than-strict calls into strict calls. It also would work fine if the Koha code is cleaned-up to conform to strict behaviour. The latter seems to me the most preferable long-term solution, since it guarantees future compatibility without hacky fixes. That's a lot of work to do that, however, the first two options would make for a more short-term solution to get Koha running on MySQL 5.7. I don't know that there are plans to move to MariaDB or officially support it. Still, to be clear, this is a MySQL problem, it's a Koha problem. MariaDB simply allows for our less-than-strict implementation, but if it too eventually decides to follow MySQL's lead, we would have the same issues. -- 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=16583 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj@kohaaloha.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16583 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|3.22 |unspecified See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16402, | |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16664, | |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=16573 CC| |jonathan.druart@bugs.koha-c | |ommunity.org -- 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=16583 Nabila <lovenabila@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lovenabila@gmail.com --- Comment #5 from Nabila <lovenabila@gmail.com> --- The Ubuntu 16.04 LTS is not supporting a fresh installation of Koha. I had to revert back to 14.04 LTS and then install a copy which worked for me. I have not tried yet to upgrade the existing Koha Installation of Ubuntu 14.04 LTS to upgrade to 16.04. The error not comes in Acquisition Module but also the following: -- Cannot create New Vendor in Acquisition (Doesn't save the record instead searches the vendor) -- Cannot do the Batch Patron Import (Shows error in DBI.pm file) -- Cannot create any entry that requires Auto Increment of Primary Key. -- Does not load default framework of Cataloging. -- 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=16583 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=17257 -- 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=16583 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17258 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMIBUS] MySQL 5.7 -- 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=16583 M. Tompsett <mtompset@hotmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=17260 CC| |mtompset@hotmail.com -- 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=16583 --- Comment #6 from M. Tompsett <mtompset@hotmail.com> --- (In reply to Nabila from comment #5)
The Ubuntu 16.04 LTS is not supporting a fresh installation of Koha.
With the application of 17260, I was able to get a fresh installation working on the xenial kohadevbox.
The error not comes in Acquisition Module but also the following:
-- Cannot create New Vendor in Acquisition (Doesn't save the record instead searches the vendor) -- Cannot do the Batch Patron Import (Shows error in DBI.pm file) -- Cannot create any entry that requires Auto Increment of Primary Key. -- Does not load default framework of Cataloging.
I propose making this bug one of these things, and creating other bugs for the others. Smaller bugs get pushed through faster. They are also easier to test. -- 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=16583 Zeno Tajoli <z.tajoli@cineca.it> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |z.tajoli@cineca.it --- Comment #7 from Zeno Tajoli <z.tajoli@cineca.it> --- Hi, for who want an immediate solution:
Perhaps the best immediate solution is to change MySQL config files to make 5.7 it behave like 5.6.
Insert in your /etc/mysql/my.conf: [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Source: http://askubuntu.com/questions/811831/whats-the-correct-way-to-revert-mysql-... But is not a long term solution. -- 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=16583 --- Comment #8 from M. Tompsett <mtompset@hotmail.com> --- (In reply to Zeno Tajoli from comment #7)
Insert in your /etc/mysql/my.conf:
This does not fix the software side of the issues, and will not solve the problems long term. And I had to stick it somewhere else to get it to work for me. :) -- 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=16583 --- Comment #9 from Owen Leonard <oleonard@myacpl.org> --- Is this bug still valid? -- 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=16583 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #10 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- We can consider it has been fixed by bug 20229 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org