IRC log for #koha, 2023-06-22

All times shown according to UTC.

Time S Nick Message
00:51 dcook TFW you get the a database upgrade script to take .06 seconds instead of 1.2 seconds...
00:58 dcook bug 34088
00:58 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34088 enhancement, P5 - low, ---, dcook, NEW , Schema upgrade should short circuit faster if no upgrade needs to be done
05:37 marcelr joined #koha
05:37 marcelr o/
06:30 magnuse \o
06:30 magnuse dcook++
06:40 reiveune joined #koha
06:40 reiveune hello
06:40 wahanui hola, reiveune
07:00 thibaud_g joined #koha
07:01 cait joined #koha
07:02 alex_ joined #koha
07:04 cait1 joined #koha
07:08 cait2 joined #koha
07:09 fridolin joined #koha
07:15 NikolayGospodinov[m] Hi. I have a question
07:16 NikolayGospodinov[m] I am using this Database Restoration command: sudo mysql -uroot -p koha_library < koha_library.sql. Is it a problem that my sql file is more than 50 GB?
07:19 NikolayGospodinov[m] I asked that because in phpMyAdmin when I check, only 137 MiB were transferred (7 tables)
07:19 NikolayGospodinov[m] thi command is running for almost 10 minutes
07:29 cait2 7 tables doesn't seem correct
07:29 cait2 do you have enough space on your server?
07:36 NikolayGospodinov[m] yes
07:36 cait joined #koha
07:39 cait1 joined #koha
07:47 NikolayGospodinov[m] is it possible the problem to be in phpMyAdmin?
08:14 fridolin you can use mysql -e 'show tables'
08:14 fridolin to me sounds normal that it takes several hours
08:15 fridolin 50Go to push + indexes building
08:15 NikolayGospodinov[m] aha
08:16 fridolin you also may use : mysql -e 'show processlist' to follow import
08:16 fridolin ususally tables are imported alphabetically, zebraqueue beeing last one
08:22 PedroAmorim[m] \o
08:52 cait1 fridolin++
08:52 cait1 hi PedroAmorim[m]
09:06 * fridolin late on backporting, will normally release tomorrow a light 23.05.x and try to catchup next month
09:07 fridolin lots of work from clients going to hollidays :B
09:07 fridolin B)
09:10 cait1 fridolin: thee are a few bad bugs
09:10 cait1 but not sure if we will ahve fixes done in time, at the moment a little pessimistic
09:11 cait1 bug 34022
09:11 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34022 blocker, P1 - high, ---, koha-bugs, NEW , Adding items on receive is broken
09:11 cait1 is pretty bad, but no patch yet
09:11 cait1 but if there is one tomorrow, it wuld be well worth having it, it breaks acq and has been reported multiple times already
09:12 fridolin arf
09:12 cait1 yeah, not great
09:12 fridolin a chance most companies wait for stable branch to reach several month before going to production
09:12 cait1 teh receive is done, but the items "disappear"
09:13 fridolin we at Biblibre use > .05
09:13 cait1 we already had reports from people updating in production
09:13 cait1 they trust us too much ;)
09:13 fridolin indeed ;)
09:13 cait1 I believe more self hosted ones, but they also have more trouble fixing themselves usually
09:21 magnuse ouch
09:30 magnuse could we reduce the risk of that by changing our numbering scheme? like calling the first few releases of a new version "beta" or something?
09:35 cait1 I am nots ure if that would help
09:35 cait1 I believe some people might be following stable, updating automatically
09:36 ashimema the main issue is we struggle to have wider testing
09:36 cait1 it always boils down to resources
09:37 ashimema we need libraries to play
09:37 ashimema early adopters
09:37 cait1 we could try setting encouraging beta testing in the string freeze period
09:37 cait1 -setting
09:38 cait1 like with a separate email to lists etc. and some instructions how to set up a sandbox for it - or have a dedicated sandbox, but people might step on each others toes then
10:01 cait joined #koha
10:19 khall joined #koha
10:20 khall joined #koha
10:27 mandrake joined #koha
10:30 mandrake Hello, I'm a newbie in this channel, and I'm looking for a problem resolution with a personal koha instance. Is this the right place for such a question?
10:32 PedroAmorim[m] sure mandrake ask away!
10:34 mandrake My personal koha instance is recently showing the web intaller page instead of the staff login page. The library is still there, though.
10:45 cait did you update?
10:45 cait the web installer will come up for updates as well
10:45 cait have you tried running it?
10:53 mandrake I always update to the latest version, but I do it with the Debian apt. When I try to login to the web installer with the credentials from koha-conf.xml I get "Invalid username or password".
10:57 cait hm they shoudl be working
10:57 cait what migh thave happened is that the automatism had an error
10:57 cait so the update didn't finish
10:57 cait if you prefer command-line, youcould also run sudo koha-update-schema instance
10:57 cait and see what the output is
10:58 cait mandrake: ^
11:01 mandrake koha-upgrade-schema ollilib
11:01 mandrake Upgrading database schema for ollilib
11:01 mandrake Upgrade to 22.12.00.041  [13:01:08]: Bug 30649 - Increase the vendor EDI account password field to 256 characters
11:01 mandrake ERROR - Exception 'Koha::Exceptions::MissingParameter' thrown 'No encryption_key in koha-conf.xml'
11:01 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=30649 normal, P5 - low, ---, kyle, Pushed to stable , Vendor EDI account passwords should be encrypted in the database
11:02 cait yes
11:02 cait ok, you need to edit your koha-conf.xml
11:02 cait and add a missing entry, let me find it
11:02 tcohen we should add a better message
11:04 cait you need these lines mentioned here:
11:04 cait https://lists.katipo.co.nz/pip[…]-June/059658.html
11:04 cait and replace __ENCRYPTION_KEY__ by an actual key, you can generate one with pwgen I think
11:05 cait and possibly other tools too, but we don't want to keep the placeholder :)
11:05 cait brb
11:10 ashimema grr
11:10 ashimema seems we refer to 'searchtype' in a lot of templates.. but we hardly ever actually pass it.
11:13 tcohen is pwgen a dependency for Koha?
11:13 tcohen it is
11:15 oleonard joined #koha
11:15 mandrake I was able to login to the web installer (wrong credentials in the first place), running through the steps, at lasTKoha::Exceptions::MissingParameter
11:16 mandrake In which part of the koha-conf.xml do I place the encryption parameter?
11:21 tcohen at the bottom
11:22 tcohen inside the </config> section
11:25 alex_ joined #koha
11:27 mandrake Yeah, I thought so :-)
11:27 cait when you have done that, restart "alll the things" (koha-common I think) and then it shoud go through
11:27 mandrake Doing this enables the database upgrade to run smoothly. Login to the libary possible again.
11:28 cait great :)
11:28 mandrake Thanky you guys for your help!
11:31 tcohen systemctl restart memcached koha-common apache2 I'd say
11:32 tcohen (apache2 is not required, though)
12:00 fridolin joined #koha
12:09 ashimema stupid question
12:09 ashimema what's the difference between member.pl and members-home.pl from a user perspective?
12:13 cait I don't know
12:13 ashimema they look like they should be merged
12:14 ashimema they share a template
12:14 cait it looks like one is a start page and the other results?
12:14 cait it's not a real homepage... maybe we could merge to member.pl
12:15 ashimema indeed.. a general cleanup
12:15 ashimema looks like member-home is used a lot more
12:15 ashimema member.pl is only linked to from two pages (memberentrygen and member-search-box)
12:15 ashimema I say pages.. two templates
12:16 ashimema members-home is all over the place
12:17 oleonard Looking at the po files it seems like we need a template directive to *not* translate something
12:17 ashimema I was thinking that the other day
12:17 ashimema might enlist your help at some point oleonard.. I'm totally confused by our patron searchtype handling (i.e contains|starts_with)
12:18 ashimema in the templates that is..
12:18 oleonard Uh oh so am I
12:18 ashimema if I actually pass a type we seem to blank the input
12:18 ashimema lol
12:18 cait there are a few open bugs about patron search right now
12:19 cait laura e. was workign on one of them
12:19 ashimema yup
12:19 ashimema I'm working on them
12:19 ashimema that's what made me dive into it.
12:19 cait awesome
12:19 * cait likes bug fixing
12:19 ashimema bug 33117 to start
12:19 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33117 normal, P5 - low, ---, Laura.escamilla, Passed QA , Patron checkout search not working if searching with second surname
12:19 cait yes, that was the one I had i mind
12:19 cait I thik there are some satellite bugs that might or might not be duplicates
12:19 ashimema I've passed it for now.. but it needs a follow-up for the final comments on the bug..
12:20 ashimema Pedro's sounds similar but isn't
12:20 cait hm maybe not pass it then? :) we should try to save RM time when possible (not in his queue if not ready)
12:23 ashimema follow-up bug
12:23 ashimema not in this one
12:23 cait ok
12:23 ashimema it's a huge job to deal with the comment
12:24 cait if it helpls on its own that's alright
12:24 ashimema the comment is 'Make search consistent everywhere, grump grump'
12:24 cait right
12:24 ashimema that's a BIG job
12:24 ashimema this bug fixes the issue in hand and should be pushed
12:27 cait yep, that makes sense
12:27 cait I was jut trying to avoid a needs_additional_work in PQA
12:28 cait we are on the same page
12:33 thibaud_g joined #koha
12:38 Dyrcona joined #koha
12:40 khall joined #koha
12:51 fridolin left #koha
12:53 emlam joined #koha
12:53 emlam o/
12:55 cait hi emlam :)
13:03 mandrake joined #koha
13:36 khall_ joined #koha
13:50 oleonard caroline around?
13:50 caroline yes
13:50 pastebot "oleonard" at 127.0.0.1 pasted "Is this a clear way to use context here?" (5 lines) at https://paste.koha-community.org/19732
13:50 caroline what did I do?
13:51 oleonard You did/do good i18n stuff :D
13:51 caroline ok phew! I thought it was something wrong lol
13:52 caroline I think your context is clear
13:52 caroline I wonder if we could expand to "On (date)" in general?
13:52 caroline like (item changed status) on (date)
13:53 cait caroline: I agree, the on is a difficult one in German too
13:53 cait From sometimes as well
13:53 cait From (place) From (date) ...
13:53 cait caroline++
13:54 caroline in French it's the "to" From (place) to (place) vs. From (date) to (date)
13:54 marie-luce joined #koha
13:54 cait yeah, to is also bad in German
13:54 cait to (email) to (date) ...
13:55 cait is different words
13:56 cait all the prepositions are probably problematic...
13:56 cait when they appear alone
13:56 caroline do you think "on" would be different depending on what changed on the date?
13:56 caroline (patron paid for item) on (date) vs (item changed status) on (date)
13:57 caroline I think we could use the "on (date)" context more globally
13:59 oleonard I think my title translation patches are going to clean up a lot of mess from the po file
13:59 caroline oleonard++ thanks for working on this!
14:06 cait i think that would work for German
14:07 cait oleonard++ thx for caring about translations :)
14:08 oleonard It triggers my need for tidying up :)
14:09 cait I can relate to that :)
14:09 cait I had to fight hard not to tidy up a friend's book shelf last night
14:09 oleonard :D
14:09 caroline lol!
14:09 cait they were all toppled over...
14:18 cait someone around who could test 34006 in 22.11?
14:18 cait bug 34006
14:18 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34006 major, P5 - low, ---, katrin.fischer, Needs Signoff , [22.11] Keep the current option for funds in receiving returns an error 500 or saves wrong fund
14:18 cait it's a bad one, but because it's not in master a little harder to test
14:19 cait the fix is just changing a variable (one character)
14:22 emlam I'll give it a try. I'm not super familiar with acquisitions workflows, but your test plan looks pretty clear (and I need to learn more about acquisitions anyway :)   )
14:24 cait thanks emlam, I am happy to help if there are any questions
14:25 emlam :)
14:26 cait1 joined #koha
14:36 khall joined #koha
14:46 ashimema bug 34094 cait, oleonard
14:46 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34094 normal, P5 - low, ---, martin.renvoize, Needs Signoff , Apply DefaultPatronSearchMethod to all patron search forms
14:46 ashimema would love your input as I'm sure I've missed some interfaces
14:53 cait1 I am a bit worried about the contains vs. exact
14:53 ashimema was there ever an exact?
14:53 cait1 i noticed that when you use the filters with 42 in sample data (cardnumber of admin), you get all results containing 42 instead of a redirect to the user (as it used to be)
14:54 cait1 there was a shortcut on the cardnumber exact match
14:54 cait1 leading to the patron record
14:54 cait1 it still does that, in holds for example
14:54 ashimema Ah yes.. I noticed that when I QA'd Nicks first patch that changed them all to starts_with
14:54 cait1 an example is the holds patron search
14:54 ashimema I even pointed it out from memory but I kinda got talked out of it.
14:55 cait1 I think we'd want to keep that there and in other spots
14:55 cait1 you want to be able to scan th ecard in those places
15:00 bag joined #koha
15:01 ashimema can you come up with a test plan for when that doesn't work right now?
15:01 ashimema if I paste a cardnumber it pretty much always takes me straight to the patron
15:01 ashimema so I must not have the right data to replicate the issue your seeing
15:02 cait1 try a short cardnumber
15:02 cait1 like 42, 1, that comes up in other records
15:02 cait1 it doesn't work int he filters on the left side of members I think - I just wanted to add it to the test cases so the generalizing doesn't break it
15:03 ashimema I updated Henry Acevedo to have a cardnumber of '23'
15:03 ashimema searching 23 always returns him directly
15:03 ashimema even though there's lots of other cardnumbers that start with 23
15:04 ashimema for both 'contains' and 'starts_with' options
15:05 ashimema OK.. left side filters
15:05 ashimema but I'd expect it not to work there
15:06 ashimema we could add 'exect' as an option to that side menu I suppose.. would that be enough?
15:07 ashimema that's what 'quicksearch' in members/member.pl does as far as I can tell
15:07 ashimema executres a fast 'find' on cardnumber before falling back to search
15:10 cait1 maybe it does need to be able to work differently... in patron search vs. circulation functions
15:10 cait1 you might want to search for patrons that contain something to have a list... but when doing circ or holds you need/want the falback
15:11 ashimema the fallback is there
15:11 ashimema my brain is struggling this afternoon
15:11 ashimema a good discussion to have
15:11 ashimema but I'm, struggling to follow I'm afraid
15:11 cait1 sorry, you asked for input )
15:12 ashimema no worries
15:12 ashimema I wanted it
15:12 ashimema I just didn't realise how dead my brain is already 😜
15:12 cait1 but I understand the struggle, similar here
15:14 reiveune bye
15:14 reiveune left #koha
15:15 cait1 thank you emlam! :)
15:16 cait1 emlam++
15:16 emlam No problem! :)
15:16 cait1 ashimema: can I interest you i a quick QA? bug 34006 (trying to take advantage of your dead brain ;) )
15:16 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34006 major, P5 - low, ---, katrin.fischer, Signed Off , [22.11] Keep the current option for funds in receiving returns an error 500 or saves wrong fund
15:16 cait1 it#s a one character fix!
15:16 ashimema certianly
15:18 ashimema LOL.. my brain really is dead
15:18 ashimema I fell at the first hurdle.. forgot it was 22.11.x based!
15:19 cait1 I beleive in you :)
15:21 cait1 with a bit of luck we will get rain later this evening... can't wait
15:21 oleonard If I run an SQL report that selects * from borrowers and export it as CSV, shouldn't that be able to be imported without problems?
15:21 cait1 it's been very hot and dry, hard to think
15:22 cait1 yes and no... we do have a paron export script that used to work, but with some extra fields added it does no longer either (I filed a bug for that)
15:22 ashimema LOL
15:22 cait1 maybe some of the fields don't import... do you have an error message?
15:22 ashimema I hadn't realise BZ prevented one from changing from PQA to Pushed to oldstable!
15:22 oleonard I'm thinking in particular of importing patrons via Tools
15:22 cait1 yes, I thought so :)
15:23 oleonard It says the records are not in the expected format
15:23 cait1 do you have a header line?
15:23 cait1 does the header line have ""?
15:23 cait1 (it shoudl not)
15:26 ashimema you made it just before release.. we were going to roll it this afternoon
15:26 ashimema but with the audit I've put it back to tmorrow 🙂
15:30 oleonard It's weird, the error messages seem to indicate that it doesn't recognize the column names... 'Critical field "categorycode" has unrecognized value "APL" '. But I've double-checked that the columns have the correct data
15:30 oleonard Oh you know what, I wonder if my db is messed up... That's usually the reason things break.
15:30 cait1 hm could something be in the wrong spot? like commas within the data and not quoted?
15:31 cait1 did you search for APL in your data?
15:36 khall_ joined #koha
15:41 cait joined #koha
15:43 cait bye all, bbl
15:43 cait left #koha
15:43 ashimema bug 29822 still awaiting a final QA
15:43 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=29822 enhancement, P5 - low, ---, martin.renvoize, Signed Off , Use table column selection modal for DefaultPatronSearchFields preference
15:43 ashimema ☹️
15:50 cait joined #koha
16:04 ashimema @later tell magnuse is bug 18203 something you might be interested in?
16:04 huginn ashimema: The operation succeeded.
16:33 oleonard dcook's tool in Bug 34064 helped me fix my db and now patron imports work
16:33 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=34064 enhancement, P5 - low, ---, dcook, Needs Signoff , Compare kohastructure.sql against current database using database audit script
16:36 khall joined #koha
16:56 cait dcook++ :)
16:57 caroline how does one archive a currency? I see the column in Admin > Currencies and exchange rates, but there is not 'Archive' button that I can see
16:59 caroline I tried deleting a currency that was being used in an order and it just didn't let me
17:06 caroline Ok I think it was just added to prevent data loss, and nothing more https://bugs.koha-community.or[…].cgi?id=15084#c38
17:06 huginn Bug 15084: enhancement, P5 - low, ---, jonathan.druart+koha, CLOSED FIXED, Move the currency related code to Koha::Acquisition::Currenc[y|ies]
17:07 cait caroline: might still be a good idea ot have it for real
17:07 cait sometimes currencies change or actually retire
17:08 oleonard joined #koha
17:36 khall_ joined #koha
18:14 magnuse bug 18203
18:15 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=18203 enhancement, P5 - low, ---, pedro.amorim, Needs Signoff , Add per borrower category restrictions on placing ILL requests in OPAC
18:15 magnuse ashimema: not something customers have been asking about, but still interesting
18:26 tcohen any dev around?
18:26 * cait can offer a QA person
18:30 tcohen I'm having a situation with JS sending a CGI controller
18:30 tcohen param[]
18:30 tcohen instead of just param
18:31 tcohen on a repeatable variable
18:31 cait I might not be the right person then
18:33 tcohen my remote debugger is not working anymore
18:33 tcohen might need to switch into another tool
18:36 oleonard Duplicate authority records not being caught anymore? I can't get the authority editor to trigger the duplicate record warning
18:36 khall joined #koha
18:37 cait there are several open bugs in this area
18:37 cait hm but that's for the linker
18:37 cait not sure I have seen one for the normal editor - or ever seen the warning there
18:39 tcohen I pushed one about that
18:41 cait bug number? :)
18:41 caroline I have a client screenshot from 22.05 where there is a possible duplicate message for authorities, although they have a very modified Koha, so it might just be them
18:42 oleonard It could be ancient copy-paste from addbiblio
18:42 tcohen bug 31185
18:42 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=31185 normal, P5 - low, ---, adolfo.rodriguez, Pushed to master , Link authorities automatically doesn't detect duplicate authorities
18:42 tcohen with unit tests from kidclamp
18:44 cait tcohen: linker, not editor :)
18:48 cait1 joined #koha
18:49 emlam Anyone up for QAing bug 33573?
18:49 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=33573 normal, P5 - low, ---, tomascohen, Signed Off , Add public endpoint for cancelling holds
18:49 tcohen pass :-P
18:49 emlam lol
18:50 cait1 I owe you, but I really need to work on some bug bugs (vs. enh) first
18:51 * cait1 waits for her ktd pull
18:51 emlam totally fair
19:00 cait1 ktd pull is taking foreeeever
19:01 tcohen we need to pull out cypress and stuff
19:14 tcohen bye!
19:42 kidclamp ashimema++
19:42 cait1 auth duplicates?
19:42 cait1 ashimema++
20:22 cait1 caroline: you are on a roll today :)
20:28 caroline lol oleonard's tidy gene contaminated me
20:32 cait1 hehe
21:14 khall joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary