← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 03:50 | bag joined #koha | |
| 06:01 | dolf joined #koha | |
| 06:10 | dcook joined #koha | |
| 06:10 | * dcook | looks around and runs away |
| 06:11 | dcook | @later tell Joubu Let me know what you think about my comment re: 36094#c17 and I'll look at it tomorrow |
| 06:11 | huginn` | dcook: The operation succeeded. |
| 06:26 | cait joined #koha | |
| 07:28 | reiveune joined #koha | |
| 07:29 | reiveune | hello |
| 07:29 | Joubu | dcook: maybe too early for me, but why not simply reject if not a POST? answered on the bug. |
| 07:59 | cait joined #koha | |
| 08:01 | krimsonkharne[m] | morning all |
| 08:01 | Joubu | @later tell dcook maybe too early for me, but why not simply reject if not a POST? answered on the bug. |
| 08:01 | huginn` | Joubu: The operation succeeded. |
| 08:01 | Joubu | @later tell dcook patch moved to 35955 (and adjusted the branch) |
| 08:01 | huginn` | Joubu: The operation succeeded. |
| 08:02 | paulderscheid[m] | morning #koha |
| 08:14 | dolf | cait: What did you mean when you said "I think there is a better error hiding in your logs"? Also, you asked whether I changed XSLT files or settings. The answer is, no, this is a clean Koha install, with a restore from a backup. In the backup file, some of the XSLT settings are blank instead of "default". Changing them to "default" seems to make no difference. Here is a screenshot of my findings while experimenting on VirtualBox on my |
| 08:14 | local machine: https://ibb.co/3rNtw1B | |
| 08:19 | MarkHofstetter joined #koha | |
| 08:28 | dolf | I found a smoking gun: If I set OPACXSLTDetailsDisplay to "default", they are not shown correctly. However, if I change it to "/usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/MARC21slim2OPACDetail.xsl", it works! But as far as I can see, that is the proper default path on Debian. Is this a known bug? |
| 08:28 | This is on 21.11 | |
| 08:38 | The same goes for OPACXSLTResultsDisplay. "default" does not work, but "/usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/MARC21slim2OPACResults.xsl" works well. | |
| 08:42 | cait | 21.11 is quite old already again, I haven't heard about a bug like this |
| 08:42 | are you using translations? UNIMARC or MARC21? | |
| 08:43 | sometimes translations break the XSLT files, for example if is used | |
| 08:46 | ashimema | Fun |
| 08:58 | Joubu | @later tell marcelr can you have a look at the pad and search for "opac-password-recovery" please. |
| 08:58 | huginn` | Joubu: The operation succeeded. |
| 09:00 | dolf | 21.11 is quite old, yes, and that's why I'm trying to upgrade. But I have to upgrade bit by bit and do a bunch of tests with each step. That's why I'm going 21.05 → 21.11 first. |
| 09:00 | I'm not sure what you mean by translations. We use Koha in English. | |
| 09:01 | marcflavour is (and has always been) set to MARC21 | |
| 09:01 | cait | I am out of ideas then |
| 09:01 | if you use the standard XSLT they should work | |
| 09:02 | a wild guess woudl be that it could be something in framework configuration and visibility settings - I think they didn't take effect for a while and when they did it broke some setups. | |
| 09:02 | die you change frameworks in any way? | |
| 09:03 | dolf | Everything in frameworks is also visible. We checked it here: https://irc.koha-community.org[…]4-01-04#i_2529646 |
| 09:03 | In which version were the XSLT files completely removed? (Or am I mistaken in thinking they were?) | |
| 09:04 | cait | no, they were not removed |
| 09:04 | dolf | Also see https://irc.koha-community.org[…]4-01-04#i_2529700 :) |
| 09:04 | cait | we removed the non-XSLT views .) |
| 09:04 | dolf | Ah, got it. |
| 09:04 | I remembered it upside-down | |
| 09:04 | cait | all good |
| 09:04 | jajm joined #koha | |
| 09:04 | cait | I have never had that happen unless we broke the XSLT |
| 09:05 | (we do have changed ones) | |
| 09:05 | and then usually you have an XSLT error in the logs somewhere | |
| 09:05 | as they work when you put the full path, could it be something about the installation? permissions/paths? how did you install? | |
| 09:06 | dolf | Clean debian, then added the apt repo, then `apt install koha-common mariadb-server`. Basically I followed these instructions to the letter, except I did `koha-restore` and `koha-upgrade-schema` instead of `koha-create`: https://wiki.koha-community.or[…]ki/Koha_on_Debian |
| 09:07 | I am willing to give SSH access to any of my test VMs if that will help debug this. | |
| 09:09 | ashimema | Is it an upgrade? Ie, is the restore coming from an older version? |
| 09:10 | Read up ashimema, he's already answered that | |
| 09:10 | Sorry | |
| 09:10 | Will read the full discussion now before commenting again | |
| 09:11 | dolf | ashimema: My screenshot here summarized most of what I have tried :) https://ibb.co/3rNtw1B |
| 09:12 | ashimema | hmm |
| 09:12 | weird | |
| 09:12 | Joubu | define "not working", if you get a 500 then get the proper error from the koha log files: `tail -f /var/log/koha/*/*.log` and hit the page |
| 09:13 | dolf | Joubu: Sorry, I have defined "not working" in great detail multiple times now. Please give me a moment, and I will type it all out again. |
| 09:13 | ashimema | >I found a smoking gun: If I set OPACXSLTDetailsDisplay to "default", they are not shown correctly. However, if I change it to "/usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/MARC21slim2OPACDetail.xsl", it works! But as far as I can see, that is the proper default path on Debian. Is this a known bug? |
| 09:14 | dolf | This line summarizes my "not working" well: https://irc.koha-community.org[…]4-01-04#i_2529700 "the bit where the output of the XSLt woudl be is completely missing from the page source" |
| 09:14 | ashimema | that leads me to think there's some weird syspref caching catching you out. |
| 09:14 | dolf | I did not know that sysprefs were cached! :) How can I clear that cache? |
| 09:15 | Joubu | flush_memcached |
| 09:16 | dolf | Joubu: command not found |
| 09:16 | (as root on the debian VM running Koha, via SSH) | |
| 09:17 | Joubu | do we really need to clear the cache when the xslt prefs are updated from the UI? |
| 09:17 | dolf: restart memcached, apache2 then koha-common | |
| 09:18 | dolf | `systemctl restart memcached && systemctl restart apache2 && systemctl restart koha-common` done. Hard refresh in browser. No difference. |
| 09:20 | cait | Joubu: usually it just works, I change them around quite a bit |
| 09:21 | dolf: sorry for delayed replies and heading into a meeting soo now | |
| 09:21 | Joubu | dolf: you are running an old version of Koha, it's hard to tell if you are not chasing a bug that is fixed now |
| 09:21 | dolf | Yes, if I use file paths, the effect is instant. |
| 09:22 | Joubu | if you want to debug what's happening you could add a warn statement in.. |
| 09:22 | C4/XSLT.pm sub get_xsl_filename | |
| 09:22 | warn $xslfilename; before the return statement | |
| 09:22 | dolf | Joubu: That's a great idea. I don't really know perl, but I'll try that. |
| 09:22 | Joubu | you will know which file is used |
| 09:23 | dolf | Otherwise I'll continue with my workaround, i.e. setting the absolute paths instead of "default". |
| 09:23 | I just need to know the proper path for OPACXSLTListsDisplay. I already have the correct one for OPACXSLTDetailsDisplay and OPACXSLTResultsDisplay | |
| 09:24 | Joubu | you need to restart reload plack when you modify perl modules: kill -SIGHUP $(cat /var/run/koha/${KOHA_INSTANCE}/plack.pid) |
| 09:31 | dolf | Got it. It gives "/usr/share/koha/opac/htdocs/opac-tmpl/prog/en/xslt/MARC21slim2OPACDetail.xsl" instead of "/usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/en/xslt/MARC21slim2OPACDetail.xsl". So it looks like "theme" is set to "prog" instead of "bootstrap". However, in my system preferences, opacthemes is set to "bootstrap" (the only option). |
| 09:33 | Joubu | force the value on the UI if you can |
| 09:33 | maybe it's not "bootstrap" in DB and the UI is tricking you | |
| 09:35 | dolf | `select value from systempreferences where variable='opacthemes';` tells me it is "prog_rsc" in the database!! :O |
| 09:35 | What does "force the value on the UI" mean? | |
| 09:36 | Joubu | just save, but it won't work I think |
| 09:36 | dolf | Is it safe to simply update the value using SQL? |
| 09:36 | Joubu | update the value in DB and restart everything again (sysprefs are cached as well) |
| 09:36 | yes it's safe | |
| 09:36 | It seems that there is a fallback value for the templates, not the XSLT | |
| 09:38 | dolf | update systempreferences set value = "bootstrap" where variable = "opacthemes"; |
| 09:38 | systemctl restart memcached && systemctl restart apache2 && systemctl restart koha-common | |
| 09:38 | Everything is working again :D :D :D | |
| 09:39 | Thanks Joubu and ashimema and cait and anyone else I might forget now who helped me. | |
| 09:40 | Joubu | you can report on bugzilla ;) |
| 09:40 | it's a bug, we should fallback for XSLT as well. And also add a warning on the about page about incorrect value in this pref. | |
| 09:41 | dolf | You mean an incorrect value in the opacthemes pref? (I think the value I had in there was a holdover from a custom theme that was last used more than 12 years ago, and has since been removed from the production VM) |
| 09:42 | Joubu | yes |
| 09:42 | dolf | OK, will do. |
| 09:58 | https://bugs.koha-community.or[…]_bug.cgi?id=36172 | |
| 09:58 | huginn` | 04Bug 36172: minor, P5 - low, ---, koha-bugs, NEW , Warn about incorrect values in the opacthemes system preference |
| 10:20 | paulderscheid[m] | The only good thing about C4::Members::Messaging is that it's only three subs. |
| 10:22 | Joubu | 4 |
| 10:22 | :D | |
| 10:22 | paulderscheid[m] | True |
| 10:22 | Overlooked the last one, thought it was just docs. | |
| 11:00 | tcohen | hola #koha |
| 11:22 | khall joined #koha | |
| 11:29 | oleonard joined #koha | |
| 11:32 | jajm joined #koha | |
| 11:42 | paulderscheid[m] | Just to be sure: virtualshelves ≈ Lists ? |
| 11:43 | PedroAmorim[m] | yes paulderscheid |
| 11:43 | paulderscheid[m] | Thanks Pedro Amorim :D |
| 11:44 | PedroAmorim[m] | just another case of Koha schema naming shenanigans =D |
| 11:44 | paulderscheid[m] | Nothing surprises me anymore ˆˆ |
| 11:57 | oleonard | We're just lucky they weren't originally named CyberShelves |
| 12:03 | Joubu | paulderscheid[m]: https://wiki.koha-community.org/wiki/Terminology ;) |
| 12:05 | paulderscheid[m] | CyberShelves gives me PTSD (german politics loves to use this nonsensical term for things regarding IT security). |
| 12:06 | The only 'cyber' I accept are cybernetic organisms :D | |
| 12:15 | cait | I once saw an US job ad for a Cybrairan... |
| 12:15 | Cybrarian | |
| 12:15 | paulderscheid[m] | Hopefully long ago :D |
| 12:15 | cait | it's been a while |
| 12:17 | did we finish CSRF now? ;) | |
| 12:17 | i have been in a meeting all morning... | |
| 12:28 | ashimema | no |
| 12:46 | oleonard | But we've made tons of progress |
| 12:46 | Friday I finished my list of testing-all-the-things and logged or fixed things I found | |
| 12:46 | I'm sure I missed some things of course | |
| 13:03 | cait joined #koha | |
| 13:26 | domm[m] | How / when is an order suggestion converted / linked to a biblio? |
| 13:27 | The docs talk about an "order" button in the suggestion-list, but I don | |
| 13:27 | * I don't see this option there | |
| 13:31 | Joubu | domm[m]: On the acquisition basket view: click "Add to basket" button > "From a suggestion" |
| 13:31 | is that what you are looking for? | |
| 13:31 | https://snipboard.io/6B9hbR.jpg | |
| 13:31 | domm[m] | probably :-) |
| 13:33 | tcohen | Joubu++ |
| 13:33 | Dyrcona joined #koha | |
| 13:37 | domm[m] | Joubu: yes, that was what i was looking for, thx |
| 13:38 | Dyrcona joined #koha | |
| 13:46 | khall_ joined #koha | |
| 14:11 | oleonard joined #koha | |
| 14:11 | khall joined #koha | |
| 14:13 | fridolin joined #koha | |
| 14:23 | khall_ joined #koha | |
| 14:34 | JasonGreene[m] | morning... I just go in and looked at that job,... (full message at <https://matrix.org/_matrix/med[…]ORSSOCqyJGcFrcMCw>) |
| 14:35 | then I went to "Manage imported batch" and can see each one is "Staged"... (full message at <https://matrix.org/_matrix/med[…]FpKuzuvJOSIsgnwyI>) | |
| 14:36 | caroline | if it's "Staged", you can click the Import this batch into the catalog button |
| 14:36 | that job says Status: Failed, maybe it was one with the wrong subfields? | |
| 14:37 | JasonGreene[m] | Then when I click "Import this batch into the catalog" |
| 14:37 | I get "The job has been enqueued!" | |
| 14:37 | Joubu | have a look at the koha log file |
| 14:37 | caroline | ok, now it just needs to do it |
| 14:38 | JasonGreene[m] | from a command line or in the web pages |
| 14:38 | Joubu | command line |
| 14:38 | The error might also be hidden in the DB in background_jobs.data | |
| 14:39 | JasonGreene[m] | what is its location so I can cat or more it |
| 14:40 | in DB... ouch, I'm not a DB admin | |
| 14:40 | Joubu | /var/log/koha/*/worker-*.log |
| 14:40 | JasonGreene[m] | thanks |
| 14:41 | Joubu | select data from background_jobs where id=4; |
| 14:44 | JasonGreene[m] | worker-error.log was yesterday |
| 14:44 | opac-error.log is today | |
| 14:44 | wait | |
| 14:44 | worker-output.log today | |
| 14:45 | cat worker-error.log | |
| 14:45 | 20240226 16:50:34 library-new-koha-worker: client (pid 10925) killed by signal 15, stopping | |
| 14:46 | cat worker-output.log... (full message at <https://matrix.org/_matrix/med[…]ShVfJKslluLTeLOaZ>) | |
| 14:47 | My idea last night was toi | |
| 14:48 | s/toi/to rebuild the server this morning and restart koha after the install and see if we get the same ability to import like we got last night after a restart/ | |
| 14:49 | BRB - going to fill coffee cup. | |
| 14:50 | Joubu | you are trying to import items that have homebranch code not defined in Koha |
| 14:55 | JasonGreene[m] | I'm using the "installed branches" |
| 14:56 | branch = library ?? right ?? | |
| 14:56 | caroline | yes |
| 14:56 | JasonGreene[m] | FRL = Franklin and TPL = Troy |
| 14:57 | I change the names to Flora and Tracy ... same codes | |
| 14:57 | caroline | makes sense |
| 14:58 | JasonGreene[m] | keep digging on this one or build a fresh server ? |
| 14:58 | :-) | |
| 14:59 | Joubu | Cannot add or update a child row: a foreign key constraint fails (`koha_library-new`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE |
| 15:00 | this error means that you are trying to insert a row into the "items" table with the value for column "homebranch" not in branches.branchcode | |
| 15:00 | JasonGreene[m] | What does that tell you ? |
| 15:00 | Joubu | your worker-output.log |
| 15:01 | JasonGreene[m] | FOREIGN KEY (homebranch) REFERENCES branches |
| 15:03 | maybe add a new branch and change the code in the csv and import it again? | |
| 15:06 | this is the top of the mrc that worked after a koha restart | |
| 15:06 | =LDR 00249nam a2200109Ia 4500 | |
| 15:06 | =008 240226s9999||||xx||||||||||||||||und|| | |
| 15:06 | =082 \$a082$a | |
| 15:06 | =100 \$a100$a | |
| 15:06 | =245 \0$a245$a | |
| 15:06 | =650 \$a650$a | |
| 15:06 | =942 \$c942$c | |
| 15:06 | =952 \$b952$b$a952$a$y952$y $2952$2 $o952$o$p952$p | |
| 15:06 | MarkHofstetter joined #koha | |
| 15:07 | caroline | The branchcode in that record in $b and $a, those are probably the ones bugging |
| 15:08 | You'll need to remove that record from the file I think. It looks like it made a record out of your csv headers | |
| 15:18 | JasonGreene[m] | so remove both or just b |
| 15:19 | caroline | remove the whole record, itemtype (952$y, 942$c) will also give an error |
| 15:22 | JasonGreene[m] | so I understand ... remove all 952$ a b c y 2 ... o and p are dewey and old book code |
| 15:22 | caroline | yes, and 942$c |
| 15:24 | JasonGreene[m] | ok, so all 952 and 942... where will the input put the data which branch? |
| 15:24 | caroline | don't remove the data from all the records. Just that one that you put in the chat |
| 15:25 | branch FRL or TRL is fine, but branch 952$a and 952$b don't exist | |
| 15:26 | JasonGreene[m] | oh..... that was the top part of the mrc... and I forgot to remove that turd |
| 15:26 | Thanks | |
| 15:26 | caroline | ok phew! |
| 15:29 | JasonGreene[m] | got a green bar with |
| 15:29 | 100% Finished | |
| 15:29 | caroline | OMG! |
| 15:34 | JasonGreene[m] | ... (full message at <https://matrix.org/_matrix/med[…]KZkNlLljQYnHUFTqh>) |
| 15:34 | caroline | OMG!! |
| 15:34 | JasonGreene[m] | Flora-2-27-24-1-online-help-edit-mrc.mrc Bibliographic Imported 02/27/2024 09:28 3723 3723 (Create label batch) |
| 15:35 | caroline | does a search return results? |
| 15:35 | JasonGreene[m] | Just did a search on "Thomas" Author and got 41 results |
| 15:35 | caroline | OMG!!! |
| 15:36 | (I will keep adding exclamation marks) | |
| 15:36 | JasonGreene[m] | you all are the best! thank you so much for your perfect help |
| 15:36 | caroline | it took a while, but you got there! |
| 15:39 | JasonGreene[m] | yes... now I need to input the other branch's data and it is 14K books :-) |
| 15:39 | caroline | I hope you took notes lol |
| 15:40 | JasonGreene[m] | oh yea |
| 15:45 | Joubu | JasonGreene[m]: please open a bug report, we need to provide useful info when the import fails |
| 15:50 | JasonGreene[m] | ok, where do we open them? |
| 15:50 | oleonard joined #koha | |
| 15:50 | caroline | you'll need to create an account on here https://bugs.koha-community.org/bugzilla3/ |
| 15:50 | JasonGreene[m] | thanks |
| 15:51 | Joubu | wait |
| 15:51 | we have one already - bug 21272 | |
| 15:51 | huginn` | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=21272 enhancement, P5 - low, ---, hammat.wele, Failed QA , MARC import should warn about mis-matched branch and item-type fields in 952 during staged import |
| 15:53 | caroline | On the wiki, how do we mark a page as obsolete/needs review? |
| 15:53 | This needs to be marked https://wiki.koha-community.org/wiki/Bugzilla | |
| 15:55 | Ok I found an example | |
| 15:57 | JasonGreene[m] | since there is already one bug "21272" I won't make another one 🙂 |
| 16:09 | reiveune | bye |
| 16:09 | reiveune left #koha | |
| 16:12 | marie-luce joined #koha | |
| 16:14 | khall joined #koha | |
| 16:28 | cait | ping mtj |
| 17:43 | cait joined #koha | |
| 18:03 | MarkHofstetter joined #koha | |
| 18:05 | oleonard joined #koha | |
| 18:34 | tcohen | bye everyone |
| 19:12 | MarkHofstetter joined #koha | |
| 19:32 | mtj | Hi cait.. About now |
| 19:43 | khall joined #koha | |
| 21:13 | JasonGreene[m] | ok, after some editing of the second input csv, with 14k books, and following yesterday's help, I was able to get it into Koha. |
| 21:13 | Thanks again for your help! | |
| 21:22 | caroline | yay! JasonGreene++ |
| 21:40 | khall joined #koha | |
| 22:24 | * dcook | looks at the scrollback |
← Previous day | Today | Next day → | Search | Index