← 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