[Koha] [koha] Edited barcodes not saving

[Chris Cormack]

That might also be a problem, but the foreign key error before that definitely is. It means in that item record the value in homebranch doenst match a row in the branches table.
That's why you can't update that item. Try changing the homebranch and save again (maybe try changing all the branch info on that item)

It may be that somehow someone deleted a branch, check in administration, to see if all the libraries/branches are there that you expect to be

Chris 

On 7 November 2019 2:56:32 AM NZDT, Alvaro Cornejo <cornejo.alvaro at gmail.com> wrote:
>Hi Muirunyeri
>
>The query used to update the barcode said it is finding several results
>"...Query returned more than one row..."
>
>This means that, when updating a record, msql is founding several
>records
>to update.... this might seems you have duplicated records in your
>database.
>
>Check on the about page whether you have something about that on system
>status.
>
>Regards,
>
>Alvaro
>
>
>|-----------------------------------------------------------------------------------------------------------------|
>Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>celular y Nextel
>en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
>SMS
>y GPRS online
>              Visitenos en www.perusms.com
>
>
>Le mer. 6 nov. 2019 à 03:37, muirunyeri <muirunyeri at gmail.com> a écrit
>:
>
>>
>> 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
>>
>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>_______________________________________________
>Koha mailing list  http://koha-community.org
>Koha at lists.katipo.co.nz
>https://lists.katipo.co.nz/mailman/listinfo/koha

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.