Bug 25144

Summary: Callnumber browser is broken
Product: Koha Reporter: Nick Clemens (kidclamp) <nick>
Component: CatalogingAssignee: Nick Clemens (kidclamp) <nick>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: jonathan.druart, lucas, m.de.rooy, margaret
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
19.05.10
Circulation function:
Bug Depends on: 18499    
Bug Blocks:    
Attachments: Bug 25144: [19.05.x only] Remove subtitle from query
Bug 25144: [19.05.x only] Remove subtitle from query
Bug 25144: [19.05.x only] Remove subtitle from query

Description Nick Clemens (kidclamp) 2020-04-14 17:09:20 UTC
The SQL in cn_browser.pl refers to biblio.subtitle - this field has been removed

The callnumber browser is broken in master and stable
Comment 1 Katrin Fischer 2020-04-14 17:32:17 UTC
Why would it have been removed? Or do you mean moved from keyword-to-marc-mapping to the new column?
Comment 2 Nick Clemens (kidclamp) 2020-04-14 17:37:21 UTC Comment hidden (obsolete)
Comment 3 Nick Clemens (kidclamp) 2020-04-14 17:53:11 UTC
I had it the wrong way :-) 18499 expects the biblio.subtitle field which doesn't exist in stable, master should be okay
Comment 4 Nick Clemens (kidclamp) 2020-04-15 17:55:12 UTC
Created attachment 103030 [details] [review]
Bug 25144: [19.05.x only] Remove subtitle from query
Comment 5 Lucas Gass (lukeg) 2020-04-15 18:33:00 UTC
Created attachment 103032 [details] [review]
Bug 25144: [19.05.x only] Remove subtitle from query

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Comment 6 Jonathan Druart 2020-04-16 10:22:56 UTC
Created attachment 103068 [details] [review]
Bug 25144: [19.05.x only] Remove subtitle from query

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Comment 7 Lucas Gass (lukeg) 2020-04-16 14:32:39 UTC
backported to 19.05.x for 19.05.10