[Koha] [koha] Edited barcodes not saving
muirunyeri
muirunyeri at gmail.com
Wed Nov 6 21:36:47 NZDT 2019
Hi Vikram and team,
Below is the error log I tried copying.
AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: ERROR in _koha_modify_item UPDATE items SET stack=?,price=?,itemnotes_nonpublic=?,replacementprice=?,notforloan=?,enumchron=?,stocknumber=?,itemnotes=?,withdrawn_on=?,datelastseen=?,dateaccessioned=?,restricted=?,copynumber=?,homebranch=?,barcode=?,ccode=?,replacementpricedate=?,holdingbranch=?,coded_location_qualifier=?,location=?,itemlost=?,materials=?,uri=?,booksellerid=?,itemcallnumber=?,itype=?,more_subfields_xml=?,permanent_location=?,items.cn_source=?,damaged=?,itemlost_on=?,withdrawn=?,items.cn_sort=? WHERE itemnumber=?: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Items.pm line 2029.: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=53332&itemnumber=19020&searchid=
[Tue Nov 05 14:38:12.848114 2019] [cgi:error] [pid 2832] [client 192.168.67.5:56592] AH01215: [Tue Nov 5 14:38:12 2019] additem.pl: DBIx::Class::Storage::DBI::select_single(): Query returned more than one row. SQL that returns multiple rows is DEPRECATED for ->find and ->single at /usr/share/koha/lib/Koha/Objects.pm line 92: /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl, referer: http://192.168.67.5:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=53332&itemnumber=19020&searchid=
Any assistance will be highly appreciated.
Sent from my Samsung Galaxy smartphone.-------- Original message --------From: vikram zadgaonkar <vikramczadgaonkar at gmail.com> Date: 04/11/2019 07:34 (GMT+03:00) To: muirunyeri <muirunyeri at gmail.com> Cc: Owen Leonard <oleonard at myacpl.org>, koha <koha at lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes not saving
Will you be able to share screen shot of the error.
Vikram Zadgaonkar
On Mon, Nov 4, 2019 at 10:00 AM muirunyeri <muirunyeri at gmail.com> wrote:
Hello Owen,
Thanks for getting back to me on my query and sorry for not replying sooner.
We are using version 17.05.
There are no upgrades to koha, Mysql or the server. There are no changes whatsoever and no one has accessed the server.
Kindly guide me on how to access the error logs and I will do so.
Am very grateful for any assistance
Thank you
Sent from my Samsung Galaxy smartphone.-------- Original message --------From: Owen Leonard <oleonard at myacpl.org> Date: 31/10/2019 14:43 (GMT+03:00) To: muiru james <muirunyeri at gmail.com> Cc: koha <koha at lists.katipo.co.nz> Subject: Re: [Koha] [koha] Edited barcodes not saving
> Over the last few days, the new barcode is not saving i.e. after
> saving the old number is still showing instead of the new one.
What version of Koha are you using? Has anything changed which might
be linked to this problem? A server upgrade, Koha upgrade, MySQL
upgrade?
Do you have access to Koha's error logs?
-- Owen
--
Web Developer
Athens County Public Libraries
(740) 737-6006
https://www.myacpl.org
_______________________________________________
Koha mailing list http://koha-community.org
Koha at lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
More information about the Koha
mailing list