Bug 17328

Summary: Koha fixes for Mysql 5.7
Product: Koha Reporter: Blou <philippe.blouin>
Component: MARC Bibliographic record staging/importAssignee: Blou <philippe.blouin>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: eric.begin, francois.charbonnier, jonathan.druart, mtj, ztajoli
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20144
Change sponsored?: --- Patch complexity: Trivial patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 17258    
Attachments: Bug 17328 - import_records.marcxml_old requires a value
Bug 17328 - borrowers.flags must be passed an integer.
Bug 17328 - categories' many int fields cannot be NULL
Bug 17328 - borrowers.flags must be passed an integer.
Bug 17328 - Borrowers table modifications must provide valid values for int columns

Description Blou 2016-09-22 13:32:32 UTC
I'm accruing many little issues. while running the code.  I'll put the patches in, at least to document them.  If the powers-that-be decide to fix in differently, all the same to me.
Comment 1 Blou 2016-09-22 14:04:22 UTC
Created attachment 55748 [details] [review]
Bug 17328 - import_records.marcxml_old requires a value

https://bugs.koha-community.org/show_bug.cgi?id=17238
Comment 2 Blou 2016-09-22 14:07:26 UTC
Created attachment 55749 [details] [review]
Bug 17328 - borrowers.flags must be passed an integer.
Comment 3 Blou 2016-09-22 14:27:12 UTC
Created attachment 55751 [details] [review]
Bug 17328 - categories' many int fields cannot be NULL

This fixes the code, but the DB should also be fixed with default values.
Comment 4 Zeno Tajoli 2016-09-22 14:30:05 UTC
Connect to the general bug 17258
Comment 5 Blou 2016-09-22 14:32:51 UTC
Created attachment 55752 [details] [review]
Bug 17328 - borrowers.flags must be passed an integer.
Comment 6 Blou 2016-09-27 13:17:11 UTC
Created attachment 55841 [details] [review]
Bug 17328 - Borrowers table modifications must provide valid values for int columns
Comment 7 Blou 2016-09-27 13:18:08 UTC
Comment on attachment 55752 [details] [review]
Bug 17328 - borrowers.flags must be passed an integer.

now cover the other fields from table borrowers.
Comment 8 Blou 2016-09-27 13:46:40 UTC
too... many... issues... Now fighint le size limit on issn.

All of this pointless unless first patching the DB with alters to set default values, then modify the schemas, then modify the code.  Huge task...
Comment 9 Jonathan Druart 2021-10-19 08:55:06 UTC
Need to be moved as a depend bug of bug 17258.

*** This bug has been marked as a duplicate of bug 17258 ***