Time Nick Message
05:57 dc_rogers who do i ask for install issues? I have a preinstalled mariadb, root has its own password and i think this is causing issues with the library instance create (koha-create) how can i fix this?
06:05 reiveune hello
06:05 wahanui hey, reiveune
06:14 alex_ Bonjour
07:02 dcook allo allo
07:02 * dcook wills oleonard to be online
07:03 dcook oleonard_ as well
07:13 dcook Wow it's considerably earlier/later in Ohio than I thought...
07:48 nlegrand Bonjour.
08:11 MarkHofstetter1 hi, I tried koha-testing-docker on several (virtual) machines but it won't run stable on any of them ie after running the tests once or trying the web interface the koha-container simply quits with an nondescript error - are there any best practices I should adhere to or am I doing something wrong?
08:39 fridolin MarkHofstetter1: stable ? you mean 21.11 ?
09:09 MarkHofstetter1 yes 21.11
09:11 mtj MarkHofstetter1: you probably need to update to the latest ktd images...
09:11 mtj $ cd ktd && docker-compose pull
09:11 MarkHofstetter1 I did
09:15 mtj then theres probably some error in your koha git repo
09:16 mtj everything seems happy on master and stable/21.11 branches
09:16 MarkHofstetter1 I didnt change anything to repo ie it is simply a checkout 21.11.x
09:17 MarkHofstetter1 then run ku-md10
09:18 mtj export KOHA_IMAGE=21.11-bullseye
09:18 mtj kd && ku-md10
09:19 * ashimema likes kul (light) if you don't need elastic ;)
09:23 mtj hmm, i see the doco does not mention 'export KOHA_IMAGE' - but it chooses a sane default, so can be ignored
09:24 mtj MarkHofstetter1: so.. whats the nondescript error? :)
09:25 mtj export RUN_TESTS_AND_EXIT="no"
09:26 mtj ^ ..that might be useful, not sure if its 'no' by default
09:28 mtj MarkHofstetter1: you might need to change to the 21.11 branch, within the ktd repo, and git fetch/pull
09:36 mtj web access for ktd 21.11 seems to work for me
10:00 oleonard Still around dcook ?
10:01 ashimema 8pm in Sydney
10:48 oleonard Oh, he commented on Bug 29155. I guess I should have made sure it applied before asking for testers :(
10:48 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29155 enhancement, P5 - low, ---, oleonard, Patch doesn't apply , Upgrade jquery version
10:54 MarkHofstetter1 so I upgraded everything, and goingg through the web install, the koha_kohadev db user doesn't have the correct privileges - is this normal?
10:56 MarkHofstetter1 (MariaDB [koha_kohadev]> GRANT ALL PRIVILEGES on koha_kohadev.* TO koha_kohadev; fixes this I know)
10:57 MarkHofstetter1 koha_1 | Inserting /kohadevbox/koha/installer/data/mysql/mandatory/message_transport_types.sql...
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 31 [Warning] Aborted connection 31 to db: 'koha_kohadev' user: 'root' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 11 [Warning] Aborted connection 11 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 44 [Warning] Aborted connection 44 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 42 [Warning] Aborted connection 42 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 12 [Warning] Aborted connection 12 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 db_1 | 2022-04-13 10:56:51 43 [Warning] Aborted connection 43 to db: 'koha_kohadev' user: 'koha_kohadev' host: '172.28.0.6' (Got an error reading communication packets)
10:57 MarkHofstetter1 koha_koha_1 exited with code 1
10:57 MarkHofstetter1 and before: koha_1 | C4::Installer::load_sql returned the following errors while attempting to load /kohadevbox/koha/installer/data/mysql/mandatory/message_transport_types.sql:
10:57 MarkHofstetter1 koha_1 | DBD::mysql::st execute failed: Duplicate entry 'email' for key 'PRIMARY' at /usr/share/perl5/DBIx/RunSQL.pm line 279, <$args{...}> line 1.
10:57 MarkHofstetter1 koha_1 | Something went wrong loading file /kohadevbox/koha/installer/data/mysql/mandatory/message_transport_types.sql ([SQL ERROR]: INSERT INTO message_transport_types
10:57 MarkHofstetter1 koha_1 | (message_transport_type)
10:57 MarkHofstetter1 koha_1 | values
10:58 MarkHofstetter1 koha_1 | ('email'),
10:58 MarkHofstetter1 koha_1 | ('print'),
10:58 MarkHofstetter1 koha_1 | ('sms'),
10:58 MarkHofstetter1 koha_1 | ('phone'),
10:58 MarkHofstetter1 koha_1 | ('itiva')
10:58 MarkHofstetter1 koha_1 | ) at /kohadevbox/koha/C4/Installer.pm line 582.
11:08 marcelr o/
11:08 oleonard Hi marcelr
11:14 mtj MarkHofstetter1: id suggest running the following
11:14 mtj kd && kd && ku-md10
11:15 mtj you seem to have a database that is already populated, when starting
11:15 mtj " Duplicate entry 'email' for key 'PRIMARY' at /usr/share/perl5/DBIx/RunSQL.pm "
11:15 MarkHofstetter1 no not when I run kd once
11:16 MarkHofstetter1 but I'm trying, shall I run populate db as suggested
11:16 mtj ..you shouldnt be hitting the web installer either, just a login then admin homepage
11:19 mtj MarkHofstetter1: you dont need to do anything else to get a working ktd koha
11:21 MarkHofstetter1 my problem is that I tried it on multiple fresh installs and it behaves the same everytime, so I am afraid I am doing something wrong systematically
11:23 MarkHofstetter1 I have the impression that something goes wrong with the database container (or maybe it's just too slow?)
11:23 mtj MarkHofstetter1: is your ktd repo up to date - and set to 21.11 branch?
11:24 MarkHofstetter1 yes both most recenet checkaout
11:24 mtj current commit is b57739f0c276e810213e060ed241aa694c84df4e
11:25 MarkHofstetter1 commit a4a6797b767a4e106c1e20b426c4cf695a85f101 (HEAD -> 21.11.x, origin/21.11.x)
11:26 mtj https://gitlab.com/koha-community/koha-testing-docker/-/commits/21.11
11:26 mtj b57739f0
11:26 MarkHofstetter1 ah the docker branch not koha
11:27 mtj np :)
11:28 cait1 Just wondering, is Debian 10 for Koha 20.11 ok?
11:28 MarkHofstetter1 commit b987d40850c073a6cf65637ea8d558ab0d22242f
11:29 MarkHofstetter1 it's 21.11
11:29 mtj cait1: yep, its ok :)
11:29 cait1 not realted to your question :)
11:29 cait1 thx mtj
11:30 cait1 has anyone experienced zebra issues on updating?
11:30 cait1 it looks like it might need a reindex after OS update, which is a little odd
11:30 marcelr its not a bad idea cait to reindex after an update
11:31 mtj cait1: if you are getting a newer version of zebra, then a reindex is a safe thing
11:31 mtj marcelr: snap
11:32 mtj MarkHofstetter1: try updating ktd repo
11:34 mtj MarkHofstetter1: b987d408 looks like master branch, not 21.11
11:34 mtj https://gitlab.com/koha-community/koha-testing-docker/-/commits/master
11:34 mtj b987d408
11:35 MarkHofstetter1 ah ok the ktd and koha myabe didnt "fit" together
11:37 mtj yeah, the master ktd branch points to new repo/packages that 21.11 breaks on
11:42 mtj MarkHofstetter1: make sure the KOHA_IMAGE var is set to 21.11, either in .env file - or..
11:42 mtj export KOHA_IMAGE=21.11
11:43 mtj ..else it defaults to master
11:44 MarkHofstetter1 ah now it's pulling the correct image
11:44 MarkHofstetter1 will take a little
11:46 MarkHofstetter1 (in the meantime thx a lot for helping, I want to contribute bug/feature fixes)
12:00 ashimema 🙂
12:12 cait1 :)
12:15 cait1 marcelr: OS update - we do for Koha usually
12:16 MarkHofstetter1 now it's working, thx folks!
12:22 cait1 tcohen: ping
12:33 fridolin MarkHofstetter1: any contribution is welcome, espacally testing / signing
12:37 fridolin paulderscheid[m]: yellow seen your mail shelf-browser replacement
12:37 fridolin look great
12:40 MarkHofstetter1 https://gitlab.com/koha-community/koha-testing-docker/-/merge_requests/315 I added a little to the documentation
13:24 ashimema thanks MarkHofstetter1
13:25 ashimema nice to see you here btw 🙂
13:25 ashimema great to see you managed to get k-t-d working.. apologies I wasn't much help.. been a busy day of meetings for me today.
13:39 tcohen hola
13:41 fridolin Hi, could someone test Bug 29744
13:41 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29744 enhancement, P5 - low, ---, martin.renvoize, Failed QA , Harmonize psgi/plack detection methods
13:41 fridolin in KTD i get direct error
13:44 nikkom Hi eveyone. I want to prevent the patron, who has overdue items, from making payment before check in the items
13:45 fridolin Ich big one Bug 30525
13:45 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30525 critical, P5 - low, ---, oleonard, NEW , Items batch modification broken
13:45 fridolin ashimema: do you reproduce ? ^
13:46 nikkom I have found out that the making payment button is in blocked-fines.inc file. But I coundnt understand how the patron has overdue or not
13:47 ashimema hmm, weird fridolin
13:47 ashimema I can take a look shortly.. just narrowing down a bug on a live server at the minute 😉
13:47 nikkom I would be appreciate if anyone help
13:51 fridolin nikkom: mmm no idea if we can do that sorry
13:53 ashimema I think you'd need to do that at a pretty low level nikkom..
13:53 ashimema there are lots of avenues to paying
13:57 oleonard Looks like any script that uses "my %cookies = parse CGI::Cookie($cookie);" is broken
13:57 ashimema yikes
14:00 oleonard I'm guessing it should be "my %cookies = CGI::Cookie->fetch();" ?
14:00 huginn News from kohagit: Bug 27783: DBRev 21.12.00.033 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=51192f98953b275bc28bf1cb8c79691b199f0d43>
14:00 huginn News from kohagit: Bug 30498: DBRev 21.12.00.032 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2876e8762224b6be18b572db123b8292ed9d4fe1>
14:00 huginn News from kohagit: Bug 30481: DBRev 21.12.00.031 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=80f735557179884003f659f454278ba5fc7523de>
14:00 huginn News from kohagit: Bug 30410: (QA follow-up) Only fetch plugins mapping once <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=412d4f4864558eceb22325074dccd05a3deaa979>
14:00 huginn News from kohagit: Bug 27783: (follow-up) Rename options <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=631d3500867f0cb59c8b9aed7bb4b78f068fc1fd>
14:00 huginn News from kohagit: Bug 30410: (QA follow-up) Pluralise new methods, fix minor issues with language <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=826a2d4e70c70c45cb08e42cf352455798fa52cf>
14:00 huginn News from kohagit: Bug 27783: (QA follow-up) Make dbrev executable <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c859066ee5f384c175d398684efa625263962954>
14:00 huginn News from kohagit: Bug 30498: Corresponding DBIx change for SearchField <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2fe5eb465291b1b6778787482d702ae287ef63d7>
14:00 huginn News from kohagit: Bug 30498: Fix enum search_field.type <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=045b4678582d86da5c98888cfaf444b3773d6005>
14:00 huginn News from kohagit: Bug 27783: Add queue handling in packaging tools <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f1fef6527c778977bd0d48e2cb42b5c9dc153a8f>
14:00 huginn News from kohagit: Bug 27783: DBIC update <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=015c114a6aefbb60d8b360d4b17610d2939f6d22>
14:00 huginn News from kohagit: Bug 27783: (QA follow-up) Make dbrev idempotent <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=db4baee498f3eab9d44efd00dd82b45e32ed8b29>
14:00 huginn News from kohagit: Bug 27783: Rename queues and adjust currently defined jobs <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9c4a89a7c815515f51e36119db899f9274f31ea8>
14:00 huginn News from kohagit: Bug 27783: Add --job-type to background_jobs_worker.pl <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a42717ad15bbbb772b7477ab374c75d1039350f9>
14:00 huginn News from kohagit: Bug 30410: Add a way for plugins to expose tasks they implement <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ebae23153dd06ccd2b37d7b206e4573aac656a7d>
14:00 huginn News from kohagit: Bug 30410: Unit tests <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=211044ad1a91d7c9bd83289fb928b34797b74756>
14:00 huginn News from kohagit: Bug 27783: (follow-up) Add DB change to installer <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=dc886e1b133a99d238f81be6ad5ec145528c353d>
14:00 huginn News from kohagit: Bug 27783: Add missing atomicupdate file <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=faf2a0723188c0b5d9a8cabe6a251d7ffb548784>
14:00 huginn News from kohagit: Bug 27783: Replace --job-type by --queue <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9acb599d16764a813f5481164cdaeec3b3d01f27>
14:00 huginn News from kohagit: Bug 29946: Sort Marc profiles alphabetically <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1269a074fc3948c1e61a27d8b00a18dc78acbf52>
14:01 oleonard fridolin, ashimema: I'm guessing it should be "my %cookies = CGI::Cookie->fetch();" ?
14:02 fridolin Could we add a method in new CookiesManager module ?
14:02 nikkom ashimema: I think I need to pass odues value in the file patron_messages.inc, to the file blocked-fines.inc. but I dont know how :(
14:02 oleonard As far as I can tell we're talking about 7 files
14:03 fridolin ahhh but $sessionID in useless in batchMod.pl o_O
14:04 fridolin indeed there are a lot of "my %cookies = CGI::Cookie->fetch();"
14:08 oleonard I will send a patch and y'all can check my work
14:09 fridolin oleonard: for batchMod il works by removing the session cookie fetch
14:10 oleonard yeah, batchMod, enqueue_koc.pl, modborrowers, and upload-cover-image.pl
14:10 oleonard All can have that code taken out
14:13 fridolin https://wiki.koha-community.org/wiki/Roles_for_22.11 we have a RM proposal wooooooo
14:13 fridolin tuxayo: yellow there ?
14:15 alohabot 🎠🦄 Koha 'master' packages pushed to 'koha-staging' repo ðŸ°ðŸ°ðŸ¨
14:19 marcelr fridolin: bug 30522 is a major issue for authorities under Elastic
14:19 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30522 major, P5 - low, ---, koha-bugs, NEW , SearchEngine::simple_search_compat should not limit to 100 records for ElasticSearch (causing incomplete authority merges)
14:33 tcohen holy, fridolin
14:33 tcohen fridolin++
14:34 fridolin ah good catch
14:37 koha-jenkins Project Koha_Master_D10 build #589: STILL UNSTABLE in 37 min: https://jenkins.koha-community.org/job/Koha_Master_D10/589/
14:47 koha-jenkins Project Koha_Master_D12 build #120: STILL UNSTABLE in 47 min: https://jenkins.koha-community.org/job/Koha_Master_D12/120/
15:00 koha-jenkins Project Koha_Master_Sid build #8: STILL UNSTABLE in 58 min: https://jenkins.koha-community.org/job/Koha_Master_Sid/8/
15:05 tuxayo fridolin: hi
15:05 koha-jenkins Project Koha_Master_D11_MDB_Latest build #859: UNSTABLE in 1 hr 3 min: https://jenkins.koha-community.org/job/Koha_Master_D11_MDB_Latest/859/
15:11 reiveune bye
15:14 koha-jenkins Project Koha_Master_U_Stable build #433: UNSTABLE in 37 min: https://jenkins.koha-community.org/job/Koha_Master_U_Stable/433/
15:22 koha-jenkins Project Koha_Master_U20 build #355: FAILURE in 2 min 46 sec: https://jenkins.koha-community.org/job/Koha_Master_U20/355/
15:33 koha-jenkins Project Koha_Master_U_Next build #13: UNSTABLE in 45 min: https://jenkins.koha-community.org/job/Koha_Master_U_Next/13/
15:41 oleonard khall_ around?
15:56 koha-jenkins Project Koha_Master_U21 build #140: STILL UNSTABLE in 55 min: https://jenkins.koha-community.org/job/Koha_Master_U21/140/
15:56 koha-jenkins Project Koha_Master_D9 build #1923: STILL UNSTABLE in 41 min: https://jenkins.koha-community.org/job/Koha_Master_D9/1923/
15:59 oleonard If anyone is still around, patch added to Bug 30525
15:59 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30525 critical, P5 - low, ---, oleonard, Needs Signoff , Items batch modification broken
16:08 koha-jenkins Project Koha_Master_D11_My8 build #792: UNSTABLE in 1 hr 3 min: https://jenkins.koha-community.org/job/Koha_Master_D11_My8/792/
16:18 koha-jenkins Project Koha_Master_U21 build #141: STILL UNSTABLE in 45 min: https://jenkins.koha-community.org/job/Koha_Master_U21/141/
16:44 tootsiemel For a grant I need to show how many books were checked out by each grade level. How do I do that?
16:44 oleonard Do you store grade information for all of your patrons somewhere?
16:46 tootsiemel When I enter the kids into the system I put down the year that they will graduate, so it should be in there somewhere. I am new to this and have no training with KOHA.
16:47 oleonard Where do you put the year?
16:47 tootsiemel I was able to figure out the total number of books checked out last year and compared to this year. I just don't know how to break that down to the grade level.
16:49 tootsiemel I would enter it in the Voyager stats Code...THis is under the headline Additional Attributes and Identifiers
17:01 koha-jenkins Project Koha_Master build #1975: STILL UNSTABLE in 1 hr 4 min: https://jenkins.koha-community.org/job/Koha_Master/1975/
17:06 oleonard tootsiemel: You'll have to compose an SQL report.
17:07 oleonard tootsiemel: This report has an example of how to do a join on borrower_attributes: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Overdues_by_Homeroom.2FAttribute
17:08 oleonard You'd need to do something similar but query the statistics table.
17:10 tootsiemel Ok, thank you!! I appreciate your help :)
17:11 oleonard it's not much help, but it's a vague start
17:27 oleonard API requests still broken for me in master.... Not sure what's going on...
18:05 koha-jenkins Project Koha_Master build #1976: STILL UNSTABLE in 1 hr 4 min: https://jenkins.koha-community.org/job/Koha_Master/1976/
18:52 kidclamp is everyone's patron search broken on master?
20:19 tcohen kidclamp: yes
20:19 tcohen I've submitted a patch on bug 29810
20:19 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29810 enhancement, P5 - low, ---, martin.renvoize, Pushed to master , Add embed options documentation