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 <muiruny...@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 <chr...@catalyst.net.nz> Date: 06/11/2019
> 21:18 (GMT+03:00) To: koha@lists.katipo.co.nz, muirunyeri <
> muiruny...@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.alv...@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 <muiruny...@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 <vikramczadgaon...@gmail.com> Date:
> 04/11/2019 07:34 (GMT+03:00) To: muirunyeri <muiruny...@gmail.com> Cc:
> Owen Leonard <oleon...@myacpl.org>, koha <koha@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 <muiruny...@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 <oleon...@myacpl.org> Date: 31/10/2019 14:43
> (GMT+03:00) To: muiru james <muiruny...@gmail.com> Cc: koha <
> koha@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@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
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
> _______________________________________________
> 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
