[Bug 16094] New: error with mysql enterprise
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16094 Bug ID: 16094 Summary: error with mysql enterprise Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: hblancoca@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Hi, when i try to modify an user get this error DBIx::Class::Storage::DBI::_dbh_execute(): Incorrect integer value: '' for column 'guarantorid' at row 1 at /usr/share/koha/lib/C4/Members.pm line 665 i review the sorce code <label for="contactname">Nombre de la institución: </label> [% IF ( guarantorid ) %] <span>[% contactname %]</span> <input name="contactname" id="contactname" type="hidden" size="20" value="[% contactname %]" /> [% ELSE %] <input name="contactname" id="contactname" type="text" size="20" value="[% contactname %]" /> [% END %] but when do not exist guarantor, how can i apply 0 (i think)? thansk for your help. -- 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=16094 Humberto Blanco <hblancoca@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hblancoca@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16094 Humberto Blanco <hblancoca@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|error with mysql enterprise |error editing (borrowers, | |reports) with mysql | |enterprise Priority|P5 - low |P1 - high -- 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=16094 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- I don't understand, are you trying to edit a patron using the Koha interface or the mysql cli? If you want to insert/update a patron using the mysql cli, you need to specify guarantorid=NULL -- 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=16094 --- Comment #2 from Humberto Blanco <hblancoca@gmail.com> --- Hi Jonathan, This errors happend using the Koha interface, occurs when we are testing the koha database in mysql enterprise. Nothing happend in mysql community version. -- 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=16094 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|3.22 |unspecified Severity|blocker |normal --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Try disabling STRICT_TRANS_TABLES in your MySQL config file. -- 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=16094 --- Comment #4 from Humberto Blanco <hblancoca@gmail.com> --- Jonathan, disabling those parameters do not work. Now the variable name sql_mode is empty but the error is the same. I modify the database structure for some of those errors, from example in addorder.pl when creating appear the following error: DBIx::Class::Storage::DBI::_dbh_execute(): Field "budget_group_id" doesn´t have a default value at /usr/share/koha/lib/.... In mysql community i dont have those error but yes in enterprise.then i modify the database structure. ALTER TABLE aqorders ALTER COLUMN budgetgroup_id SET DEFAULT 0; I believe that is needle put this in the update database scripts. Best regards! -- 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=16094 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=13669 -- 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=16094 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 watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16094 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- *** This bug has been marked as a duplicate of bug 17257 *** -- 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