| Summary: | Editing item's Collection code sets items.cn_sort to NULL | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Paul Milazzo <pgm0203> |
| Component: | Staff interface | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | gmcharlt, jonathan.druart, mkstephens |
| Version: | 20.11 | ||
| Hardware: | Other | ||
| OS: | Linux | ||
| See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27509 | ||
| 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: | |||
| Attachments: | Current Server Information | ||
Hi Paul, Which exact version of Koha are you using? It seems that it's fixed by bug 27509 (that is in 21.05.00, 20.11.02 and 20.05.08) I can confirm that this is fixed by the patch for bug 27509 on 20.05.08. |
Created attachment 117551 [details] Current Server Information Moving a single item to a different collection---by editing the item in the Staff Interface and selecting a different value in the Collection code menu---has the side effect of setting the items.cn_sort field for that item to NULL. As a result, the item disappears from the OPAC shelf browser, and initiating shelf browsing from that item fails. For example, moving Item 681 from ART to NFIC: Before: +------------+-------+--------------------+-----------------------+ | itemnumber | ccode | itemcallnumber | cn_sort | +------------+-------+--------------------+-----------------------+ | 681 | ART | ND553.R45 A4 2010a | ND0553 R45 A4 02010A | +------------+-------+--------------------+-----------------------+ After: +------------+-------+--------------------+---------+ | itemnumber | ccode | itemcallnumber | cn_sort | +------------+-------+--------------------+---------+ | 681 | NFIC | ND553.R45 A4 2010a | NULL | +------------+-------+--------------------+---------+ After manually restoring the content of the items.cn_sort field, the item reappears in the shelf browser in the destination collection. I'm running Koha 20.11 on a Raspberry Pi 4B (it's my personal library). I have ShelfBrowserUsesCcode turned on and use LoC Classification for call numbers. I have attached my current Server Information.