| Time |
S |
Nick |
Message |
| 01:18 |
|
|
schnydszch joined #koha |
| 01:23 |
|
schnydszch |
Hello! In Koha 23.11, when rebuilding zebra, we are getting this error: .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/Biblio.pm line 94 |
| 01:23 |
|
schnydszch |
what could be the problem? |
| 01:24 |
|
|
Koha_2024 joined #koha |
| 01:24 |
|
Koha_2024 |
Good Day |
| 01:24 |
|
Koha_2024 |
In Koha 23.11, when rebuilding zebra, we are getting this error: .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/Biblio.pm line 94 |
| 01:24 |
|
Koha_2024 |
can someone help me with our problem? |
| 02:56 |
|
|
eugene_ joined #koha |
| 05:07 |
|
|
khall joined #koha |
| 07:23 |
|
|
cait joined #koha |
| 07:27 |
|
|
cait1 joined #koha |
| 07:37 |
|
|
reiveune joined #koha |
| 08:15 |
|
|
fridolin joined #koha |
| 08:15 |
|
fridolin |
yellow |
| 08:18 |
|
|
schnydszch joined #koha |
| 08:30 |
|
krimsonkharne[m] |
good morning #koha |
| 08:36 |
|
|
WaylonR joined #koha |
| 08:36 |
|
WaylonR |
<jakorosin> "Good morning all. Hope this isn..." <- hiya! Koha has sample frameworks that you could use, Books, CDs etc. Rather useful. I use Koha myself for my own private library at home. |
| 08:39 |
|
krimsonkharne[m] |
jakorosin: you probably also already know this, but while you're cataloguing you can always click on the question mark next to a MARC field to see the LOC definition of that field |
| 08:40 |
|
krimsonkharne[m] |
... if you're not a librarian the LOC terminology can be a bit confusing though.. ;-) |
| 08:50 |
|
* cait1 |
waves |
| 09:00 |
|
paulderscheid[m] |
morning #koha |
| 09:03 |
|
schnydszch |
good afternoon on my side! :) |
| 09:15 |
|
|
eugene_ joined #koha |
| 09:17 |
|
cait |
lively Monday morning here |
| 09:19 |
|
ashimema |
lol |
| 09:20 |
|
cait |
Please check RM_priority - I need some help with the failing tests from Datatables |
| 09:26 |
|
cait |
it looks like we are parsing the imports table for the status - I think it might just need to be adapted |
| 09:26 |
|
cait |
bug 35922 |
| 09:26 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=35922 critical, P5 - low, ---, chris, NEW , t/db_dependent/www/batch.t is failing |
| 09:43 |
|
cait |
Joubu: grabbing the follow-up from bug 34913 |
| 09:43 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=34913 normal, P5 - low, ---, oleonard, Pushed to master , Upgrade DataTables from 1.10.18 to 1.13.6 |
| 09:43 |
|
cait |
Joubu++ |
| 09:43 |
|
cait |
still need the other please |
| 09:51 |
|
cait |
mtj: ping? |
| 10:11 |
|
paulderscheid[m] |
pong |
| 10:12 |
|
ashimema |
pang |
| 10:14 |
|
cait |
no playing, fixing tests :P |
| 10:15 |
|
cait |
I am working on the bug fixes right now - but I won't push enh before it's fixed |
| 10:18 |
|
ashimema |
how should item not for loan work |
| 10:18 |
|
ashimema |
I'm confused by the API tests |
| 10:18 |
|
cait |
the statusß |
| 10:19 |
|
cait |
? |
| 10:19 |
|
ashimema |
indeed |
| 10:19 |
|
cait |
you can't check it out, unless the override pref is active and you override |
| 10:19 |
|
ashimema |
seems we have notforloan as an item field |
| 10:19 |
|
ashimema |
and also biblio |
| 10:19 |
|
ashimema |
and also itype |
| 10:19 |
|
cait |
and i#d say that would only apply to staff - no checkout at all on sco/sip |
| 10:19 |
|
ashimema |
sorry.. I meant how does it all apply effective itype wise |
| 10:19 |
|
cait |
same for an itemtype that is not for loan |
| 10:20 |
|
cait |
hm if you are using item-level itypes it shoudl use the record one |
| 10:20 |
|
cait |
i mean if you set it to biblio |
| 10:20 |
|
cait |
if you use itemtypes on item level, it should not care about the record itype |
| 10:20 |
|
ashimema |
we appear to return both in the API responses.. 'not_for_loan_status' and 'effective_not_for_loan_status' and they can differ |
| 10:20 |
|
ashimema |
which confused me |
| 10:21 |
|
cait |
hm |
| 10:21 |
|
cait |
i onder if one is just the item one and the other is item + itemtype calculated? |
| 10:21 |
|
* ashimema |
is confused |
| 10:22 |
|
* ashimema |
was trying to resurrect bug 28762 |
| 10:22 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=28762 normal, P5 - low, ---, lucas, Signed Off , Item status shows incorrectly on course-details.pl |
| 10:22 |
|
cait |
is not_for_loan_status maybe the item's not for loan |
| 10:22 |
|
cait |
and the effective includs the itemtype |
| 10:31 |
|
|
lds joined #koha |
| 10:33 |
|
ashimema |
wow |
| 10:33 |
|
ashimema |
bug 28761 makes me even more confused |
| 10:33 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=28761 normal, P5 - low, ---, lucas, Failed QA , Item status shows incorrectly on opac-course-details.pl |
| 11:05 |
|
|
schnydszch joined #koha |
| 11:39 |
|
|
oleonard joined #koha |
| 11:40 |
|
oleonard |
Hi #koha |
| 11:58 |
|
cait |
hi oleonard |
| 12:11 |
|
tcohen |
hola #koha o/ |
| 12:11 |
|
tcohen |
hi cait! |
| 12:11 |
|
cait |
hola tcohen |
| 12:17 |
|
cait |
do we have a script in 22.11 to find records with faulty XML? |
| 12:17 |
|
cait |
we can't reindex and I am not sure how to locate it |
| 12:18 |
|
tcohen |
checkNonIndexedBiblios.pl? |
| 12:19 |
|
tcohen |
I don't know, I guess we can write a simple one |
| 12:19 |
|
cait |
it looks like maybe search_for_data_inconsistencies can do it |
| 12:19 |
|
cait |
just checking for the version |
| 12:20 |
|
tcohen |
yeah |
| 12:20 |
|
tcohen |
the code checking records is 4 years old |
| 12:21 |
|
tcohen |
it is designed to check for the biblionumber on the MARC |
| 12:21 |
|
tcohen |
but in effect, line 129 makes it report decoding errors |
| 12:21 |
|
ashimema |
I have a script that fixes the xml chars stuff |
| 12:22 |
|
ashimema |
but I really want to get the patch in that prevents them in the first place |
| 12:22 |
|
ashimema |
but it got stuck/vitod |
| 12:22 |
|
tcohen |
which bug? |
| 12:25 |
|
cait |
we have a database with broken records - so not looking for prevention right now |
| 12:25 |
|
tcohen |
production, understood |
| 12:27 |
|
cait |
so do you thnk the search_for_data_inconsistencies is a good idea? |
| 12:27 |
|
cait |
or any other suggestions? |
| 12:28 |
|
cait |
I also have this here... coudl I locate them with SQL maybe? 73701..........................."\x{fffd}" does not map to UTF-8 at |
| 12:29 |
|
cait |
hm https://www.compart.com/de/unicode/U+FFFD |
| 12:29 |
|
ashimema |
bug 35104 |
| 12:29 |
|
huginn` |
Bug https://bugs.koha-community.or[…]_bug.cgi?id=35104 enhancement, P5 - low, ---, martin.renvoize, Needs Signoff , We should warn when attempting to save MARC records that contain characters invalid in XML |
| 12:29 |
|
ashimema |
I think |
| 12:50 |
|
ashimema |
basically.. $marcxml_error = @_; |
| 12:50 |
|
ashimema |
then print that |
| 12:50 |
|
ashimema |
but.. it's fairly verbose |
| 12:50 |
|
ashimema |
hence I left it out of our script |
| 12:51 |
|
ashimema |
wrong windows |
| 12:51 |
|
cait |
yes, you had me confused :) |
| 13:11 |
|
cait |
tcohen++ |
| 13:19 |
|
tcohen |
cait: did you ever reproduce this failures? |
| 13:19 |
|
tcohen |
https://jenkins.koha-community[…]Build/testReport/ |
| 13:23 |
|
cait |
not locally |
| 13:23 |
|
cait |
and I did run it |
| 13:24 |
|
cait |
regressions.t? |
| 13:24 |
|
cait |
i am running it now |
| 13:25 |
|
|
fridolin joined #koha |
| 13:30 |
|
|
Awazez joined #koha |
| 14:07 |
|
|
emlam joined #koha |
| 14:27 |
|
|
Dyrcona joined #koha |
| 15:29 |
|
cait |
for info: the broken records got imported through staged import |
| 15:29 |
|
cait |
I'd not mind some auto-sanitizing there |
| 15:47 |
|
cait |
tcohen++ ashimema++ thanks for the help and hints :) |
| 15:48 |
|
cait |
tcohen: you asked about regressions.t earlier: |
| 15:48 |
|
cait |
t/db_dependent/selenium/regressions.t .. ok |
| 15:48 |
|
cait |
All tests successful. |
| 16:00 |
|
|
bag joined #koha |
| 16:01 |
|
reiveune |
bye |
| 16:01 |
|
|
reiveune left #koha |
| 16:32 |
|
|
fridolin left #koha |
| 16:32 |
|
|
lukeg joined #koha |
| 16:33 |
|
lukeg |
hi |
| 16:33 |
|
caroline |
good morning lukeg! |
| 16:51 |
|
* cait |
waves |
| 16:51 |
|
cait |
@later ping mtj |
| 16:51 |
|
huginn` |
cait: downloading the Perl source |
| 16:51 |
|
cait |
@later tell mtj ping :) |
| 16:51 |
|
huginn` |
cait: The operation succeeded. |
| 17:07 |
|
JasonGreene[m] |
I did some searching and I can't find... Is there an online video on how to search, find and update book entries? |
| 17:07 |
|
JasonGreene[m] |
We are new to Koha and we added several thousand books to our new system. Now we need to edit each one and add missing information. - -thanks |
| 17:10 |
|
krimsonkharne[m] |
I know one of the Monday Minutes videos was about item searching |
| 17:10 |
|
krimsonkharne[m] |
https://youtu.be/5-QqJNmNcq4?feature=shared |
| 17:10 |
|
krimsonkharne[m] |
it's a bit old though :) |
| 17:11 |
|
JasonGreene[m] |
Thanks... and, is there anyone in Kansas city that I could visit and talk to about using Koha to help understand it? :-) |
| 17:11 |
|
krimsonkharne[m] |
on most topics the manual is always a good place to start: |
| 17:11 |
|
krimsonkharne[m] |
https://koha-community.org/man[…]ml/searching.html |
| 17:12 |
|
krimsonkharne[m] |
^ for searching and possibly for cataloguing / modifying records I mean |
| 17:12 |
|
krimsonkharne[m] |
you might be able to use the batch record modification or batch item modification depending on what exactly you need to change in your records |
| 17:13 |
|
krimsonkharne[m] |
for instance https://koha-community.org/man[…]cord-modification |
| 17:13 |
|
caroline |
JasonGreene[m], maybe koha-us could help They have members in the state of Kansas (not sure about missouri though) https://koha-us.org/ |
| 17:13 |
|
caroline |
They have monthly meetings where you can go and ask questions |
| 17:14 |
|
caroline |
The cataloguing special interest group is meeting this thursday |
| 17:15 |
|
krimsonkharne[m] |
caroline: good point! |
| 17:15 |
|
krimsonkharne[m] |
they also have a slack group you can join: |
| 17:15 |
|
krimsonkharne[m] |
https://koha-us.org/request-ac[…]mmunity-on-slack/ |
| 17:16 |
|
JasonGreene[m] |
Thanks for this info.... Our Manager talked about getting the "patron data" and the "item-level data" on all books |
| 17:16 |
|
JasonGreene[m] |
The system it came from didn't export that data so I think we have to put it in by hand |
| 17:17 |
|
caroline |
oh no, you were not able to export it? :((( |
| 17:18 |
|
JasonGreene[m] |
no. it is software from the 90s. I asked the Co. if I can and have hot heard back yet |
| 18:08 |
|
cait |
bye all |
| 21:29 |
|
|
khall joined #koha |
| 23:51 |
|
|
jakorosin[m] joined #koha |
| 23:51 |
|
jakorosin[m] |
<WaylonR> "hiya! Koha has sample frameworks..." <- Thank you for pointing that out, I had somehow overlooked that section. That'll help a ton. |
| 23:53 |
|
jakorosin[m] |
<krimsonkharne[m]> "... if you're not a librarian..." <- Yep! And I can always google stuff like that, I was just drawing a blank on how to make/find a template that'd work for stuff like LPs and CDs. |
