[Koha] [koha] Edited barcodes not saving

Fri Nov 8 02:21:25 NZDT 2019

Hi Muirunyeri

You MUST fix the issue with the duplicated records due to auto_increment
issue before anything.

Follow the instructions on the about/wiki page to fix it.

Once fix that issue, check if your error continues.

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 jeu. 7 nov. 2019 à 02:21, muirunyeri <muirunyeri at gmail.com> a écrit :

> Hi team,
> System information page reports one error which has been there since the
> beginning. The error - Data Problems - Some of your tables have problems
> with their auto_increment values which may lead to data loss. InnoDB does
> not keep auto_increment across SQL server restarts .......
> No other error besides that.
> I hvae one library set to code THK and still there in my libraries group.
> I do note something unusual in the edit items form for an item am trying
> to edit. There are two subfields for permanent location (subfield a) both
> populating the full name of my library and subfield b -current location
> also with the name of my library.
> Should this two similar subfields be there? Surprisingly theres only one
> subfield for permanent location under add new item. A new item is actually
> saving successfully
> Very grateful for any assistance
> James
>
> Sent from my Samsung Galaxy smartphone.-------- Original message
> --------From: Chris Cormack <chrisc at catalyst.net.nz> Date: 06/11/2019
> 21:18  (GMT+03:00) To: koha at lists.katipo.co.nz, muirunyeri <
> muirunyeri at gmail.com> Subject: Re: [Koha] [koha] Edited barcodes not
> saving
> 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.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>