IRC log for #koha, 2024-01-29

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time 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 what could be the problem?
01:24 Koha_2024 joined #koha
01:24 Koha_2024 Good Day
01:24 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 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 ... 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 it looks like we are parsing the imports table for the status - I think it might just need to be adapted
09:26 bug 35922
09:26 huginn` 04Bug 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` 04Bug 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 still need the other please
09:51 mtj: ping?
10:11 paulderscheid[m] pong
10:12 ashimema pang
10:14 cait no playing, fixing tests :P
10:15 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 I'm confused by the API tests
10:18 cait the statusß
10:19 ?
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 and also biblio
10:19 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 hm if you are using item-level itypes it shoudl use the record one
10:20 i mean if you set it to biblio
10:20 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 which confused me
10:21 cait hm
10:21 i onder if one is just the item one and the other is item + itemtype calculated?
10:21 * ashimema is confused
10:22 was trying to resurrect bug 28762
10:22 huginn` 04Bug 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 and the effective includs the itemtype
10:31 lds joined #koha
10:33 ashimema wow
10:33 bug 28761 makes me even more confused
10:33 huginn` 04Bug 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 hi cait!
12:11 cait hola tcohen
12:17 do we have a script in 22.11 to find records with faulty XML?
12:17 we can't reindex and I am not sure how to locate it
12:18 tcohen checkNonIndexedBiblios.pl?
12:19 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 just checking for the version
12:20 tcohen yeah
12:20 the code checking records is 4 years old
12:21 it is designed to check for the biblionumber on the MARC
12:21 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 but I really want to get the patch in that prevents them in the first place
12:22 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 or any other suggestions?
12:28 I also have this here... coudl I locate them with SQL maybe? 73701..........................."\x{fffd}" does not map to UTF-8 at
12:29 hm https://www.compart.com/de/unicode/U+FFFD
12:29 ashimema bug 35104
12:29 huginn` 04Bug 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 basically.. $marcxml_error = @_;
12:50 then print that
12:50 but.. it's fairly verbose
12:50 hence I left it out of our script
12:51 wrong windows
12:51 cait yes, you had me confused :)
13:11 tcohen++
13:19 tcohen cait: did you ever reproduce this failures?
13:19 https://jenkins.koha-community[…]Build/testReport/
13:23 cait not locally
13:23 and I did run it
13:24 regressions.t?
13:24 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 I'd not mind some auto-sanitizing there
15:47 tcohen++ ashimema++ thanks for the help and hints :)
15:48 tcohen: you asked about regressions.t earlier:
15:48 t/db_dependent/selenium/regressions.t .. ok
15:48 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 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 https://youtu.be/5-QqJNmNcq4?feature=shared
17:10 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 https://koha-community.org/man[…]ml/searching.html
17:12 ^ for searching and possibly for cataloguing / modifying records I mean
17:12 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 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 They have monthly meetings where you can go and ask questions
17:14 The cataloguing special interest group is meeting this thursday
17:15 krimsonkharne[m] caroline: good point!
17:15 they also have a slack group you can join:
17:15 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 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 <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.

← Previous day | Today | Next day → | Search | Index

koha1