[Koha-bugs] [Bug 21255] New: memberetnry.pl is missing categories in the Category pull-down list

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21255

            Bug ID: 21255
           Summary: memberetnry.pl is missing categories in the Category
                    pull-down list
 Change sponsored?: ---
           Product: Koha
           Version: 18.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: cnighswonger at foundations.edu
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

In some instances, when editing a patron, the Category pulldown under the
"Library management" section is missing categories.

I'm at a loss as to how to accurately describe the problem, but here goes:

1. The given patron's category shows up correctly on every other screen.
2. Navigating to the Patron Detail screen and selecting the edit option for
Library use section results in the Modify Patron screen.
3. The heading on the Modify Patron screen displays the correct category.
4. However, the Category pulldown does not.
5. Furthermore, the pulldown does not even contain the correct category for the
given patron.

Doing a bit of looking around turned up a few things which may or may not be
related. For the given patron:

1. The problem seems to be with the child category.

2. The Koha::Patron::Categories object may contain missing or incorrect
category information. Here is a snip of the object returned for the 'C'
category type by this line
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=members/memberentry.pl;h=cb4d0506ac54258b29fd82602c57a6056cf822ba;hb=HEAD#l634

                                          'attrs' => {
                                                       'bind' => [],
                                                       'join' =>
'categories_branches',
                                                       'order_by' => [
                                                                      
'categorycode'
                                                                     ],
                                                       'where' => {
                                                                   
'category_type' => 'C',
                                                                   
'categories_branches.branchcode' => [
                                                                               
                          'JL',
                                                                               
                          undef
                                                                               
                        ]
                                                                  },
                                                       'alias' => 'me'
                                                     },

3. The underlying data appears to be sound.
4. This was not a problem prior to upgrading a month ago. Unfortunately, I'm
not sure what version this system was at prior to the upgrade.

Maybe this will get the discussion started and someone with more knowledge of
this area of the code can give some direction to it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.