← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:04 | Kolvir joined #koha | |
| 00:05 | Kolvir | is there anyway to search the mailing list archives seeing as both markmail and nabble links seem down? |
| 00:21 | davidnind | Kolvir: it would seem not, apart from using Google advanced search - put [search term] site:https://lists.katipo.co.nz/pipermail/koha/ in the search box |
| 00:22 | a bit of a shame that markmail isn't available any more - was generally my go to when searching the archives | |
| 00:36 | Kolvir | ok, ty |
| 01:24 | fridolin joined #koha | |
| 03:42 | cait1 joined #koha | |
| 03:59 | alohabot joined #koha | |
| 04:32 | PriyanshuSoni[m] | Guys, can anyone of you please help me out with carousel plugin of inLibro. Why i am not getting scrolling or carousel option while selecting books in list??? |
| 04:33 | I want it to be done quickly.. | |
| 06:01 | thibaud_g joined #koha | |
| 06:21 | magnuse | \o/ |
| 07:08 | dcook joined #koha | |
| 07:27 | fridolin joined #koha | |
| 08:09 | cait joined #koha | |
| 08:16 | ashimema | Morning |
| 09:45 | thibaud_g joined #koha | |
| 09:54 | Zahid[m] | hi, can anyone tell me to add sort1 field in search patron result page, i need this field urgent as this field contains very important data to search and display on result page, it will be very helpful |
| 09:55 | i am using koha 22.11 | |
| 10:05 | AnkeB joined #koha | |
| 10:10 | AnkeB | Hi! Before I file a bug, just a quick question to people using 23.05: On 23.05.02 we see http 500 when trying to edit an existing item via the edit item button. In 22.05 and 22.11 this doesn't occur. Has anyone experienced this, too, or has an idea? Thanks! |
| 10:12 | oleonard | AnkeB: Are you able to see the logs to see what the underlying error might be? |
| 10:13 | AnkeB | oleonard: Would that be the Plack log? |
| 10:14 | oleonard | plack-intranet-error.log maybe? |
| 10:17 | AnkeB | Thanks, I'll look. |
| 10:17 | oleonard | AnkeB: Does it matter which record you try to edit? Or which page you're on when you click the edit button? |
| 10:19 | I did a quick check of 23.05.02 in my test system and wasn't able to reproduce the error | |
| 10:22 | AnkeB | oleonard: I just tried several random items, other than the one the librarian showed me as an example, so I assume it will be the same for any item. In the plack intranet error log I see this: "[2023/08/24 12:21:17] [WARN] DBIx::Class::ResultSetColumn::new(): Attempting to retrieve non-unique column 'biblionumber' on a resultset containing one-to-many joins will return duplicate results. at /usr/share/koha/lib/Koha/Objects.pm line 421". Can that be relev |
| 10:24 | oleonard | AnkeB: I suggest you look at the "About" page under the "System information" tab to see if it warns of data problems |
| 10:26 | AnkeB | oleonard, There is only one entry in the system information tab concerning Authority creation - I don't think that it is relevant here. |
| 10:28 | oleonard, what's more (worse) is that I just found out that I can't edit & save a biblio record in Cataloging - maybe we have a larger problem here... | |
| 10:28 | khall joined #koha | |
| 10:28 | oleonard | AnkeB: I suspect it's some kind of data problem and not a bug in Koha but I don't know how to advise you |
| 10:29 | AnkeB: The error log entry you shared is not the problem, it's just a warning. I see that in my logs too. | |
| 10:30 | AnkeB | Thanks anyway, oleonard - this helped already. I'll see with our MySQL experts and hope to find the error. It was important to know that this is not a general error in 23.05 but probably something on our side. |
| 10:30 | oleonard | Good luck! |
| 10:31 | AnkeB | Thanx :-) |
| 10:33 | Zahid[m] | i am using koha 22.11 i need to add sort1 field in search patron result page, i need this field urgent as this field contains very important data to search and display on result page, it will be very helpful, any suggestion ? where can i start? |
| 10:34 | oleonard | Zahid[m]: I'm not aware of a configuration option that would enable that. It sounds like it would require an enhancement to Koha. |
| 10:39 | Zahid[m] | any help needed. may i have to add/change the system preference in koha? currently i am stuck and finding a way for this problem. |
| 11:03 | RudyHinojosa joined #koha | |
| 11:22 | oleonard | Zahid[m]: I have submitted a patch, Bug 34608 |
| 11:22 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34608 enhancement, P5 - low, ---, oleonard, Needs Signoff , Add sort1 and sort2 to patron search results |
| 11:22 | oleonard | It should apply to 22.11 as well. |
| 11:23 | lucky for you I was looking for something to do to start my day ;) | |
| 12:08 | "koha-testing-docker has started up and is ready to be enjoyed!" That's a nice addition :) | |
| 12:12 | RudyHinojosa | Is there a link to documentation how to test that, or is this still more internal at this point? |
| 12:18 | koha/koha-dpkg | |
| 12:18 | ? | |
| 12:21 | khall joined #koha | |
| 12:30 | dcook_ joined #koha | |
| 13:20 | aw-bib[m] | Hi! are there some recommendations for the hardware environment for koha? (cpus, ram, disk) I searched the wiki but was out of luck and the local it asks what they should set up for the production service. |
| 13:21 | oleonard | aw-bib[m]: You might have better luck asking on the Koha mailing list. I suspect the answer will depend on number of patrons, number, of records, circulation, etc. |
| 13:21 | aw-bib[m] | ok. thanks, I'll do that. :) |
| 13:29 | AnkeB joined #koha | |
| 13:32 | PriyanshuSoni[m] | Hey guys, i am using a carousel by in Libro (v4.1.2) in Koha 22.05.02.... (full message at <https://matrix.org/_matrix/med[…]rlpdkAIynYjhNPuaJ>) |
| 13:51 | oleonard | PriyanshuSoni[m]: Have you asked on the Koha mailing list yet? There might be someone there who has used it successfully and can advise you on configuration |
| 14:05 | jalway joined #koha | |
| 14:23 | cait joined #koha | |
| 14:27 | matts joined #koha | |
| 14:31 | h2 joined #koha | |
| 14:41 | khall_ joined #koha | |
| 14:46 | thibaud_g joined #koha | |
| 14:48 | thibaud_glt joined #koha | |
| 14:48 | thibaud_g joined #koha | |
| 15:00 | bag joined #koha | |
| 15:16 | thibaud_g joined #koha | |
| 15:28 | KevinFurst[m] | cait: Are you online today? |
| 15:33 | cait | yes |
| 15:34 | KevinFurst[m]: | |
| 16:07 | KevinFurst[m] | cait: Still plugging away at this import that keeps failing. Tried a batch of only 1000 records and it still fails. Ran that batch through another MARC validator and a few errors came up. I'm trying to figure out whether they are really errors or not. One is with field 20. It says there can't be duplicates but I don't understand since we have multiples where one 020 field is for a paperback binding and one is for library binding. So they |
| 16:07 | seem like valid records. During import, I am matching on the ISBN 20. Any thoughts on that? | |
| 16:07 | So they're not really a duplicate per se ,there are just multiple field 20 lines on some records. | |
| 16:49 | cait | hm |
| 16:49 | 020 is repeatable | |
| 16:49 | do you have 20 or 020? | |
| 16:49 | also... something to try maybe. Are you trying to import MARCXML or are you importing .mrc? | |
| 16:50 | KevinFurst[m] | importing .mrc |
| 16:51 | Here's an example of an 020 record it's complaining about =LDR 01857pam a2200517 a 4500 | |
| 16:51 | =008 080826t20082007nyuab\c\\\000\1\eng\d | |
| 16:51 | =020 \$a9780441016235 (pbk.) | |
| 16:51 | =020 \$a0441016235 | |
| 16:51 | =040 \$aICrlF$cICrlF$dICrlF | |
| 16:59 | cait | hm es, that looks ok to me.... maybe only think it looks like only 1 indicator? |
| 16:59 | but it might be the copy and paste | |
| 17:00 | does it import nicely if you tell it to ignore the items? | |
| 17:00 | oooh - do you see anything in administration > background jobs about your imports? | |
| 17:00 | maybe it's not even the file! | |
| 17:01 | KevinFurst[m] | Yes. Imports fine without the items |
| 17:01 | cait | ah too bad... i was wondering if it only needed the background job restarted, but if that worked that should not be it |
| 17:01 | so i think we can probably also rule out problems iwth the bibliographic records | |
| 17:01 | did you double check the branchcodes etc? | |
| 17:02 | no additional spaces for example in your configuration? | |
| 17:02 | having a look at the logs might tell you something | |
| 17:02 | KevinFurst[m] | When I was originally working on this last month, since I couldn't get the import to work with items, I just imported the bibliographic records. Which may not have been such a good idea as now I'm matching on ISBN 20 for the import. |
| 17:03 | cait | tail -f /var/log/koha/instancename/*.log (I think) |
| 17:03 | KevinFurst[m] | I've been checking the logs but can only see them from CLI the in browser logs never show anything. |
| 17:03 | cait | hm, could you remove the bibliographic records again? or do you have maybe a 001 from your previous system you oculd match on? |
| 17:04 | yeah, I think you wouldn'T see in the browser, only js problems htere | |
| 17:04 | KevinFurst[m] | Do you know which should have an error? The intranet error or the worker logs? |
| 17:04 | cait | maybe the plack one actually |
| 17:04 | KevinFurst[m] | ok. I'm going ssh in and check again. |
| 17:04 | cait | i usually check hem all with the *.log |
| 17:08 | jalway | I assume the set of records you have that you're trying to import don't have the koha bib number in them? |
| 17:08 | The koha bib number would be unique and an easy match. | |
| 17:08 | khall joined #koha | |
| 17:09 | KevinFurst[m] | In all of the logs with "error" in the name, only the worker error had any entries and it's just one line: library-koha-worker-long_tasks: client (pid 2807789) killed by signal 13, respawning I've been in koha all morning though so whatever that was must not be critical |
| 17:10 | Correct. they came from a different service. | |
| 17:10 | cait | hmmm and nothing during the import itself? |
| 17:10 | KevinFurst[m] | correct. |
| 17:10 | cait | if you have 001 you could try to match on those |
| 17:10 | hm it's really odd :( | |
| 17:10 | the only thing I can think now is something with the branchcodes or itemtype codes | |
| 17:10 | i know that used to silently fail if not matching | |
| 17:11 | KevinFurst[m] | It just find it so weird that during the staging process it lists the items as if it's no issue and then just immediately fails when I do the import batch function |
| 17:11 | *I find it | |
| 17:11 | cait | you could also try to use the command line scripts for importing... in case they are more verbose |
| 17:11 | I agree | |
| 17:11 | Koha should do better | |
| 17:12 | the CLI scripts would be here: https://git.koha-community.org[…]ranch/master/misc | |
| 17:12 | stage_file.pl | |
| 17:12 | wahanui | i think stage_file.pl is uploading and commit_file is importing into the catalog |
| 17:12 | cait | and commit_file.pl |
| 17:12 | KevinFurst[m] | School is starting next week so I'm kind of running up against a deadline so I am at the point where I'm hacking away at the mrc file in these little errors the marc editor is finding in hopes something will work (with that said, Koha didn't seem to care about these supposed errors when importing biblio info) |
| 17:13 | cait | yeah I think save the time on those |
| 17:13 | it's the items somehow | |
| 17:13 | so to be sure... you stage the file and it uploads, but it won't import into the catalog? | |
| 17:13 | or in which step exactly does it not work? | |
| 17:14 | KevinFurst[m] | Ok. I am going to finish these error cleanups and then will move to try the CLI scripts this afternoon. I just wish I had info somewhere abou where the issue is. Nothing in the logs and nothing on the browser job screen other than "Failed" makes it really hard to find the culprit. |
| 17:16 | oh. and btw. Importing patrons and importing patron images was slick. No issues at all. So it can't be something hardware or code related. It has to be something with my mrc file. | |
| 17:16 | jalway | Would koha just choke on data in item fields that have incorrect data types? I.E. AlphaNumber where it's only looking for numeric, etc.? |
| 17:17 | cait | yes I tink it would |
| 17:17 | but really... double check the branchcodes again etc. | |
| 17:17 | we have had had the case where one had a space in the end | |
| 17:17 | and that WILL definitely make it fail | |
| 17:17 | and it's kind of hard to spot with MySQL tools | |
| 17:17 | jalway | KevinFurst[m] How are you with regular expressions? |
| 17:17 | KevinFurst[m] | Cait identified one of those for me yesterday where I was using USD in the decimal field. I did fix that but no change |
| 17:17 | ok checking again. | |
| 17:17 | not good | |
| 17:18 | cait | i tihnk the trick was counting the length or something |
| 17:18 | (with SQL) | |
| 17:18 | something like compare length with and without TRIM | |
| 17:19 | jalway | I have a command line tool that you could use to "semi-easily" check whatever fields you're wanting to check for bad data. |
| 17:19 | https://github.com/josephalway/MARCCrucible | |
| 17:19 | KevinFurst[m] | If this is a new instance, could I just delete the branches and readd them? I only have 2 branches. PRBE for our elementary school and PRBHS for our secondary school. |
| 17:19 | jalway | Though, you can probably do it all in MARCedit. |
| 17:19 | cait | if you have users already you can't |
| 17:19 | KevinFurst[m] | ik |
| 17:19 | ok | |
| 17:20 | cait | the problem is that SQL tends to ignore spaces, but Perl does not |
| 17:20 | so sometimes these errors are hard to find | |
| 17:20 | but you could try add them again... if you don't get a duplicate error... | |
| 17:20 | branchcode is a PK | |
| 17:20 | KevinFurst[m] | ok. good idea |
| 17:21 | cait | I know we are grapsing for straws... but one of the straws might turn out ot be the culprit |
| 17:22 | KevinFurst[m] | "An error occurred when adding this library. The branchcode might already exist." |
| 17:22 | cait | that's not bad |
| 17:22 | what about the itemtype code? | |
| 17:22 | and your branchcodes are all uppercase? | |
| 17:23 | KevinFurst[m] | This item type already exists |
| 17:23 | Both Branch and Item codes are all upper, yes | |
| 17:23 | cait | how annoying |
| 17:26 | KevinFurst[m] | On the "Manage staged MARC Records - Batch n" screen, I've selected matching rule of ISBN (020$a), Replace existing record with incoming record, Action of no match = Add incoming record, Item Processing = Always add items" New record and replacement record frameworks are both set to "Default" Anything wrong there? |
| 17:27 | cait | no looks good |
| 17:27 | did you see my question about existing 001 fields from your old system? | |
| 17:29 | KevinFurst[m] | In checking now, it does appear that all or almost all have an 001 in the mrc file |
| 17:30 | cait | you oculd add a matching rule for that |
| 17:30 | on control-number index | |
| 17:30 | KevinFurst[m] | I don't see that as an option, I have ISBN 20, ISSN 22 or Koha Biblio 999$c |
| 17:31 | That's it | |
| 17:31 | cait | you can add your own |
| 17:31 | these are onyl some pre-installe ones | |
| 17:31 | KevinFurst[m] | ok found the setting. adding now |
| 17:33 | hm there's fields in this that I don't know what value to input. Search index, score, offset , length, normalization rule? | |
| 17:34 | cait | Control-number for index |
| 17:34 | offset leave empty | |
| 17:34 | normalization rule too or none | |
| 17:34 | length can be empty too | |
| 17:35 | like that: https://snipboard.io/lM6itO.jpg | |
| 17:37 | KevinFurst[m] | Got it. Trying now. |
| 17:38 | Job ID:73Status:FailedProgress:0 / 325Type:Import MARC recordsQueued:08/24/2023 12:38 PMStarted:08/24/2023 12:38 PMEnded:08/24/2023 12:38 PM | |
| 17:39 | Same. Fails immediately. Nothing in detailed messages. Going to check logs again. | |
| 17:40 | cait | maybe try them with tail -f before you start the impoert |
| 17:40 | might be easier to see | |
| 17:40 | jalway | Seems like it's choking on one of the first records, then. |
| 17:40 | KevinFurst[m] | ok. |
| 17:41 | btw. I am trying these last steps with a smaller file that only has ~300 records. | |
| 17:41 | cait | it's a good idea |
| 17:43 | I'd maybe even try with a single record with one item... | |
| 17:45 | KevinFurst[m] | Threw in the tail cmd ... : ==> /var/log/koha/library/worker-output.log <== |
| 17:45 | DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /usr/share/koha/lib/Koha/Object.pm line 170 | |
| 17:45 | Broken FK constraint at /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 91 | |
| 17:46 | cait | ha |
| 17:46 | it is someting with the branchcodes | |
| 17:47 | KevinFurst[m] | In the file or in Koha? |
| 17:47 | cait | this is definitely the source of the problem |
| 17:47 | they are not matching | |
| 17:47 | can you revisit your $a and $b ? | |
| 17:47 | in 952 | |
| 17:47 | KevinFurst[m] | Yes. Going to look at those in MarcEDIT right now |
| 17:48 | This is a thing where if a single record is wrong or has a space, it will fail right? | |
| 17:49 | Dumb question, but for records we no longer/don't currently have an item for, it's ok to not have a 952 record (and by extension not have an a or b subfiled), right? I have some at the beginning of the file like this which made me ask | |
| 17:50 | cait | no 952 shoud be no problem |
| 17:50 | but if you have a 952 it should be complete | |
| 17:56 | maybe the idea to try with one record with one item to start with is not a bad one | |
| 17:58 | KevinFurst[m] | yep. Creating a really short mrc file now to try with that in mind. I did a few searches to see if I could find either an $a or $b that had a space before PRBE or after it and it returned no results. so trying the really short file now. |
| 17:58 | cait | if we got one item in, we can get them all in :) |
| 17:58 | *fingres crossed* | |
| 18:00 | KevinFurst[m] | Job ID:77Status:FinishedProgress:6 / 6Type:Import MARC recordsQueued:08/24/2023 01:00 PMStarted:08/24/2023 01:00 PMEnded:08/24/2023 01:00 PM |
| 18:00 | cait | ooh |
| 18:00 | KevinFurst[m] | Matched on all 6 and imported 6 items to existing bilblio record! |
| 18:01 | cait | matching on the 001 ? |
| 18:01 | KevinFurst[m] | yes |
| 18:01 | cait | awesome :) |
| 18:01 | KevinFurst[m] | How do I find the problem though in the other records using MarcEDIT?> |
| 18:01 | cait | that's a good question |
| 18:01 | KevinFurst[m] | Doesn't seem to be a space issue. |
| 18:01 | cait | maybe it's a missing subfield issue |
| 18:02 | can you count 952... 952$a and 952$b | |
| 18:02 | seeing if there isa mismatch? | |
| 18:02 | KevinFurst[m] | good idea. will try |
| 18:02 | cait | maybe the $b especially, because it complained about holdingbranch |
| 18:03 | also if you use marcedit to convert to .mrk you might use your normal text editor and regex etc. if that is helpful for you | |
| 18:03 | KevinFurst[m] | Field 952: 19305 |
| 18:03 | Ind1 -- : 19305 | |
| 18:03 | Ind2 -- : 19305 | |
| 18:03 | $a: 19305 | |
| 18:03 | $g: 18932 | |
| 18:03 | $b: 19305 | |
| 18:03 | $y: 19305 | |
| 18:03 | $o: 27203 | |
| 18:03 | $p: 19305 | |
| 18:04 | cait | hm |
| 18:04 | can we find if all $b contain the same value? | |
| 18:04 | KevinFurst[m] | That would be in one of my full length files |
| 18:04 | ok | |
| 18:05 | cait | I haven't used these features in MARCEdit much... I usually go for notepad++ and regex |
| 18:08 | but maybe it can give you a list of values used or something? | |
| 18:08 | KevinFurst[m] | yes, running a report now |
| 18:08 | cait | *fingers crossed* |
| 18:08 | brb, gotta save my laundry from the incoming thunderstorm | |
| 18:17 | KevinFurst[m]: I hope to get a success report soon! :) | |
| 18:22 | Dyrcona joined #koha | |
| 18:38 | KevinFurst[m] | cait: Have a job running now. Will let you know. |
| 18:39 | cait | did you find any $b issues to fix? |
| 18:41 | KevinFurst[m] | I did. Apparently when it was 852 the b field was also used as a special collection indicator. I thought I had removed them all but 2 records were spelled wrong at some point so my search didn't pick them up: Hoiday Bookshelf and Holiday Book shelf weren't found by my initial replacement. |
| 18:42 | So I'm trying the batch import again after fixing those | |
| 18:42 | Threw another error. I must have missed one. | |
| 18:45 | cait | but at least we got a good bit further, I hope you can locate and then it will work |
| 19:16 | jalway | =952.+\$a(?!PRBE).+\$b RegEx search in MARCEdit should find most typos. |
| 19:16 | KevinFurst[m] | cait: Finally. It worked. Imported 19.3k items. Yay! Thank you so much for your help!! |
| 19:17 | jalway | Nice, perseverance pays off. :-) |
| 19:21 | cait | KevinFurst[m]: awesome :) |
| 19:21 | KevinFurst++ | |
| 19:22 | jalway++ | |
| 19:56 | RudyHinojosa joined #koha | |
| 19:56 | RudyHinojosa | ERROR: Can't create '/etc/koha' |
| 19:56 | Do not have write permissions on '/etc/koha' | |
| 19:56 | !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! | |
| 19:56 | at -e line 1. | |
| 19:56 | make: *** [Makefile:11299: install_koha] Error 13 | |
| 19:57 | almost to the finish line. | |
| 19:57 | during the make install using docker. | |
| 20:20 | got it. thanks. | |
| 20:20 | :) | |
| 23:13 | sonOfRa joined #koha | |
| 23:13 | tcohen joined #koha | |
| 23:14 | magnuse joined #koha | |
| 23:14 | kivilahtio joined #koha | |
| 23:14 | Nemo_bis joined #koha | |
| 23:18 | jajm joined #koha | |
| 23:57 | edveal[m] joined #koha |
← Previous day | Today | Next day → | Search | Index