Time 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 04Bug https://bugs.koha-community.org/bugzilla3/show_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 o/ 06:30 magnuse \o 06:30 magnuse dcook++ 06:40 reiveune hello 06:40 wahanui hola, reiveune 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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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/pipermail/koha/2023-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 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: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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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:53 emlam o/ 12:55 cait hi emlam :) 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 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 04Bug https://bugs.koha-community.org/bugzilla3/show_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:46 ashimema bug 34094 cait, oleonard 14:46 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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:43 cait bye all, bbl 15:43 ashimema bug 29822 still awaiting a final QA 15:43 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29822 enhancement, P5 - low, ---, martin.renvoize, Signed Off , Use table column selection modal for DefaultPatronSearchFields preference 15:43 ashimema âšī¸ 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 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34064 enhancement, P5 - low, ---, dcook, Needs Signoff , Compare kohastructure.sql against current database using database audit script 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.org/bugzilla3/show_bug.cgi?id=15084#c38 17:06 huginn 04Bug 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 18:14 magnuse bug 18203 18:15 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_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: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 04Bug https://bugs.koha-community.org/bugzilla3/show_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:49 emlam Anyone up for QAing bug 33573? 18:49 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_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