IRC log for #koha, 2021-04-06

All times shown according to UTC.

Time S Nick Message
00:00 khall joined #koha
00:02 khall joined #koha
00:04 khall joined #koha
00:05 khall joined #koha
00:07 khall joined #koha
00:08 khall joined #koha
00:09 khall joined #koha
00:15 khall joined #koha
00:17 khall joined #koha
00:19 khall joined #koha
00:24 khall joined #koha
00:25 oleonard-away Wainui: You can upload tool plugins via the Admin page can't you?
00:26 khall joined #koha
00:26 oleonard-away Yeah. I think the assumption is that only admins should be installing plugins anyway.
00:26 * oleonard-away really away
00:29 khall joined #koha
00:33 khall joined #koha
00:35 khall joined #koha
00:39 khall joined #koha
00:39 AndrewFH joined #koha
00:41 khall joined #koha
00:44 khall joined #koha
00:48 khall joined #koha
00:53 khall joined #koha
00:56 khall joined #koha
01:01 khall joined #koha
01:03 khall joined #koha
01:10 khall joined #koha
01:17 khall joined #koha
01:19 khall joined #koha
01:20 khall joined #koha
01:23 khall joined #koha
01:24 khall joined #koha
01:27 khall joined #koha
01:28 khall joined #koha
01:30 khall joined #koha
01:31 khall joined #koha
01:32 khall joined #koha
01:35 khall joined #koha
01:42 khall joined #koha
01:45 khall joined #koha
01:52 khall joined #koha
01:53 khall joined #koha
01:57 caroline joined #koha
02:02 khall joined #koha
02:03 khall joined #koha
02:04 khall joined #koha
02:08 khall joined #koha
02:11 khall joined #koha
02:14 khall joined #koha
02:15 khall joined #koha
02:18 khall joined #koha
02:19 khall joined #koha
02:23 khall joined #koha
02:26 khall joined #koha
02:27 khall joined #koha
02:29 khall joined #koha
02:38 khall joined #koha
02:40 khall joined #koha
02:44 khall joined #koha
02:47 khall joined #koha
02:48 khall joined #koha
02:53 khall joined #koha
02:55 khall joined #koha
02:55 khall joined #koha
02:56 khall joined #koha
02:58 dcook joined #koha
02:58 * dcook waves
02:59 dcook Bugzilla broken for anyone else or just me? heh
03:00 khall joined #koha
03:00 dcook rangi: Just sending you an email now about my account being locked out
03:01 khall joined #koha
03:03 khall joined #koha
03:05 khall joined #koha
03:06 khall joined #koha
03:07 khall joined #koha
03:09 khall joined #koha
03:09 khall joined #koha
03:14 khall joined #koha
03:16 khall joined #koha
03:19 khall joined #koha
03:20 khall joined #koha
03:24 khall joined #koha
03:28 khall joined #koha
03:30 khall joined #koha
03:33 khall joined #koha
03:33 khall joined #koha
03:35 khall joined #koha
03:42 khall joined #koha
03:47 khall joined #koha
03:52 khall joined #koha
03:54 khall joined #koha
03:57 khall joined #koha
03:59 khall joined #koha
04:01 khall joined #koha
04:04 khall joined #koha
04:06 khall joined #koha
04:07 khall joined #koha
04:09 khall joined #koha
04:11 khall joined #koha
04:13 khall joined #koha
04:14 khall joined #koha
04:15 khall joined #koha
04:16 khall joined #koha
04:17 khall joined #koha
04:19 khall joined #koha
04:21 khall joined #koha
04:22 khall joined #koha
04:26 khall joined #koha
04:30 khall joined #koha
04:33 khall joined #koha
04:39 khall joined #koha
04:45 khall joined #koha
04:47 khall joined #koha
04:47 * dcook blinks
04:53 khall joined #koha
04:56 khall joined #koha
05:01 khall joined #koha
05:02 khall joined #koha
05:03 khall joined #koha
05:04 khall joined #koha
05:05 khall joined #koha
05:07 khall joined #koha
05:08 khall joined #koha
05:10 khall joined #koha
05:17 khall joined #koha
05:20 khall joined #koha
05:20 khall joined #koha
05:23 khall joined #koha
05:26 khall joined #koha
05:26 khall joined #koha
05:30 khall joined #koha
05:30 khall joined #koha
05:33 khall joined #koha
05:37 khall joined #koha
05:42 khall joined #koha
05:44 khall joined #koha
05:44 enkidu joined #koha
05:45 khall joined #koha
05:50 khall joined #koha
05:51 khall joined #koha
05:53 khall joined #koha
05:54 khall joined #koha
05:55 khall joined #koha
06:00 khall joined #koha
06:01 khall joined #koha
06:03 khall joined #koha
06:06 khall joined #koha
06:08 fridolin joined #koha
06:09 khall joined #koha
06:12 khall joined #koha
06:14 khall joined #koha
06:16 reiveune joined #koha
06:17 reiveune hello
06:17 khall joined #koha
06:18 khall joined #koha
06:20 magnuse joined #koha
06:20 khall joined #koha
06:21 khall joined #koha
06:23 khall joined #koha
06:27 khall joined #koha
06:29 khall joined #koha
06:30 did joined #koha
06:31 khall joined #koha
06:32 khall joined #koha
06:34 khall joined #koha
06:36 khall joined #koha
06:38 khall joined #koha
06:40 khall joined #koha
06:40 cait joined #koha
06:42 cait1 joined #koha
06:46 khall joined #koha
06:49 khall joined #koha
06:50 alex_a joined #koha
06:51 alex_a Bonjour
06:51 khall joined #koha
06:52 magnuse \o/
06:52 khall joined #koha
06:55 khall joined #koha
07:02 khall joined #koha
07:05 khall joined #koha
07:06 paul_p joined #koha
07:06 khall joined #koha
07:08 khall joined #koha
07:11 ashimema Good Morning #koha
07:12 khall joined #koha
07:13 khall joined #koha
07:14 matts joined #koha
07:15 khall joined #koha
07:17 khall joined #koha
07:20 khall joined #koha
07:28 magnuse kia ora ashimema
08:00 nlegrand joined #koha
08:00 nlegrand Hey
08:01 ashimema hi nlegrand
08:02 nlegrand o/ ashimema
08:59 severine_q joined #koha
08:59 severine_q Hi #koha !
09:01 nlegrand Salut severine_q.
09:01 Joubu postponing last dev meeting
09:02 severine_q bonjour nlegrand :)
09:02 Joubu #startmeeting Development IRC meeting 24 March 2021
09:02 huginn Meeting started Tue Apr  6 09:02:06 2021 UTC.  The chair is Joubu. Information about MeetBot at
09:02 huginn Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
09:02 Topic for #koha is now  (Meeting topic: Development IRC meeting 24 March 2021)
09:02 huginn The meeting name has been set to 'development_irc_meeting_24_march_2021'
09:02 severine_q et bonjour Joubu  !
09:02 Joubu #info Next meeting: 7 April 2021, 15 UTC
09:02 Joubu #endmeeting
09:02 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software
09:02 huginn Meeting ended Tue Apr  6 09:02:55 2021 UTC.  Information about MeetBot at . (v 0.1.4)
09:02 huginn Minutes:        https://meetings.koha-communit[…]-04-06-09.02.html
09:02 huginn Minutes (text): https://meetings.koha-communit[…]1-04-06-09.02.txt
09:02 huginn Log:            https://meetings.koha-communit[…]06-09.02.log.html
09:02 Joubu tomorrow then
09:03 Joubu and hi #koha :)
09:23 Joubu fridolin: you forgot to adjust the "latest" tar.gz, they are still pointing to 20.11.03
09:28 fridolin Joubu: ah oups i'm on it
09:30 fridolin done
09:36 Joubu thx frido
09:51 ashimema morning
09:53 cait1 oh
09:53 cait1 morning and wb Joubu
09:54 ashimema Hope the move went smoothly Joubu :)
09:55 Joubu still a lot of mess everywhere but it's starting to be livable :)
10:17 khall joined #koha
10:20 cait joined #koha
10:35 thd joined #koha
10:39 thd Welcome back Joubu
10:40 oleonard Hi all
10:40 thd hello oleonard
10:41 thd https://koha-mw-pg-test01.agog[…]om/wiki/Main_Page # 2 week old copy in Postgres
10:41 thd https://koha-mw-my-test01.agog[…]om/wiki/Main_Page # converted to MySQL binary properly
10:42 thd Joubu are you available for a moment?
10:45 Joubu Hi thd, yes I am
10:45 thd https://koha-mw-my-test01.agog[…]om/wiki/Main_Page # converted to MySQL binary properly
10:46 thd that instance can be upgraded to MediaWiki 1.35
10:47 thd I think that it will be easier to mark everything as old_content with a global change and then mark selected things current thus searching with embedded code in the search can distinguish.
10:48 thd Joubu: I am having two problems.
10:49 thd One is that it should be possible to insert NULL into MySQL int columns which have a NULL default.  Am I missing something about NULLs with MySQL int data type?
10:52 thd The other is that this fails with a warning colconv.append( lambda x: ( str( x )[:300] if len( str( x ) ) > 300 else x ) if x else '' ) # truncating for varbinary(300) not NULL
10:52 thd maybe I need to set it for 299
10:54 thd While this works: colconv.append( lambda x: ( str( x )[:254] if len( str( x ) ) > 254 else x ) if x else '' ) # truncating for tinyblob not NULL
10:56 thd Joubu: If you ran[…]l/ without making very many modification you would have had warnings about many columns for which the data was not converted.
10:59 thd Joubu: Any thoughts about inserting NULLs in MySQL int columns?
11:00 thd {some condition} else "NULL" raises a warning
11:02 Joubu yes it's possible to have NULL for integers
11:02 thd I will publish the code I have tomorrow with or without solving those two problems.
11:02 Joubu which warning to you get?
11:02 Joubu do*
11:03 thd A python Warning about incorrect data type.
11:04 thd Maybe I should try {some condition} else "IS NULL"
11:05 thd Joubu I had no warnings in Nov. 2019 when I considered the work nearly finished before COVID etc. happened.
11:06 Joubu I got an error about integers
11:06 Joubu cannot remember which one however
11:06 Joubu I am searching for the patch I wrote
11:06 thd However, I had not tested putting up a live system and I had double quoted everything which was not good.
11:13 thd I had used {condition} else "NULL" for some non-integer columns with no problem
11:15 Joubu I have a 1.16.tables.sql file that I retrieved from their src
11:15 Joubu and a commit that modifies it
11:15 Joubu -  ar_user int unsigned NOT NULL default 0,
11:15 Joubu +  ar_user int unsigned NULL default 0,
11:15 Joubu stuffs like that
11:15 Joubu looks related to your problem
11:16 Joubu do you want me to share the patch?
11:16 thd ... but maybe the else had never been reached for the non-integer columns.
11:16 thd Yes.
11:17 Joubu
11:18 Joubu I generated the 1.16 schema with:
11:18 Joubu git show 50c5cd7c32138237407a6d622598cc​e7a8b951e3:maintenance/tables.sql > 1.16.tables.sql
11:18 thd default 0 is the most common default but some from 1.16 are of the form int(10) DEFAULT NULL
11:18 tcohen morning
11:19 tcohen Joubu welcome back!
11:19 tcohen follow-up on bug 28017
11:19 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=28017 normal, P5 - low, ---, tomascohen, Pushed to master , Allow non-FQDN and IP addresses in emails
11:20 Joubu thx, Tomas!
11:23 thd Joubu: That patch would not change the int(XX) DEFAULT NULL columns which I identified from building 1.16 with my Debian time machine.
11:26 thd Joubu: What it does change is to eliminate some default not NULLs and substitutes default '' or 0 as appropriate for the data type but in a small number of cases.
11:30 Joubu IIRC it fixes the postgres to mysql script. Without the changes the exec crashes with a python error
11:30 Joubu but I didn't note the exact error unfortunately
11:31 Dyrcona joined #koha
11:33 thd Joubu: Yet, the code which you posted seems to be designed to change the SQL structure to be loaded, not the python script itself.
11:33 khall joined #koha
11:34 Joubu yes but I assume the mysql python lib uses the datatype from the DB to validate the data
11:34 thd Yes, exactly
11:35 thd However, I would be concerned that the MediaWiki PHP code would not be expecting your changes.
11:36 Joubu my goal was to migrate the DB to dokuwiki so I didn't care about that
11:37 thd I was very conservative about DB alterations and only extended 4 textual columns to allow for the slightly larger size we have for some legitimate textual data in the Koha wiki.
11:37 thd Whatever we do for the wiki the archive of old stuff should run something current.
11:39 thd I still think it will be less work to manage everything in one wiki as the archive will always need to grow over time and finding old content would merely be a special search.
11:40 thd That is over time we will always be finding that many pages become out of date or loose relevance.
11:41 thd s/loose/lose/
11:43 thd It takes 5 min or so to drop everything and regenerate a working version for testing on my VPS.
11:44 thd Off to drop things and try regenerating with "IS NULL" instead of "NULL" for int data type.
11:47 fridolin left #koha
12:56 khall_ joined #koha
13:01 magnuse if anyone has a hunch about Bug 28094 i'm all ears...
13:01 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=28094 normal, P5 - low, ---, koha-bugs, NEW , Fix bad encoding of OVERRIDE_SYSPREF_LibraryName
13:18 Joubu oleonard: Hi Owen, is that correct to remove "html" for on bug 27974?
13:18 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=27974 enhancement, P5 - low, ---, oleonard, Passed QA , Replace obsolete title-string sorting: Circulation templates
13:20 bdonnahue1 joined #koha
13:38 khall joined #koha
13:38 severine_q joined #koha
14:01 huginn News from kohagit: Bug 28047: (QA follow-up) Fix a few more Callnumber entries <[…]35b4d96ebbba8fb9a>
14:01 huginn News from kohagit: Bug 28066: Remove select tag's size attribute where it is 1 <[…]1e98fb0d2155f003a>
14:01 huginn News from kohagit: Bug 28055: Convert DataTables option names to current version <[…]0763cb20a961f919c>
14:01 huginn News from kohagit: Bug 28066: (QA follow-up) Fix some single quote occurences <[…]c23e29d306de9b542>
14:01 huginn News from kohagit: Bug 28047: Standardize: Call number, callnumber, Call no. etc. <[…]da8e10ca87414315e>
14:01 huginn News from kohagit: Bug 28046: Add "Additional fields" link on acquisition navigation menu <[…]35c821de3a03b1ad3>
14:01 huginn News from kohagit: Bug 28006: Restore "Additional fields" on navigation menu <[…]07cdfcfeef401cd94>
14:01 huginn News from kohagit: Bug 28041: Improve breadcrumbs and headings on label creator pages <[…]2166fca5016effaa8>
14:01 huginn News from kohagit: Bug 28037: Improve breadcrumbs of CSV profiles page <[…]c495abf0b97df7b04>
14:01 huginn News from kohagit: Bug 28036: Improve breadcrumbs of serial claims page <[…]022c4311227af81bd>
14:01 huginn News from kohagit: Bug 28035: Improve breadcrumbs of cataloging search page <[…]1444e595b34766e4d>
14:01 huginn News from kohagit: Bug 28007: (follow-up) Address missing instances <[…]b23c200f593cd2494>
14:01 huginn News from kohagit: Bug 27998: (follow-up) Address missing instances <[…]094a5e828909e7991>
14:01 huginn News from kohagit: Bug 27994: (follow-up) Address missing instance <[…]d47f8a1d3b77bd5bd>
14:01 huginn News from kohagit: Bug 28018: Replace obsolete title-string sorting: OPAC templates <[…]4725cefa4e1719d7d>
14:01 huginn News from kohagit: Bug 28016: Replace obsolete title-string sorting: Assorted templates <[…]32cd3064ed8266890>
14:01 huginn News from kohagit: Bug 28007: Replace obsolete title-string sorting: Tools templates <[…]2bac198353b5f0568>
14:01 huginn News from kohagit: Bug 27998: Replace obsolete title-string sorting: Serials templates <[…]fd50b80b4bca07958>
14:01 huginn News from kohagit: Bug 27994: Replace obsolete title-string sorting: Reports templates <[…]72478f387ce5514a5>
14:01 huginn News from kohagit: Bug 27991: Message field for OPAC problem reporting should have a maxlength set <[…]29c5c9ddd3b01caa5>
14:02 khall_ joined #koha
14:16 hoosierdaddy joined #koha
14:36 koha-jenkins Yippee, build fixed!
14:36 koha-jenkins Project Koha_Master_D9_MDB_Latest build #554: FIXED in 32 min: https://jenkins.koha-community[…]9_MDB_Latest/554/
14:48 fridolin joined #koha
14:53 alex_a joined #koha
15:07 koha-jenkins Yippee, build fixed!
15:07 koha-jenkins Project Koha_Master_D11 build #251: FIXED in 1 hr 6 min: https://jenkins.koha-community[…]a_Master_D11/251/
15:09 koha-jenkins Project Koha_Master_U2010 build #138: STILL UNSTABLE in 1 hr 8 min: https://jenkins.koha-community[…]Master_U2010/138/
15:09 koha-jenkins Yippee, build fixed!
15:09 koha-jenkins Project Koha_Master build #1606: FIXED in 33 min: https://jenkins.koha-community[…]Koha_Master/1606/
15:13 koha-jenkins Yippee, build fixed!
15:13 koha-jenkins Project Koha_Master_D9 build #1606: FIXED in 1 hr 7 min: https://jenkins.koha-community[…]a_Master_D9/1606/
15:13 koha-jenkins Yippee, build fixed!
15:13 koha-jenkins Project Koha_Master_D9_My8 build #537: FIXED in 1 hr 11 min: https://jenkins.koha-community[…]aster_D9_My8/537/
15:19 JesseM joined #koha
15:47 reiveune bye
15:47 reiveune left #koha
15:48 fridolin left #koha
15:52 severine_q bye  "koha !
15:55 pastebot "tcohen" at pasted "Joubu, ashimema" (12 lines) at
15:56 ashimema hmm, seems reasonable tcohen.. will try to wrap my head around the related bug soon
15:57 tcohen oops
15:58 pastebot "tcohen" at pasted "=head3 extended_subfields my $" (40 lines) at
15:58 tcohen I intended to paste it all, not just the POD LOL
16:02 ashimema hehe
16:02 tcohen Joubu thoughts?
16:04 Joubu what's the context?
16:05 tcohen messing with your work on bug 27526
16:05 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=27526 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Remove Mod/AddItemFromMarc from
16:07 tcohen I think it is wrong, as it should be respecting subfield appearance order, right
16:07 tcohen ?
16:08 tcohen you added that feature, right, Joubu?
16:08 Joubu yes, bug 8976
16:08 huginn Bug https://bugs.koha-community.or[…]w_bug.cgi?id=8976 enhancement, P1 - high, ---, jonathan.druart, Pushed to master , Default sequence of subfields in cataloguing editor
16:09 Joubu but I wouldn't care about the order
16:10 tcohen would you accept a polished version of bug 26635? (i.e. having a _authorised_values attribute containing them)
16:10 huginn Bug https://bugs.koha-community.or[…]_bug.cgi?id=26635 enhancement, P5 - low, ---, agustinmoyano, Signed Off , Expand authorised values in REST API call
16:10 Joubu your sub makes sense, to make it clear we don't deal with the order you could return a hashref :D
16:10 tcohen I want it all to fit together
16:10 tcohen shouldn't we care about the order?
16:11 ashimema hum, I could imagine people wanting to care about order
16:11 Joubu I don't know, it depends on how you want to call it
16:11 tcohen that code is missing the av_expand parameter handling
16:13 Joubu I'm afraid my head is full for today, not sure I could help much tonight
16:14 Joubu I don't think I understand what's the question exactly
16:14 Joubu if you are asking me if you can improve something, my answer will always be yes :D
16:14 Joubu (well, almost always)
16:16 koha-jenkins Yippee, build fixed!
16:16 koha-jenkins Project Koha_Master_D10_CPAN build #280: FIXED in 1 hr 7 min: https://jenkins.koha-community[…]ter_D10_CPAN/280/
16:48 cait joined #koha
17:33 enkidu joined #koha
18:04 dbs joined #koha
20:09 magnuse @karma
20:09 huginn magnuse: Highest karma: "Joubu" (965), "cait" (840), and "ashimema" (620).  Lowest karma: "-" (-68), "failed" (-47), and "ie" (-40).  You (magnuse) are ranked 16 out of 1091.
20:59 cait joined #koha
21:06 thd joined #koha
21:12 rangi joined #koha
21:12 rangi hey all, currently upgrading the OS on the linode running bugs (and other stuff) it shouldn't take long
21:13 * cait waves
21:13 cait hi rangi
21:23 logbot joined #koha
21:23 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software
21:28 wahanui joined #koha
21:28 rangi right should be all done
21:32 cait a behind the scenes updaes or new things to discover?
21:34 rangi xenial -> bionic
21:34 rangi so nothing should change
21:34 rangi just xenial is out of support in a couple of months
21:34 cait ok and thanks for updating :)
21:34 cait rangi++
21:46 rangi @later tell magnuse i should be around on irc a little more in the future
21:46 huginn rangi: The operation succeeded.
21:47 oleonard rangi++
23:06 khall joined #koha
23:14 cait joined #koha

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