Bug 24742

Summary: Can't save news item in strict mode without value in number field
Product: Koha Reporter: Owen Leonard <oleonard>
Component: ToolsAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: jonathan.druart, katrin.fischer
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22544
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 17258    

Description Owen Leonard 2020-02-27 13:58:32 UTC
If strict mode is enabled, you can't save a news item without putting a number in the "Appears in position" field. The operation fails silently and this error appears in the log:

DBD::mysql::st execute failed: Incorrect integer value: '' for column 'number' at row 1 [for Statement "UPDATE opac_news SET number = ?,expirationdate = ?,lang = ?,timestamp = ?,title = ?,branchcode = ?,content = ? WHERE idnew = ?;" with ParamValues: 0="", ... ] at /kohadevbox/koha/C4/NewsChannels.pm line 106.
Comment 1 Jonathan Druart 2020-03-16 11:36:16 UTC
Will certainly be fixed by bug 22544
Comment 2 Owen Leonard 2020-08-10 13:34:04 UTC

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