[Koha-bugs] [Bug 27964] New: Link to subscription in serial collections view is broken - the field subscriptionid is undefined in the subscription object.

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

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

            Bug ID: 27964
           Summary: Link to subscription in serial collections view is
                    broken - the field subscriptionid is undefined in the
                    subscription object.
 Change sponsored?: ---
           Product: Koha
           Version: 20.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Serials
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: andreas.jonsson at kreablo.se
        QA Contact: testopia at bugs.koha-community.org

The functions C4::Serials::GetSubscription and
C4::Serials::GetSubscriptionsFromBiblionumber return subscriptions where
subscriptionid is undefined when the subscription have no subscription history.

The database queries use wildcards to include fields from a left joined table.
subscriptionhistory.subscriptionid will be NULL, which might be the value
choosen as the field subscriptionid.

How the field is chosen may depend on the version of DBI as this problem was
discovered after an upgrade to Ubuntu Focal Fossa from Bionic Beaver.

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