Summary: | error editing (borrowers, reports) with mysql enterprise | ||
---|---|---|---|
Product: | Koha | Reporter: | Humberto Blanco <hblancoca> |
Component: | Patrons | Assignee: | Bugs List <koha-bugs> |
Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P1 - high | CC: | gmcharlt, hblancoca, jonathan.druart, kyle.m.hall |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 | ||
GIT URL: | Change sponsored?: | --- | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: | ||
Version(s) released in: | Circulation function: | ||
Bug Depends on: | |||
Bug Blocks: | 17258 |
Description
Humberto Blanco
2016-03-17 17:43:33 UTC
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 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. Try disabling STRICT_TRANS_TABLES in your MySQL config file. 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! |