| 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 |
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | 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! |