Hi Bruck,
that's a wild guess now, but it's something we have seen happen: an
extra space somewhere will not show in your SQL queries and results -
branchcodes with and without will even group together. But Perl notices
the difference when comparing strings. Say Koha finds "WIDER" in the
item, but your configured branch is "WIDER " - then it will attempt to
send it to the latter and put the item 'in transit'.
I am not quite sure how to best check for that, something along these
lines might work:
SELECT * from items WHERE
CHAR_LENGTH(homebranch) != CHAR_LENGTH("WIDER")
OR CHAR_LENGTH(holding) != CHAR_LENGTH("WIDER");
SELECT * from branches WHERE CHAR_LENGTH(branchcode) !=
CHAR_LENGTH("WIDER")
Also: Check if you have default values set for $a $b in your frameworks
and if there are any extra spaces there.
Hope this helps,
Katrin
||
On 15.01.20 11:09, Tadesse, Bruck wrote:
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