Hi Katrin, Thanks, please see below the result of the queries. After encountering the problem, we added a value (the same value as our home branch since we only have one library) to the branch in the backend. The system picks it as a separate entity and a checked in item is set to ‘in transit’. Somehow, adding the branch value cause another issue in our check-in. And it did not resolve our existing branch problem. All these functions were working well before our upgrade.
******************************************* mysql> select homebranch, holdingbranch from items group by homebranch, holdingbranch; +------------+---------------+ | homebranch | holdingbranch | +------------+---------------+ | WIDER | WIDER | +------------+---------------+ ******************************************************* mysql> select frameworkcode, tagfield, tagsubfield, authorised_value from marc_subfield_structure where authorised_value = 'branches'; +---------------+----------+-------------+------------------+ | frameworkcode | tagfield | tagsubfield | authorised_value | +---------------+----------+-------------+------------------+ | | 952 | a | branches | | | 952 | b | branches | | AR | 952 | a | branches | | AR | 952 | b | branches | | BKS | 952 | a | branches | | BKS | 952 | b | branches | | CD | 952 | a | branches | | CD | 952 | b | branches | | DBS | 952 | a | branches | | DBS | 952 | b | branches | | EBK | 952 | a | branches | | EBK | 952 | b | branches | | EBS | 952 | a | branches | | EBS | 952 | b | branches | | EJ | 952 | a | branches | | EJ | 952 | b | branches | | FA | 952 | a | branches | | FA | 952 | b | branches | | ILLS | 952 | a | branches | | ILLS | 952 | b | branches | | IR | 952 | a | branches | | IR | 952 | b | branches | | LD | 952 | a | branches | | LD | 952 | b | branches | | MONO | 952 | a | branches | | MONO | 952 | b | branches | | OECD | 952 | a | branches | | OECD | 952 | b | branches | | OECE | 952 | a | branches | | OECE | 952 | b | branches | | ON | 952 | a | branches | | ON | 952 | b | branches | | PER | 952 | a | branches | | PER | 952 | b | branches | | WID | 952 | a | branches | | WID | 952 | b | branches | +---------------+----------+-------------+------------------+ Thanks, Bruck T. -----Original Message----- From: Katrin Fischer <katrin.fischer...@web.de> Sent: Wednesday, January 15, 2020 9:11 AM To: Tadesse, Bruck <br...@wider.unu.edu> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Software error: Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. Hi Bruck, first thing that comes to mind is if you have modified your frameworks from the default, especially the 952 fields? Some things that could be interesting: select homebranch, holdingbranch from items group by homebranch, holdingbranch; You should then see if there are values that are not valid branchcodes in your system. What does the configuration of your 952 fields look like? Especially $a and $b? select tagfield, tagsubfield from marc_subfield_structure where authorised_value="branches"; What does your item form look like? For example you can compare it to one of our demo installations that should be closer to default. Maybe this could get you a step closer. Katrin On 13.01.20 14:11, Tadesse, Bruck wrote: > Hi Jonathan and Katrin, > > Happy New Year! The problem with our Koha instances still is not resolved. We > are still unable to edit items. Since you know the problem already, I am > turning to you again for help. > > Many thanks, > Bruck T. > > > -----Original Message----- > From: Koha <koha-boun...@lists.katipo.co.nz> On Behalf Of Tadesse, > Bruck > Sent: Thursday, December 19, 2019 2:11 PM > To: Katrin Fischer <katrin.fischer...@web.de> > Cc: koha@lists.katipo.co.nz > Subject: Re: [Koha] Software error: Can't call method "branchname" on an > undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > Hi Katrin, > > Thanks, I have never used a client for IRC, but I will try pidgin. What would > be the address then? Is it irc.oftc.net:6667 ? > > thanks, > Bruck T > > From: Katrin Fischer <katrin.fischer...@web.de> > Sent: Thursday, December 19, 2019 12:21 PM > To: Tadesse, Bruck <br...@wider.unu.edu> > Cc: Jonathan Druart <jonathan.dru...@bugs.koha-community.org>; > koha@lists.katipo.co.nz > Subject: Aw: Re: [Koha] Software error: Can't call method "branchname" on an > undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > > Hi Bruck, > > the web link hasn't worked for me in a while - the #koha tab doesn't open and > only the status one is shown for me. Do you have access to a program like > pidgin or another IRC client maybe that you could use instead? > > Katrin > > Gesendet: Donnerstag, 19. Dezember 2019 um 11:03 Uhr > Von: "Tadesse, Bruck" > <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> > An: "Jonathan Druart" > <jonathan.dru...@bugs.koha-community.org<mailto:jonathan.druart@bugs.k > oha-community.org>> > Cc: "koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>" > <koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>> > Betreff: Re: [Koha] Software error: Can't call method "branchname" on an > undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > Hi Jonathan, > > I have been connected to this Koha channel > (https://webchat.oftc.net/?channels=koha) through a browser for a while now, > but I do not see any activity. May be I am not in the right, Can you send me > the link to the right channel. > > Many thanks, > Bruck T. > -----Original Message----- > From: Jonathan Druart > <jonathan.dru...@bugs.koha-community.org<mailto:jonathan.druart@bugs.k > oha-community.org>> > Sent: Wednesday, December 18, 2019 6:36 PM > To: Tadesse, Bruck <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> > Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > Subject: Re: [Koha] Software error: Can't call method "branchname" on an > undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. > > I am expecting to see something just before this error. Maybe you did not > restart plack? > Consider jumping into IRC and catch me there, that would be easier ;) > > Le mer. 18 déc. 2019 à 17:09, Tadesse, Bruck > <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> a écrit : >> Jonathan, >> I am not sure if I am looking in the right place and thanks for your patient >> with me. I opened the " intranet-error.log " log file (tail -f >> intranet-error.log) in the backend and see the result below. Could this be >> any helpful. >> >> Thanks. >> Bruck.- >> ********************************* >> [Wed Dec 18 15:59:18.279781 2019] [cgi:error] [pid 19666] [client >> 172.22.3.115:59956] AH01215: [Wed Dec 18 15:59:18 2019] additem.pl: >> Can't call method "branchname" on an undefined value at >> /usr/share/koha/lib/C4/Biblio.pm line 1627.: >> /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: >> http://koha.wider.unu.edu:8080/cgi-bin/koha/catalogue/detail.pl?bibli >> o >> number=8418&searchid=scs_1576671122887 >> >> ********************************* >> -----Original Message----- >> From: Jonathan Druart >> <jonathan.dru...@bugs.koha-community.org<mailto:jonathan.druart@bugs. >> k >> oha-community.org>> >> Sent: Wednesday, December 18, 2019 3:15 PM >> To: Tadesse, Bruck <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> >> Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> >> Subject: Re: [Koha] Software error: Can't call method "branchname" on an >> undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. >> >> Have a look at the Koha log file, you should see the value of $value in it. >> >> Le mer. 18 déc. 2019 à 13:23, Tadesse, Bruck >> <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> a écrit : >>> Jonathan, >>> >>> Thanks, the SQL query returns empty set. I have also added the debug >>> statement just before the line 1627 and there is no change to the error >>> message. Thinking it is a browser cache issue, I changed computer and >>> browser, the debug statement didn’t bring any change to the error message. >>> >>> This is how it looks now in ...C4/biblio.pm >>> #---- branch >>> if ( $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq >>> "branches" ) { warn $value; return >>> Koha::Libraries->find($value)->branchname; >>> } >>> >>> Thanks, >>> Bruck T. >>> >>> -----Original Message----- >>> From: Jonathan Druart >>> <jonathan.dru...@bugs.koha-community.org<mailto:jonathan.druart@bugs >>> .koha-community.org>> >>> Sent: Wednesday, December 18, 2019 1:22 PM >>> To: Tadesse, Bruck <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> >>> Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> >>> Subject: Re: [Koha] Software error: Can't call method "branchname" on an >>> undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. >>> >>> Bruck, >>> >>> My understanding of the error is that you have a field that is mapped with >>> the "authorised value" branches (that's not a real authorised value). But >>> at least one of those field has a value that is not a branchcode defined in >>> your system. >>> >>> The weird thing is that, by default, only item's fields are mapped with >>> "branches", 952$a and 952$b Can you try this SQL query: select tagfield, >>> tagsubfield from marc_subfield_structure where authorised_value="branches" >>> and tagfield != 952; Does it return something? >>> >>> To know which value we are searching search, you could also add a >>> debug statement warn $value; before >>> 1627 return Koha::Libraries->find($value)->branchname; >>> >>> Regards, >>> Jonathan >>> >>> Le mer. 18 déc. 2019 à 11:37, Tadesse, Bruck >>> <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> a écrit : >>>> Dear Karam, >>>> >>>> Thanks, Since the update didn’t result in solving the problem, I will >>>> revert back for now. I have taken a snapshot of the VM, so it easy to do >>>> that. I would still appreciate any advice that would help me resolve the >>>> underlying problem of updating the items. >>>> >>>> Thanks, >>>> Bruck T. >>>> >>>> From: Karam Qubsi >>>> <karamqu...@gmail.com<mailto:karamqu...@gmail.com>> >>>> Sent: Wednesday, December 18, 2019 12:26 PM >>>> To: Tadesse, Bruck >>>> <br...@wider.unu.edu<mailto:br...@wider.unu.edu>> >>>> Cc: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz>; >>>> Allonen, Lay Poh >>>> <allo...@wider.unu.edu<mailto:allo...@wider.unu.edu>> >>>> Subject: Re: [Koha] Software error: Can't call method "branchname" on an >>>> undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627. >>>> >>>> Hello Bruck, >>>> >>>> This query (UPDATE items SET homebranch='LIB', holdingbranch='LIB') ) is >>>> very dangerous. >>>> >>>> This will set all (homebranch and holdingbranch ) in your items table to >>>> be LIB for all items! >>>> >>>> if that is not what you want, then try to retrieve a backup from ( >>>> /var/spool/koha ) or anywhere else you store your backups . >>>> >>>> Please note that LIB should be one of your branches custom code. so are >>>> you sure it is LIB in your Koha installation ? >>>> Regards. >>>> >>>> On Wed, Dec 18, 2019 at 5:27 PM Tadesse, Bruck >>>> <br...@wider.unu.edu<mailto:br...@wider.unu.edu<mailto:br...@wider.unu.edu%3cmailto:br...@wider.unu.edu>>> >>>> wrote: >>>> Hi All, >>>> >>>> I have just recently upgraded to 17.05 from 16.05 and when I try to edit >>>> items on Koha, it throws the following error "Can't call method >>>> "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm >>>> line 1627". I search the archive online saw the advice to update the two >>>> fields<https://lists.katipo.co.nz/public/koha/2017-September/048966.html> >>>> (UPDATE items SET homebranch='LIB', holdingbranch='LIB'). I have done that >>>> and did the full reindex. But, that does not seem to have helped. Please >>>> advise. >>>> >>>> Many thanks, >>>> Bruck Tadesse >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz<mailto:Koha >>>> @lists.katipo.co.nz%3cmailto:Koha@lists.katipo.co.nz>> >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>>> >>>> -- >>>> Karam Qubsi >>>> >>>> _______________________________________________ >>>> Koha mailing list http://koha-community.org >>>> Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> >>>> https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha