Bug 19350

Summary: Holds without link in 773 trigger SQL::Abstract::puke
Product: Koha Reporter: Dobrica Pavlinusic <dpavlin>
Component: CatalogingAssignee: Dobrica Pavlinusic <dpavlin>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: critical    
Priority: P1 - high CC: fridolin.somers, jonathan.druart, julian.maurice, katrin.fischer, m.de.rooy, mtj
Version: master   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: Small patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Bug 19350 - Holds without link in 773 trigger SQL::Abstract::puke
Bug 19350 - Holds without link in 773 trigger SQL::Abstract::puke
Bug 19350: Add tests

Description Dobrica Pavlinusic 2017-09-20 13:58:55 UTC

    
Comment 1 Dobrica Pavlinusic 2017-09-20 15:30:55 UTC
Created attachment 67239 [details] [review]
Bug 19350 - Holds without link in 773 trigger SQL::Abstract::puke

Test:
1. find bibio without items which has something in field 773
   (for us, it's article) but doesn't have 0 or 9 (host item entry)
2. click on hold in left menu
3. verify application error
4. apply patch and verify that it works

Current status: NEW
Comment 2 Josef Moravec 2017-09-22 09:00:35 UTC
Created attachment 67311 [details] [review]
Bug 19350 - Holds without link in 773 trigger SQL::Abstract::puke

Test:
1. find bibio without items which has something in field 773
   (for us, it's article) but doesn't have 0 or 9 (host item entry)
2. click on hold in left menu
3. verify application error
4. apply patch and verify that it works

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Comment 3 Julian Maurice 2017-09-29 08:00:59 UTC
Please write tests.
Comment 4 Dobrica Pavlinusic 2017-10-03 11:46:12 UTC
Unfortunately, my rapidly progressing cataract don't allow me to spend sufficient time to learn how to write code tests for this bug. I was hoping that test scenario will be enough. Sorry.
Comment 5 Jonathan Druart 2017-10-03 15:17:45 UTC
Created attachment 67562 [details] [review]
Bug 19350: Add tests
Comment 6 Jonathan Druart 2017-10-03 15:19:57 UTC
(In reply to Dobrica Pavlinusic from comment #4)
> Unfortunately, my rapidly progressing cataract don't allow me to spend
> sufficient time to learn how to write code tests for this bug. I was hoping
> that test scenario will be enough. Sorry.

Thanks for your patches Dobrica, good to know you are still around :)
Take care.
Comment 7 Jonathan Druart 2017-10-03 18:24:19 UTC
Pushed to master for 17.11, thanks to everybody involved!
Comment 8 Fridolin Somers 2017-10-17 07:26:58 UTC
Pushed to 17.05.x, will be in 17.05.05.
Comment 9 Katrin Fischer 2017-10-18 21:04:34 UTC
This patch has been pushed to 16.11.x and will be in 16.11.13.
Comment 10 Mason James 2017-11-23 23:15:44 UTC
Pushed to 16.05.x, for 16.05.18 release