https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27843 Bug ID: 27843 Summary: Editing item's Collection code sets items.cn_sort to NULL Change sponsored?: --- Product: Koha Version: 20.11 Hardware: Other OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Staff Client Assignee: koha-bugs@lists.koha-community.org Reporter: pgm0203@comcast.net QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 117551 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=117551&action=edit 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.