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 <muiruny...@gmail.com> Date: 07/11/2019 10:20 (GMT+03:00) To:
Chris Cormack <chr...@catalyst.net.nz> Cc: koha <koha@lists.katipo.co.nz>,
koha-de...@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 <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
