[Koha-devel] [Koha] [koha] Edited barcodes not saving

Jonathan Druart jonathan.druart at bugs.koha-community.org
Thu Nov 21 11:48:31 CET 2019 

Or, better: `koha-zebra --status $INSTANCE`

Le mer. 20 nov. 2019 à 20:33, Alvaro Cornejo
<cornejo.alvaro at gmail.com> a écrit :
>
> Hi
>
> Have you checked if zebra is running?
>
> use:
>
> ps -ef  | grep zebra
>
> It should give you 4 results.
>
> 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. 20 nov. 2019 à 04:09, muirunyeri <muirunyeri at gmail.com> a écrit :
>
> > Hello Chris and all,
> > I have been away for awhile the reason I have not responded to a thread I
> > raised. The issue remains unresolved.
> > I cleared the DBMS autoincrement error and from the system information
> > page there's no warning. Barcodes and item edits are still not saving. This
> > is really stressing us. The item editor has 2 subfields for permanent
> > location as compared to 1 for add new item something that has not been
> > there.
> > Any assistance will be highly appreciated.
> > Thank you
> >
> >
> > Sent from my Samsung Galaxy smartphone.-------- Original message
> > --------From: muirunyeri <muirunyeri at gmail.com> Date: 07/11/2019  10:20
> > (GMT+03:00) To: Chris Cormack <chrisc at catalyst.net.nz> Cc: koha <
> > koha at lists.katipo.co.nz>, koha-devel at lists.koha-community.org Subject:
> > [koha] Edited barcodes not saving
> > 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
> >
> _______________________________________________
> 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-devel mailing list