Time Nick Message
00:25 oleonard-away Wainui: You can upload tool plugins via the Admin page can't you?
00:26 oleonard-away Yeah. I think the assumption is that only admins should be installing plugins anyway.
00:26 * oleonard-away really away
02:58 * dcook waves
02:59 dcook Bugzilla broken for anyone else or just me? heh
03:00 dcook rangi: Just sending you an email now about my account being locked out
04:47 * dcook blinks
06:17 reiveune hello
06:51 alex_a Bonjour
06:52 magnuse \o/
07:11 ashimema Good Morning #koha
07:28 magnuse kia ora ashimema
08:00 nlegrand Hey
08:01 ashimema hi nlegrand
08:02 nlegrand o/ ashimema
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 http://wiki.debian.org/MeetBot.
09:02 huginn Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
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 huginn Meeting ended Tue Apr 6 09:02:55 2021 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)
09:02 huginn Minutes: https://meetings.koha-community.org/2021/development_irc_meeting_24_march_2021.2021-04-06-09.02.html
09:02 huginn Minutes (text): https://meetings.koha-community.org/2021/development_irc_meeting_24_march_2021.2021-04-06-09.02.txt
09:02 huginn Log: https://meetings.koha-community.org/2021/development_irc_meeting_24_march_2021.2021-04-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:39 thd Welcome back Joubu
10:40 oleonard Hi all
10:40 thd hello oleonard
10:41 thd https://koha-mw-pg-test01.agogme.com/wiki/Main_Page # 2 week old copy in Postgres
10:41 thd https://koha-mw-my-test01.agogme.com/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.agogme.com/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 http://www.winterrodeln.org/trac/browser/servermediawiki/trunk/pgsqltomysql/pgsqltomysql.py 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 http://paste.koha-community.org/217
11:18 Joubu I generated the 1.16 schema with:
11:18 Joubu git show 50c5cd7c32138237407a6d622598cce7a8b951e3: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.org/bugzilla3/show_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: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: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.
13:01 magnuse if anyone has a hunch about Bug 28094 i'm all ears...
13:01 huginn Bug https://bugs.koha-community.org/bugzilla3/show_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-site_checkouts.tt on bug 27974?
13:18 huginn Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27974 enhancement, P5 - low, ---, oleonard, Passed QA , Replace obsolete title-string sorting: Circulation templates
14:01 huginn News from kohagit: Bug 28047: (QA follow-up) Fix a few more Callnumber entries <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=fd42e891862861d1d79629635b4d96ebbba8fb9a>
14:01 huginn News from kohagit: Bug 28066: Remove select tag's size attribute where it is 1 <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=58446226657c6dd32e15c7e1e98fb0d2155f003a>
14:01 huginn News from kohagit: Bug 28055: Convert DataTables option names to current version <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=627897857cd493324ae875e0763cb20a961f919c>
14:01 huginn News from kohagit: Bug 28066: (QA follow-up) Fix some single quote occurences <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f50897bd2539cd27412f680c23e29d306de9b542>
14:01 huginn News from kohagit: Bug 28047: Standardize: Call number, callnumber, Call no. etc. <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=7b33ad0bd4f32276b761620da8e10ca87414315e>
14:01 huginn News from kohagit: Bug 28046: Add "Additional fields" link on acquisition navigation menu <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b258a0684473da3f04c3b0835c821de3a03b1ad3>
14:01 huginn News from kohagit: Bug 28006: Restore "Additional fields" on navigation menu <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9fae22c77efa15ced2dc05c07cdfcfeef401cd94>
14:01 huginn News from kohagit: Bug 28041: Improve breadcrumbs and headings on label creator pages <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8a3392bbbe16f50a9f6e42d2166fca5016effaa8>
14:01 huginn News from kohagit: Bug 28037: Improve breadcrumbs of CSV profiles page <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=18bbf42b33cc1872bd9fea5c495abf0b97df7b04>
14:01 huginn News from kohagit: Bug 28036: Improve breadcrumbs of serial claims page <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=1fc05de2ef183541abbeb5b022c4311227af81bd>
14:01 huginn News from kohagit: Bug 28035: Improve breadcrumbs of cataloging search page <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=dc13552ddc2dc548bfeedf31444e595b34766e4d>
14:01 huginn News from kohagit: Bug 28007: (follow-up) Address missing instances <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c96821861be4692487278aeb23c200f593cd2494>
14:01 huginn News from kohagit: Bug 27998: (follow-up) Address missing instances <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=769556b42a8ad2aadf89318094a5e828909e7991>
14:01 huginn News from kohagit: Bug 27994: (follow-up) Address missing instance <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e0c2ee57adbfe729dc7779fd47f8a1d3b77bd5bd>
14:01 huginn News from kohagit: Bug 28018: Replace obsolete title-string sorting: OPAC templates <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=da2d583591b0896367b81374725cefa4e1719d7d>
14:01 huginn News from kohagit: Bug 28016: Replace obsolete title-string sorting: Assorted templates <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=565591f649835da69d7f05032cd3064ed8266890>
14:01 huginn News from kohagit: Bug 28007: Replace obsolete title-string sorting: Tools templates <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=78d504eb06c326e14c8a2202bac198353b5f0568>
14:01 huginn News from kohagit: Bug 27998: Replace obsolete title-string sorting: Serials templates <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e44b187b4720bb419c00e8afd50b80b4bca07958>
14:01 huginn News from kohagit: Bug 27994: Replace obsolete title-string sorting: Reports templates <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=67a60c24a3e42980d62ba3272478f387ce5514a5>
14:01 huginn News from kohagit: Bug 27991: Message field for OPAC problem reporting should have a maxlength set <https://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8bb9cb649bf36a650d3b84c29c5c9ddd3b01caa5>
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.org/job/Koha_Master_D9_MDB_Latest/554/
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.org/job/Koha_Master_D11/251/
15:09 koha-jenkins Project Koha_Master_U2010 build #138: STILL UNSTABLE in 1 hr 8 min: https://jenkins.koha-community.org/job/Koha_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.org/job/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.org/job/Koha_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.org/job/Koha_Master_D9_My8/537/
15:47 reiveune bye
15:52 severine_q bye "koha !
15:55 pastebot "tcohen" at 127.0.0.1 pasted "Joubu, ashimema" (12 lines) at http://paste.koha-community.org/224
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 127.0.0.1 pasted "=head3 extended_subfields my $" (40 lines) at http://paste.koha-community.org/225
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.org/bugzilla3/show_bug.cgi?id=27526 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Remove Mod/AddItemFromMarc from additem.pl
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.org/bugzilla3/show_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.org/bugzilla3/show_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.org/job/Koha_Master_D10_CPAN/280/
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.
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: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++