← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
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 | bug 34088 | |
00:58 | huginn | 04Bug 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 | 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 | 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 | I asked that because in phpMyAdmin when I check, only 137 MiB were transferred (7 tables) | |
07:19 | thi command is running for almost 10 minutes | |
07:29 | cait2 | 7 tables doesn't seem correct |
07:29 | 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 | to me sounds normal that it takes several hours | |
08:15 | 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 | ususally tables are imported alphabetically, zebraqueue beeing last one | |
08:22 | PedroAmorim[m] | \o |
08:52 | cait1 | fridolin++ |
08:52 | 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 | B) | |
09:10 | cait1 | fridolin: thee are a few bad bugs |
09:10 | but not sure if we will ahve fixes done in time, at the moment a little pessimistic | |
09:11 | bug 34022 | |
09:11 | huginn | 04Bug 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 | 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 | 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 | 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 | 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 | early adopters | |
09:37 | cait1 | we could try setting encouraging beta testing in the string freeze period |
09:37 | -setting | |
09:38 | 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 | the web installer will come up for updates as well | |
10:45 | 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 | what migh thave happened is that the automatism had an error | |
10:57 | so the update didn't finish | |
10:57 | if you prefer command-line, youcould also run sudo koha-update-schema instance | |
10:57 | and see what the output is | |
10:58 | mandrake: ^ | |
11:01 | mandrake | koha-upgrade-schema ollilib |
11:01 | Upgrading database schema for ollilib | |
11:01 | Upgrade to 22.12.00.041 [13:01:08]: Bug 30649 - Increase the vendor EDI account password field to 256 characters | |
11:01 | ERROR - Exception 'Koha::Exceptions::MissingParameter' thrown 'No encryption_key in koha-conf.xml' | |
11:01 | huginn | 04Bug 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 | ok, you need to edit your koha-conf.xml | |
11:02 | 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 | https://lists.katipo.co.nz/pip[…]-June/059658.html | |
11:04 | and replace __ENCRYPTION_KEY__ by an actual key, you can generate one with pwgen I think | |
11:05 | and possibly other tools too, but we don't want to keep the placeholder :) | |
11:05 | brb | |
11:10 | ashimema | grr |
11:10 | 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 | 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 | In which part of the koha-conf.xml do I place the encryption parameter? | |
11:21 | tcohen | at the bottom |
11:22 | 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 | (apache2 is not required, though) | |
12:00 | fridolin joined #koha | |
12:09 | ashimema | stupid question |
12:09 | 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 | they share a template | |
12:14 | cait | it looks like one is a start page and the other results? |
12:14 | it's not a real homepage... maybe we could merge to member.pl | |
12:15 | ashimema | indeed.. a general cleanup |
12:15 | looks like member-home is used a lot more | |
12:15 | member.pl is only linked to from two pages (memberentrygen and member-search-box) | |
12:15 | I say pages.. two templates | |
12:16 | 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 | might enlist your help at some point oleonard.. I'm totally confused by our patron searchtype handling (i.e contains|starts_with) | |
12:18 | 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 | lol | |
12:18 | cait | there are a few open bugs about patron search right now |
12:19 | laura e. was workign on one of them | |
12:19 | ashimema | yup |
12:19 | I'm working on them | |
12:19 | 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.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 | 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 | 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 | 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 | this bug fixes the issue in hand and should be pushed | |
12:27 | cait | yep, that makes sense |
12:27 | I was jut trying to avoid a needs_additional_work in PQA | |
12:28 | 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 | I think your context is clear | |
13:52 | I wonder if we could expand to "On (date)" in general? | |
13:52 | like (item changed status) on (date) | |
13:53 | cait | caroline: I agree, the on is a difficult one in German too |
13:53 | From sometimes as well | |
13:53 | From (place) From (date) ... | |
13:53 | 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 | to (email) to (date) ... | |
13:55 | is different words | |
13:56 | all the prepositions are probably problematic... | |
13:56 | when they appear alone | |
13:56 | caroline | do you think "on" would be different depending on what changed on the date? |
13:56 | (patron paid for item) on (date) vs (item changed status) on (date) | |
13:57 | 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 | 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 | 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 | someone around who could test 34006 in 22.11? | |
14:18 | bug 34006 | |
14:18 | huginn | 04Bug 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 | 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 | 04Bug 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 | there was a shortcut on the cardnumber exact match | |
14:54 | leading to the patron record | |
14:54 | 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 | 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 | if I paste a cardnumber it pretty much always takes me straight to the patron | |
15:01 | so I must not have the right data to replicate the issue your seeing | |
15:02 | cait1 | try a short cardnumber |
15:02 | like 42, 1, that comes up in other records | |
15:02 | 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 | searching 23 always returns him directly | |
15:03 | even though there's lots of other cardnumbers that start with 23 | |
15:04 | for both 'contains' and 'starts_with' options | |
15:05 | OK.. left side filters | |
15:05 | but I'd expect it not to work there | |
15:06 | we could add 'exect' as an option to that side menu I suppose.. would that be enough? | |
15:07 | that's what 'quicksearch' in members/member.pl does as far as I can tell | |
15:07 | 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 | 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 | my brain is struggling this afternoon | |
15:11 | a good discussion to have | |
15:11 | but I'm, struggling to follow I'm afraid | |
15:11 | cait1 | sorry, you asked for input ) |
15:12 | ashimema | no worries |
15:12 | I wanted it | |
15:12 | 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 | 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.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 | LOL.. my brain really is dead | |
15:18 | I fell at the first hurdle.. forgot it was 22.11.x based! | |
15:19 | cait1 | I beleive in you :) |
15:21 | 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 | 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 | does the header line have ""? | |
15:23 | (it shoudl not) | |
15:26 | ashimema | you made it just before release.. we were going to roll it this afternoon |
15:26 | 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 | 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 | 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 | 04Bug 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 | 04Bug 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 | I tried deleting a currency that was being used in an order and it just didn't let me | |
17:06 | 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 | 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 | sometimes currencies change or actually retire | |
17:08 | oleonard joined #koha | |
17:36 | khall_ joined #koha | |
18:14 | magnuse | bug 18203 |
18:15 | huginn | 04Bug 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 | param[] | |
18:30 | instead of just param | |
18:31 | 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 | 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 | hm but that's for the linker | |
18:37 | 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.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 | 04Bug 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 | bye! | |
19:42 | kidclamp | ashimema++ |
19:42 | cait1 | auth duplicates? |
19:42 | ashimema++ | |
20:22 | 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 |
← Previous day | Today | Next day → | Search | Index