[Koha-bugs] [Bug 27843] New: Editing item's Collection code sets items.cn_sort to NULL

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: pgm0203 at comcast.net
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at 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.