Time Nick Message 00:00 CrispyBran Good night all! 00:00 jac good night 00:00 wahanui Don't go, jac. Stay a while. Stay forever. 00:00 * liz snickers at creepy wahanui 00:00 jac Sorry got to go goodnight! 00:01 eythian liz: https://youtu.be/VN2pSPZFHqA 00:02 liz oooh 00:02 * liz subscribes 00:03 liz I have to wait to watch that >.< 00:03 liz but it is in my watch later! (which means in like, 2 hours) 00:07 eythian Check out the cars and the hair. 00:07 eythian Also the Wellington. 00:10 liz <3 <3 00:39 martian523 mtj, i just searched for a vendor 00:39 martian523 and it came back with the error 00:50 mtj martian523: anything interestng in yr koha/apache logs? 00:51 mtj ..search works ok with '%' value? 00:51 martian523 what do mean by interesting? 00:52 mtj odd, unusual 00:53 martian523 gives back the same error even if i don't put anything there and just press submit 00:54 mtj hmm, weird :( 00:55 mtj hm, i wonder if there is a problematic row in the vendors table 00:56 martian523 problematic row.... 00:56 martian523 it worked fine before the upgrade 00:57 martian523 i upgraded from 3.18 00:58 mtj on your test system, delete all vendors, then add a new one - problem solved? 00:59 mtj if not, then compare the 'vendors' table structure to a fresh 16.5.7 00:59 martian523 i can try...but does that mean all my past orders are gone? 01:00 mtj sure... so, only on your *test* system 01:00 mtj not prod 01:01 mtj oops, sorry i misread... ^ i'm not sure if yr orders will be gone (not tested myself) 01:01 liz martian523: is there anything in the javascript console? 01:02 liz I must have missed what the error actually is 01:02 mtj ". using koha 16.05.07. this error came up when i tried to look up vendors in acquisitions: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054" 01:02 mtj hi liz ^ fyi 01:02 liz yay ty 01:02 liz this happens when searching for any vendor or a specific one? 01:03 martian523 any 01:04 martian523 o, so this is a problem? 01:06 pastebot "mtj" at 127.0.0.1 pasted "describe aqbooksellers;" (33 lines) at http://paste.koha-community.org/274 01:07 mtj martian523: does your table look like that? ^ 01:07 martian523 sorry, where do i find this? 01:07 martian523 not an IT expert 01:08 mtj a command.. from the mysql shell 01:08 martian523 hold on 01:08 liz I uh 01:08 liz did you all know that if you have the "send patron registration information" stuff on 01:08 liz that it sends passwords via email 01:10 liz http://paste.koha-community.org/275 01:12 mtj liz: good to know, ta 01:21 * liz finds that slightly frightening 01:21 martian mtj got my IT here. can you explain how to get to mysql ? 01:23 liz do you have a command line? 01:23 liz and sudo access (or root) 01:23 liz on the Koha server 01:24 liz martian ^ 01:25 martian sorry, not catching it 01:25 martian what command line? 01:25 liz do you have access to the command line on the Koha server 01:26 martian yes 01:26 liz cool, are you logged in with a user that can sudo? 01:26 martian what's the command to get into the mysql shell 01:26 martian yes 01:26 liz cool 01:26 liz you can do 01:26 liz sudo koha-mysql <whatever the name of your instance is> 01:26 liz you can see what you have got 01:26 liz by doing sudo koha-list --enabled 01:27 martian tried 01:27 liz "see what you have got" means "see what instances you have currently running on your server" 01:27 liz just to get the instance name 01:28 martian when put in mysql> descibe aqbooksellers, command failed 01:29 martian koha-mysql "describe aqbooksellers;" 01:29 liz show tables; 01:29 liz no no 01:30 liz so you did 01:30 liz sudo koha-mysql <instance> 01:30 liz and then describe aqbooksellers; 01:30 liz and it said "command failed" 01:30 liz what was the exact error message 01:32 martian what is <instance> 01:34 martian basically, how to get into mysql shell ? 01:48 mtj 'instance' in the name of your specific koha 01:48 mtj sudo koha-list --enabled 01:48 mtj ^ .. shows you all instances 01:58 liz so for example 01:59 liz if I had done koha-create --create-db mylibrary 01:59 liz mylibrary is my instance name 01:59 liz koha-list --enabled would show me mylibrary 01:59 liz to get into the shell, I'd type "sudo koha-shell mylibrary" 02:00 liz oh also those password containing emails are sent even when email is disabled 06:56 * magnuzzz waves 06:57 magnuse @wunder enbo 06:57 huginn magnuse: The current temperature in Bodo, Norway is 8.0°C (7:20 AM CET on January 25, 2017). Conditions: Rain. Humidity: 87%. Dew Point: 6.0°C. Windchill: 2.0°C. Pressure: 29.42 in 996 hPa (Steady). 06:57 magnuse @wunder konstanz 06:57 huginn magnuse: The current temperature in Mainaustraße, Konstanz, Germany is -6.2°C (7:50 AM CET on January 25, 2017). Conditions: Overcast. Humidity: 82%. Dew Point: -9.0°C. Windchill: -6.0°C. Pressure: 30.30 in 1026 hPa (Steady). 06:57 magnuse @wunder amsterdam, netherlands 06:57 huginn magnuse: The current temperature in Amsterdam, Netherlands is -1.0°C (7:25 AM CET on January 25, 2017). Conditions: Overcast. Humidity: 100%. Dew Point: -1.0°C. Windchill: -4.0°C. Pressure: 30.45 in 1031 hPa (Steady). 06:57 magnuse @wunder marseille 06:57 huginn magnuse: Error: No such location could be found. 06:58 magnuse @wunder marseille, france 06:58 huginn magnuse: The current temperature in Marseille, France is 0.0°C (7:30 AM CET on January 25, 2017). Conditions: Clear. Humidity: 69%. Dew Point: -5.0°C. Windchill: -4.0°C. Pressure: 30.12 in 1020 hPa (Steady). 06:58 magnuse mohahahaha 06:59 bag magnuse: HI 06:59 wahanui hey, bag 06:59 magnuse bag: HI 06:59 wahanui salut, magnuse 06:59 bag @wunder pdx 06:59 huginn bag: The current temperature in Portland, Oregon is 2.0°C (10:53 PM PST on January 24, 2017). Conditions: Overcast. Humidity: 96%. Dew Point: 1.0°C. Pressure: 30.23 in 1024 hPa (Rising). Winter Weather Advisory in effect until 1 PM PST Wednesday... 06:59 magnuse mohahahaha 06:59 bag hmm magnuse you going to hackfest? 07:00 magnuse i don't think so 07:00 magnuse sadly 07:00 bag oh bummer 07:00 magnuse it's a question of time 07:00 bag time is always in the past 07:00 magnuse and i have a hunch there will be lots of other traveling this year 07:01 bag but how can I enjoy the view without you? 07:01 magnuse hehe. i won't be in your way, so you will have a clearer view ;-) 07:02 magnuse i am not 100% decided yet, but "probably not" must be my answer 07:02 bag it’s always about perspective - I being short - create a different one for you ;) 07:02 bag you can not see the things that I see at my level ;) 07:03 magnuse that is true 07:03 bag so therefore you should attend - to have that shorter perspective in your life - it’s called balance 07:04 bag sold - correct? therefore we will see magnuse in marseille 07:04 bag :D 07:04 magnuse :-) 07:04 magnuse balance does sound good 07:04 bag [off] TP calls that logic 07:05 bag sorry so lame 07:05 bag bag-- 07:05 huginn bag: Error: You're not allowed to adjust your own karma. 07:05 magnuse nah, nice try! 07:05 bag ah it wouldn’t be a hackfest without you 07:05 bag anyways magnuse - what’s the view like now? 07:06 bag LibraryClaire: hi there 07:06 magnuse utterly dark 07:06 LibraryClaire hey bag 07:06 bag I got plantar fasciitas 07:06 bag bummer 07:06 LibraryClaire aaaargh 07:06 LibraryClaire ouch 07:06 magnuse guten morgen BüchereiKlara 07:06 LibraryClaire hei magnuse 07:06 magnuse \o/ 07:06 LibraryClaire bag: I have hip bursitis 07:07 bag SHIT 07:07 LibraryClaire marathons are bad for you 07:07 bag [off] crude american 07:07 bag I’ve already signed up for two 07:08 LibraryClaire how bad is the fasciitis? 07:08 * magnuse thought bag meant some kind of fajitas 07:08 LibraryClaire mine once tensed up so much I couldn't walk on it, but luckily sports therapist sorted it in a session and it healed quickly 07:08 bag I’ve had it for awhile - but I didn’t know - I just webmd’d it - so …. 07:08 LibraryClaire yeah, lots of stretching 07:08 bag I have a PT appointment next week 07:09 bag every morning when I get out of bed I can barely walk - I just thought - yeah that’s what runners do 07:09 bag little did I know - I should have done something 07:09 LibraryClaire hmm 07:09 LibraryClaire like, heel under the foot or back of leg? 07:10 bag the good thing I think - is that with it - after you run a few miles - it lossens up 07:10 bag arches and heels hurt like hell 07:10 LibraryClaire cos, I had the same when I tore my achilles- it always hurts in the morning and eases off in the day 07:10 LibraryClaire ok yeah thats less the achilles 07:10 LibraryClaire but I think stretching calves and achilles are helpful for the plantar fascia too 07:11 bag yup 07:12 bag aloha cait 07:12 * cait waves 07:14 * LibraryClaire waves 07:14 * LibraryClaire goes to make tea 07:16 * LibraryClaire forgot the tea bag... tries again 07:16 bag I am not a tea bag 07:20 josef_moravec morning #koha 07:21 cait heh 07:22 * LibraryClaire has tea 07:23 LibraryClaire hi josef_moravec 07:23 bag you don’t have bag though LibraryClaire 07:23 josef_moravec Hi TeaClaire ;) 07:24 * magnuse thinks fast walking is the sensible thing 07:26 bag alright night night all 07:26 bag time for me to fast walk 07:27 LibraryClaire night bag :) take it easy! 07:27 LibraryClaire @wunder konstanz 07:27 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -6.3°C (8:24 AM CET on January 25, 2017). Conditions: Overcast. Humidity: 82%. Dew Point: -9.0°C. Windchill: -6.0°C. Pressure: 30.30 in 1026 hPa (Steady). 07:28 cait ew 07:28 cait i don't want to get out there :( 07:28 LibraryClaire yeah, that explains why cycling sucked this morning 07:28 cait can you send work here? 07:28 LibraryClaire i'm not going out there again 07:34 reiveune hello 07:36 wahanui hey, reiveune 07:38 Joubu hi #koha 07:40 LibraryClaire hi reiveune 07:40 LibraryClaire bonjour Joubu 07:40 reiveune \o_ 07:40 LibraryClaire o/ 07:51 magnuse @wunder enbo 07:51 huginn magnuse: The current temperature in Bodo, Norway is 8.0°C (8:20 AM CET on January 25, 2017). Conditions: Rain. Humidity: 87%. Dew Point: 6.0°C. Windchill: 2.0°C. Pressure: 29.42 in 996 hPa (Steady). 07:51 magnuse @wunder marseille, france 07:51 huginn magnuse: The current temperature in Marseille, France is 0.0°C (8:30 AM CET on January 25, 2017). Conditions: Mostly Cloudy. Humidity: 69%. Dew Point: -5.0°C. Windchill: -3.0°C. Pressure: 30.15 in 1021 hPa (Steady). 07:51 * magnuse will do that a few times today 07:55 alex_a bonjour 07:56 LibraryClaire salut alex_a 08:09 fridolin hei 08:10 LibraryClaire salut fridolin 08:12 Joubu josef_moravec: ho you beat me for 2min 08:13 josef_moravec Joubu: ;) 08:13 Joubu I was resending the message I sent yesterday, but was pending for approval 08:13 josef_moravec Joubu: but do you think the comment is entirely true? 08:13 Joubu yes I think it is 08:14 josef_moravec Yes, I know, that when you empty InnoDB table, it does not unallocate space 08:15 josef_moravec but when you insert some new data, the it uses the emptied space... 08:16 josef_moravec so growing just up to maximum of data it ever has... 08:18 josef_moravec I think the bigger problem with space is in table action_logs for example... 08:18 josef_moravec but yes, action_logs is newer full emptied 08:18 josef_moravec usually ;) 08:22 Joubu josef_moravec: there is nothing on the bug 5877 08:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5877 enhancement, P1 - high, ---, paul.poulain, CLOSED FIXED, Offline circulation improvements : upload all files, apply at once 08:23 Joubu paul_p__: right in time :) 08:23 Joubu paul_p__: +-- Table structure for table `pending_offline_operations` 08:23 Joubu +-- 08:23 Joubu +-- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied... 08:23 Joubu +-- so MyISAM is better in this case 08:24 Joubu do you know if this is still valid? 08:24 paul_p__ Joubu hello. 08:25 paul_p__ what is valid ? the reason to have myISAM instead of InnoDB ? I think yes, innoDB volumes are still only growing. That's due to innoDB internals (and not considered as a bug) 08:26 Joubu paul_p__: yes but as josef_moravec previously said: "when you insert some new data, the it uses the emptied space, so growing just up to maximum of data it ever has" 08:26 paul_p__ Joubu & josef_moravec= a link about that ? That was not my understanding. 08:32 Joubu I do not find anything to confirm your or josef_moravec assertion 08:33 Joubu but it must be easy to test, just fill the table, check size of the mysql index, empty the table, refill it 08:34 Joubu if it's the same size, we could go with innodb 08:34 ashimema I recall hearing somewhere that calling OPTIMISE on innodb tables can reclaim the space 08:35 ashimema ah, you need innodb_file_per_table to be enabled for that to work 08:36 ashimema https://dev.mysql.com/doc/refman/5.5/en/innodb-truncate-table-reclaim-space.html for example 08:37 ashimema http://stackoverflow.com/questions/1270944/mysql-innodb-not-releasing-disk-space-after-deleting-data-rows-from-table is helpful too 08:38 ashimema I have no idea if we have any control over setting that file_per_table setting or not 08:39 josef_moravec There is bug in Mysql for that... http://bugs.mysql.com/bug.php?id=1341 08:39 josef_moravec I have no better evidence on the internet for this... 08:40 Joubu ok, so you need innodb_file_per_table, but everybody should use innodb_file_per_table :) 08:40 josef_moravec but on one of my servers, where innodb_file_per_table is not set, the action_logs table once growed up too much - few gigs of data 08:41 ashimema indeed.. action_logs has caught us a few times 08:41 ashimema it can grow very fast 08:41 ashimema so yeah.. Joubu, I agree everybody should use file_per_table 08:42 josef_moravec mysql alocated filespace, and when i cleared the action_logs table, the space wasn't unallocated, but adding more data to other tables does not make the allocated space bigger 08:42 ashimema and perhaps we should switch to innodb for that table and if we're going belt and braces add a maintanence script that runs optimise over tables? 08:46 josef_moravec And so I has now 18GB of "free space" in mysql tablespace: http://www.s3blog.org/screengrab/images.html?id=e3af1f7dab6abe01ff784fd7bf832a58 08:46 josef_moravec ;) 08:46 ashimema lol 08:47 ashimema I believe you can dump and reload to reclaim it 08:47 ashimema but that obviously entails downtime 08:47 josef_moravec ashimema: yes, that's the plan ;) 08:48 ashimema I presume your not running file_per_table josef ? 08:48 josef_moravec ashimema: that's no problem, not production ;) 08:48 ashimema I'd be interested to see if optimize does work ;) 08:48 josef_moravec ashimema: no, this server does not have set file_per_table 08:48 josef_moravec without innodb_file_per_table no 08:49 ashimema k 08:53 josef_moravec optimize schrinks down the table size, but does not unallocate filespace 09:15 eythian hi 09:15 wahanui hello, eythian 09:15 eythian @wunder ams 09:15 huginn eythian: The current temperature in Schiphol, Badhoevedorp, Netherlands is -0.8°C (10:10 AM CET on January 25, 2017). Conditions: Mist. Humidity: 95%. Dew Point: -2.0°C. Windchill: -1.0°C. Pressure: 30.47 in 1032 hPa (Rising). 09:16 eythian @wunder jordaan, amsterdam 09:16 huginn eythian: The current temperature in Geuzenbuurt Amsterdam, Amsterdam, Netherlands is 0.1°C (10:15 AM CET on January 25, 2017). Conditions: Mist. Humidity: 89%. Dew Point: -2.0°C. Windchill: 0.0°C. Pressure: 30.47 in 1032 hPa (Rising). 09:25 LibraryClaire @wunder konstanz 09:25 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -5.7°C (10:21 AM CET on January 25, 2017). Conditions: Overcast. Humidity: 81%. Dew Point: -8.0°C. Windchill: -6.0°C. Pressure: 30.30 in 1026 hPa (Steady). 09:25 LibraryClaire nope 09:32 magnuse @wunder enbo 09:32 huginn magnuse: The current temperature in Bodo, Norway is 8.0°C (10:20 AM CET on January 25, 2017). Conditions: Rain. Humidity: 93%. Dew Point: 7.0°C. Windchill: 2.0°C. Pressure: 29.42 in 996 hPa (Steady). 09:32 magnuse \o/ 10:26 Joubu marcelr? 10:26 wahanui well, marcelr is talking with tcohen about it 10:39 drojf hi #koha 11:02 drojf @wunder berlin, germany 11:02 huginn drojf: The current temperature in Berlin, Berlin, Germany is 0.2°C (11:59 AM CET on January 25, 2017). Conditions: Overcast. Humidity: 99%. Dew Point: 0.0°C. Windchill: 0.0°C. Pressure: 30.48 in 1032 hPa (Steady). 11:03 drojf why am i the only one here? did i miss an invitation to the new place? 11:08 Joubu drojf: ! 11:09 drojf hi Joubu 11:09 * drojf feels less lonely 11:09 Joubu I did not get the invitation either 11:10 drojf heh 11:12 tcohen morning 11:13 tcohen @wunder cordoba, argentina 11:13 huginn tcohen: The current temperature in Cordoba, Argentina is 16.0°C (8:00 AM ART on January 25, 2017). Conditions: Scattered Clouds. Humidity: 88%. Dew Point: 14.0°C. Pressure: 30.06 in 1018 hPa (Rising). 11:24 LibraryClaire everywhere is warmer than here 11:28 rsantellan good morning 11:28 wahanui well, it's morning somewhere, yes 11:38 magnuse @wunder enbo 11:38 huginn magnuse: The current temperature in Bodo, Norway is 8.0°C (12:20 PM CET on January 25, 2017). Conditions: Rain. Humidity: 100%. Dew Point: 8.0°C. Windchill: 2.0°C. Pressure: 29.42 in 996 hPa (Steady). 11:38 magnuse hm meeting today? 11:39 magnuse in 1 hour 20 minutes https://wiki.koha-community.org/wiki/Development_IRC_meeting_25_January_2017 11:41 magnuse it's the final countdown: https://www.timeanddate.com/countdown/generic?p0=1440&iso=20170125T13&msg=Koha%20Developers%20IRC%20Meeting 11:55 tcohen 1H5min 11:55 tcohen ? 11:56 tcohen magnuse: hadn't seen the countdown, cool! 11:57 magnuse soo, the final countdown from europe, eh? 12:05 * tcohen still has the LP 12:07 Joubu Lonely Planet? 12:07 Joubu Low profile? 12:07 Joubu Low power? 12:08 Joubu hum, urban dictionnary has weird def for LP 12:09 magnuse tcohen: i had it on MC i think 12:09 tcohen vinyl 12:10 magnuse Joubu: Labour Party 12:10 tcohen Lonely person 12:11 magnuse they were a gateway drug to harder and better stuff, so i guess i should be grateful 12:18 tcohen the grateful dead 12:18 tcohen ha, is mtompet around? he's a specialist on musical flashbacks 12:20 magnuse @seen mtompset 12:20 huginn magnuse: mtompset was last seen in #koha 1 day, 7 hours, 38 minutes, and 52 seconds ago: <mtompset> Have a great day (24 hour period), #koha dcook 12:30 * tcohen1 hates his internet connexion 12:33 marcelr hi #koha 12:33 magnuse hiya marcelr 12:33 marcelr :) 12:38 LibraryClaire hi marcelr 12:38 marcelr hello LibraryClaire 12:40 * cait waves 12:43 marcelr hi cait 12:43 marcelr Joubu++ #bug 17990 12:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17990 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Code to check perl module versions is buggy 12:44 cait hi marcelr, Joubu 12:46 marcelr easy signoff ? bug 17982 ! 12:46 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17982 minor, P5 - low, ---, m.de.rooy, Needs Signoff , Fix the use of uniq in sub themelanguage 12:55 magnuse druthb! 12:55 wahanui She's really more trouble than she's worth, you know? 12:55 magnuse lulz 12:55 magnuse meeting in 5! 12:55 druthb magnuse! 12:55 wahanui rumour has it magnuse is a Norwegian giant 12:56 oleonard Hi all 12:57 magnuse hiya oleopard 12:57 LibraryClaire hi oleonard 12:57 wahanui hi olé onard 12:58 josef_moravec_ hi oleonard 12:58 wahanui hi oleopard 12:58 * oleonard tries to Jedi-mind-trick someone into signing off on Bug 17942 12:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17942 enhancement, P5 - low, ---, oleonard, Needs Signoff , Update style of the web installer with Bootstrap 3 13:01 jajm hi #koha 13:01 marcelr hi jajm 13:02 cait hi all 13:02 josef_moravec_ oleonard: i'd like to, when time permits... 13:03 marcelr josef_moravec_++ 13:03 kidclamp morning 13:03 tcohen morning, kidclamp 13:03 marcelr hi kidclamp 13:03 marcelr and tcohen 13:05 ashimema hola' 13:05 kidclamp hi ashimema marcelr et al. 13:06 tcohen #startmeeting Development IRC meeting 25 January 2017 13:06 huginn Meeting started Wed Jan 25 13:06:05 2017 UTC. The chair is tcohen. Information about MeetBot at http://wiki.debian.org/MeetBot. 13:06 huginn Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. 13:06 huginn The meeting name has been set to 'development_irc_meeting_25_january_2017' 13:06 marcelr #info Marcel de Rooy, Rijksmuseum, Netherlands 13:06 tcohen hi everyone, please introduce yourselves with #info 13:06 magnuse #info Magnus Enger, Libriotech, Norway 13:06 tcohen #info Tomás Cohen Arazi, Theke Solutions 13:06 cait #info Katrin Fischer, BSZ, Germany 13:06 jajm #info Julian Maurice, BibLibre, France 13:06 LibraryClaire #info Claire Gravely, BSZ, Germany 13:06 rsantellan #info Rodrigo Santellan, ORT, Uruguay 13:06 oleonard #info Owen Leonard, Athens County Public Libraries, USA 13:07 kidclamp #info Nick Clemens, ByWater Solutions 13:07 josef_moravec_ #info Josef Moravec, Municipal Library Usti nad ORlici 13:08 Joubu #info Jonathan Druart, France 13:08 tcohen #koha, please introduce yourselves 13:08 tcohen #topic Announcements 13:09 tcohen Any announcements? 13:09 tcohen druthb: announcements? 13:09 wahanui announcements are often automatic 13:10 magnuse the rdf mailing list, perhaps` 13:10 tcohen magnuse: go ahead 13:10 Joubu [off] I will move to Argentina in about 1 month, hopefully 13:10 Joubu [off] but keep it off :p 13:10 cait [off] woohoo 13:10 oleonard [off] !!! 13:10 ashimema #info Martin Renvoize, PTFS-Europe 13:10 LibraryClaire [off] :O 13:11 marcelr [off] working on Koha? 13:11 magnuse bywater has created a mailing list for people who are interested in adding support for rdf/linked data/semantic web techniques to koha 13:11 tcohen [off] That's quite an announcement Joubu 13:11 druthb [off] I'm getting married on March 4. :) 13:11 cait [off] congratulations :) 13:11 tcohen [off] :) 13:11 ashimema want to link that magnuse? 13:11 marcelr [off] :) 13:11 Joubu [off] just following my girlfriend, she got her funding for a 2 years position research 13:11 josef_moravec_ [off] congatulations to all ;) 13:11 ashimema [off] congrats druthb 13:12 ashimema [off] enjoy Joubu 13:12 magnuse don't know if there is a public page for signing up to the list, but get in touch with bag or khall or others at bywater and they can propbably add you 13:12 Joubu [off] nothing will change for my Koha-related job 13:12 marcelr [off] good 13:12 cait [off] congrats to K. for getting the funding :) 13:12 magnuse [off] hooray for druthb and Joubu! 13:12 ashimema [off] apart from your online hours Joubu ;) 13:13 Joubu [off] hehe yes indeed :) 13:13 tcohen #info ByWater has created an mailing list for people interested in adding support for rdf/linked data/semantic web techniques to koha 13:13 ashimema [off] lots of [off] and not much [on] 13:13 kidclamp [off]congrats to all! 13:13 Joubu [on] tcohen will can move on ;) 13:13 oleonard Do we have an agenda link? 13:13 tcohen #info Lots of off-the-record announcements, for more information ask Joubu and druthb 13:13 Joubu https://wiki.koha-community.org/wiki/Development_IRC_meeting_25_January_2017 13:13 cait #link https://wiki.koha-community.org/wiki/Development_IRC_meeting_25_January_2017 agenda 13:14 tcohen ok, moving on 13:14 tcohen #topic Update from the Release manager 13:14 magnuse (the list is very low traffic, so far) 13:14 tcohen khall? bag? 13:15 * ashimema wonders if we missed the POD discussion 13:15 marcelr see agenda 13:15 tcohen ashimema: i preferred to have the announcements dirst 13:15 tcohen first 13:15 tcohen it is too early for bag 13:15 kidclamp or khall 13:16 tcohen and khall seems offline 13:16 tcohen so, moving on 13:16 magnuse lazy people ;-) 13:16 tcohen #topic Updates from the Release Maintainers 13:16 cait #info 16.11.2 was released on 22nd 13:17 ashimema cait++ 13:17 cait the plan is to keep with the schedule - i hope it will always work out :) 13:17 marcelr cait++ 13:17 tcohen cait++ 13:17 cait packages have been made available the next day this time - drojf++! 13:17 jajm #info 3.22.15 was released on 23rd 13:17 ashimema drojf++ 13:17 cait and bgkriegel++ for sending me the po files on short notice too 13:17 tcohen awesome 13:17 ashimema jajm++ 13:17 cait In some cases I asked for feedback or people spoke up that they'd like to have something included 13:18 cait I will try to review those the next week latest and see what I can do for the next release 13:18 cait have some patience, I have a list for those :) 13:18 marcelr great 13:18 Joubu Something about 3.22.x 13:18 tcohen cait: is there a list of outstanding bugs for the stability of 16.11? 13:18 cait jajm++ 13:18 Joubu it seems that it's buggy since 3.22.14 13:18 Joubu see bug 17943 13:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17943 critical, P2, ---, gmcharlt, NEW , "make test" failed when upgrading from koha-3.22.10 to 3-22.14 , also fresh installation of koha-3.22.14 made the same "make test" failing 13:18 cait right now I think my first list is done with - the one that Joubu had sent 13:18 Joubu mught be a critical one 13:19 jajm Joubu, yep, I just saw that, i will take a look asap 13:19 cait i think there might still be some bugs in holds - I haven't reviewed them yet 13:19 tcohen jajm++ 13:19 tcohen cait: thanks 13:20 tcohen #info Katrin says there can be some minor bugs on holds, but 16.11 is stable enough 13:20 tcohen mtj: around? 13:20 cait didn't say minor 13:20 cait might be havier ones 13:21 tcohen #info holds bugs in 16.11 can be totally not-minor 13:21 tcohen :D 13:21 cait heh 13:22 magnuse cait: bug 17940 might be worth a look 13:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17940 major, P5 - low, ---, koha-bugs, NEW , Holds not going to waiting state after having been transferred 13:22 tcohen cait: I'm sure you will make us note those bugs 13:22 tcohen ok, moving on 13:23 tcohen #topic Review of coding guidelines / New POD guidelines 13:23 tcohen kidclamp: your turn 13:23 kidclamp okay 13:24 * oleonard has a coding guideline item after kidclamp 13:24 kidclamp I sent out an email - got two responses, I think we can go ahead with enforcing the current rule about POD and adding that it should be inline 13:25 tcohen kidclamp: no objections so far? 13:25 marcelr and you already got responses on last meeting 13:25 kidclamp heh, there was more discussion at the meetings :-) 13:25 jajm ++ for inline POD 13:25 marcelr i go for required, inline 13:25 ashimema ++ for inline POD 13:25 josef_moravec_ ++ inline 13:26 tcohen any objections? if there are, we should vote 13:26 kidclamp so I say add to guideline: When updating a module lacking POD please add coverage for existing subroutines. All POD should be inline with subroutines 13:26 cait already voted on ml - inline and required :) 13:26 kidclamp lets vote 13:26 kidclamp heh 13:26 cait do you have to do all? or just the ones you use? 13:26 cait use/change? 13:26 marcelr only what you change 13:26 magnuse yeah 13:26 kidclamp I think all is encouraged, what you change is required 13:27 tcohen yeah, only what you change is required 13:27 tcohen yeah 13:28 marcelr you probably wont like rebasing them when we change all 13:28 kidclamp When updating a module you are required to add POD for existing subroutines, it is encouraged to add POD to all subroutines as possible 13:28 kidclamp heh - true, but full coverage would be nice 13:28 cait hm existing and all seems the same 13:29 cait for changed/added? 13:29 ashimema full coverage would be lovely.. but enforcing someone to go back and write pod for each routine when they've done a 1 character change to one routine is a bit rough ;) 13:29 magnuse yup 13:29 marcelr existing should be modified 13:29 cait When updating a module you are required to add POD for added and changed subroutines, it is encouraged to add POD to all subroutines as possible 13:29 tcohen ashimema: the QA team is good when negotiating 13:29 kidclamp I think QA judgement calls are okay 13:29 marcelr QA++ 13:29 ashimema I'd say.. ensure POD is accurate and correct for the routines you are altering as the rule 13:30 ashimema true 13:30 ashimema I'd love to see some pod only bugs coming in too ;) 13:30 kidclamp barton volunteered to do some work there 13:30 tcohen barton 13:30 ashimema awesome 13:30 tcohen barton++ 13:30 ashimema barton++ 13:31 tcohen #info Barton volunteered to write patches fixing POD 13:31 tcohen #info Nick volunteers to update the coding guidelines text to reflect this change 13:31 kidclamp When updating a module you are required to add POD for added and changed subroutines or ensure existing POD is accurate, it is encouraged to add POD to all subroutines as possible 13:32 Joubu we need a template 13:32 Joubu what is usually done : 13:32 kidclamp For two examples, see the POD comments in the Search.pm module (perldoc Search.pm) and the Biblio.pm module. 13:32 Joubu =head3 method 13:32 marcelr head2 reads nicer for subroutines 13:32 Joubu my $return_value = $obj->method ( $params ); 13:32 Joubu describe the params 13:33 Joubu what does the method 13:33 Joubu =cut 13:33 tcohen Joubu: do you think you can find a good example? 13:33 Joubu But as I already said 13:33 Joubu $patron->get_overdues 13:33 Joubu this method returns overdues for a patron 13:33 Joubu fantastically useful... 13:33 marcelr heh 13:34 kidclamp https://wiki.koha-community.org/wiki/Coding_Guidelines#PERL3:_Fix_warnings <- Do you think the current example needs added verbosity? 13:34 tcohen well, the object type is not useless information 13:34 kidclamp https://wiki.koha-community.org/wiki/Coding_Guidelines#PERL13:_POD 13:34 kidclamp wrong link 13:34 Joubu tcohen: nope, I don't think we have any 13:34 marcelr functions or methods? 13:35 Joubu any good examples 13:35 tcohen [off] khall noticed the meeting and ducked out 13:35 jajm the return type might be useful (hash, list, Koha::*) 13:36 marcelr distinction between class methods and instance methods ? 13:36 Joubu return: Koha::Overdues object 13:36 Joubu yes we could, but still think it's too verbose 13:36 Joubu it's implicit in the name of the method 13:37 cait def return type 13:37 cait please 13:38 tcohen #actions Tomas will look for a well formed and useful set of examples to vote on next meeting 13:38 cait I always find it helpful if the documentation is clear about these things 13:38 marcelr not too much duplicated info in the pod that will be outdated after a few years because it wasnt updated? 13:38 marcelr very often the params donot match 13:38 marcelr just three lines lower.. 13:39 tcohen now we are moving to Koha::Object(s) that are passed around, things will be simpler 13:40 tcohen #koha: I volunteered to look for good sample PODs to be used as templates so we vote on that next meeting. Right now we need to either vote or accept unanimously the changes Nick proposed 13:41 tcohen does anyone disagrees with the proposed changes? 13:41 ashimema nope 13:41 kidclamp not me 13:41 marcelr vote now 13:41 cait or just do #agreed :) 13:42 tcohen #startvote Should we add "When updating a module you are required to add POD for added and changed subroutines or ensure existing POD is accurate, it is encouraged to add POD to all subroutines as possible" to the coding guidelines? (yes,no) 13:42 huginn Begin voting on:  Should we add "When updating a module you are required to add POD for added and changed subroutines or ensure existing POD is accurate, it is encouraged to add POD to all subroutines as possible" to the coding guidelines? Valid vote options are , yes, no, . 13:42 huginn Vote using '#vote OPTION'. Only your last vote counts. 13:42 tcohen #vote yes 13:42 kidclamp #vote yes 13:42 oleonard #vote yes 13:42 ashimema #vote yes 13:42 jajm #vote yes 13:42 cait #vote yes 13:42 Joubu #vote no 13:42 Joubu would have prefered the pod at the end 13:42 tcohen :-P 13:42 marcelr #vote yes 13:42 kidclamp Joubu++ 13:42 rsantellan #vote yes 13:43 tcohen anyone else? 13:43 tcohen #endvote 13:43 huginn Voted on " Should we add "When updating a module you are required to add POD for added and changed subroutines or ensure existing POD is accurate, it is encouraged to add POD to all subroutines as possible" to the coding guidelines?" Results are 13:43 huginn yes (8): cait, oleonard, ashimema, jajm, marcelr, kidclamp, tcohen, rsantellan 13:43 huginn no (1): Joubu 13:43 tcohen sorry, Joubu 13:43 ashimema 'perl best practice' suggests after the __END__ block.. but I personally prefer inline ;) 13:43 tcohen khall: around? 13:43 ashimema but can see where Joubu is coming from 13:43 Joubu I can live with that :) 13:44 Joubu I am from Belgium man! :p 13:44 ashimema haha 13:44 tcohen ok, next topic then 13:45 tcohen #topic Plans for bug 17908 13:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17908 enhancement, P5 - low, ---, m.de.rooy, ASSIGNED , Authority merge omnibus 13:46 marcelr ok, have been working on some older authority merge bugs 13:46 marcelr reorganizing them in a omnibus bug 13:46 marcelr a merge test has been pushed as well as the sub merge fixes on bug 17913; we are in "stage 3" now 13:46 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17913 normal, P5 - low, ---, m.de.rooy, Pushed to Master , Merge three authority merge fixes 13:46 khall #info Kyle Hall, ByWater Solutions 13:46 marcelr but we need to some more, and would appreciate support on that 13:46 magnuse marcelr++ 13:46 marcelr some more ideas: 13:47 marcelr auth_header should be autoincrement / remove the max(authid) logic 13:47 marcelr move zebra stuff outside of sub merge, use/extend CountUsage, add a GetBiblionumbers sub/method 13:47 marcelr restructure need_merge_authorities (perhaps rename it) : include old authno, old authtype and contents of old reporting field 13:47 marcelr distinction between migration tool and cron job 13:47 marcelr the table on 14769 should facilitate adjusting indicators when remerging authorities (via a script) 13:47 marcelr it is quite a lot actually 13:48 marcelr would be nice to keep some pace in that regard 13:48 Joubu sounds easy 13:48 Joubu :D 13:48 marcelr well thats easy qa too ;) 13:49 barton|away #info Barton Chittenden, BWS, Louisville KY USA. 13:49 barton I saw that I got volunteered ;-) ;-) 13:49 marcelr Joubu: solve one bug, find two new ones 13:49 tcohen #info Marcel has been working on resurrecting old authority merge patches, needs help and feedback 13:49 Joubu I think we need very good tests coverage for that change 13:50 marcelr i started with writing merge tests 13:50 marcelr and that helped i guess 13:50 cait marcelr++ 13:50 tcohen marcelr: have you seen jcamins work on the authority de-duplication tool? 13:50 marcelr yeah 13:51 Joubu could we reuse bib merging code? 13:51 marcelr in a later stage probably yes 13:51 tcohen marcelr: I think there was good stuff in there 13:51 marcelr will come there one day.. 13:53 tcohen marcelr++ # great work on old under-tested code 13:53 tcohen #topic Updates on bug 17196 13:53 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17196 enhancement, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Move marcxml out of the biblioitems table 13:54 tcohen Joubu: anything to say about it? 13:54 Joubu nope 13:54 Joubu I did not add it 13:54 tcohen I know, but anything would be your fault :-P 13:55 marcelr i did not too, but have a tiny remark 13:55 Joubu There is the patch to automgically convert the SQL 13:55 Joubu that will need testing 13:55 barton I just had a thought about changes to the wiki the marcxml queries... 13:55 marcelr had some weird problems with indexing until i restarted koha-indexer after upgrading 13:55 tcohen Joubu: #? 13:55 wahanui i think # is for root 13:56 Joubu bug 17898 13:56 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17898 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Add a way to automatically convert SQL reports 13:56 tcohen marcelr: it makes sense :-D 13:56 barton the wiki itself is internally version controlled ... we could put a note at the top of the wiki pointing to the old version. 13:56 tcohen marcelr: that reminds me that we need to make the packages restart koha-common on upgrade 13:57 marcelr ok 13:57 Joubu marcelr: that should be fixed by 16733, right? 13:57 Joubu bug 1673 13:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1673 blocker, P3, ---, gmcharlt, CLOSED FIXED, Error Fields Need Highlighted 13:57 Joubu bug 16733 13:57 marcelr no Joubu 13:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16733 enhancement, P5 - low, ---, m.de.rooy, RESOLVED FIXED, More flexible paths in debian scripts (for dev installs) 13:57 marcelr not related to that bug 13:58 tcohen #info Now that removing marcxml from 'biblioitems' is pushed, it is urgent that people test bug 17898 so it can be pushed and tested A LOT before the release 13:58 tcohen koha-indexer launches rebuild_zebra.pl -d 13:59 tcohen from a fixed location 13:59 tcohen anything else? 13:59 wahanui somebody said anything else was just being crap 14:00 tcohen #topic REST api / Bug 17932 14:00 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17932 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Koha::Object should provide a TO_JSON method 14:00 tcohen I wanted to mention that I'm working on a couple new endpoints and I found that our API data types where incorrect 14:01 tcohen they are fixed by bug 17927 (which resurrects a porting of bug 17008's patches) 14:01 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17927 normal, P5 - low, ---, tomascohen, Passed QA , REST API: /holds and /patrons attributes have wrong types 14:01 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17008 enhancement, P5 - low, ---, lari.taskula, RESOLVED WONTFIX, REST API: Correct data types in Swagger 14:02 tcohen so I put together some ideas an wrote 17932 14:02 tcohen which basically adds a TO_JSON method that handles data types correctly 14:02 cait sorry, have to leave early 14:03 LibraryClaire me too 14:03 tcohen the main problem where integers and DBD::mysql which is explained on the first commit message 14:03 tcohen but also Boolean values 14:03 tcohen we have a situation with booleans 14:04 tcohen we store them on the DB as TINYINT(1) 14:04 Joubu Yes that's a known issue, that can contain only 2 values 14:04 tcohen but we also store other tinyint values which are not booleans 14:04 tcohen TINYINT(4) 14:04 tcohen you just grep -i tinyint on kohastructure.sql and you will notice 14:06 tcohen so, we cannot deduce from the code if something is a boolean 14:06 tcohen (i.e. lokking up on the schema) 14:07 tcohen because (1) is just a mask to tell the DB how do we want to have the 8-bit value sent 14:09 tcohen DBIC doesn't know about it 14:09 tcohen so, the subject I wanted to raise 14:09 tcohen is on the 'Fix /patrons endpoint' patch 14:11 * ashimema thinks we shouldn't be dbicdumping any more.. and booleans should be marked as booleans in dbic result classes 14:13 ashimema noone else still around? 14:13 tcohen I added a syntax for explicitly stating on the schema files that a field is a boolean value 14:13 tcohen basically, we need to add __PACKAGES__->add_columns( '+column_name' => { is_boolean => 1 } ); 14:13 * oleonard is but is sitting this one out 14:13 khall I'm not opposed to the idea 14:13 gmcharlt_ @quote random 14:13 huginn gmcharlt_: Quote #264: "<druthb> Grokking someone else's code is still trying to reverse-engineer someone else's brain." (added by wizzyrea at 11:50 PM, June 26, 2013) 14:13 wahanui i already had it that way, huginn. 14:13 tcohen a proper solution could involve moving all boolean values into (say) BIT column type 14:13 tcohen which is supported by Postgres as well 14:14 ashimema hmm 14:14 * druthb perks up, smiles, and returns to her hacking. 14:14 ashimema I hadn't considered that one 14:14 tcohen this is only useful for the TO_JSON function 14:14 tcohen and once we figure a better way, we just need to change the implementation on TO_JSON 14:14 tcohen I added bug 17992, to highlight the consequences of the change on our reference implementation 14:15 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17992 minor, P5 - low, ---, tomascohen, Needs Signoff , REST api: Cities controller should not use ->unblessed 14:15 tcohen I encourage everyone interested on the REST api implementation to comment and/or tests those bugs 14:15 tcohen and also contact me so we can coordinate and maybe solve issues together 14:15 Joubu BIT sounds like what we should pick 14:15 marcelr the title does not really reveal this topic 14:15 jajm BIT can store more than true/false value 14:16 Joubu not BIT(1) 14:16 tcohen ashimema, I agree, but there's some work to be done so that becomes real 14:16 jajm ok 14:17 tcohen #info Tomas requests comments on bug 17932 and the way it handles booleans, until we figure a DB structure change to ease it 14:17 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17932 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Koha::Object should provide a TO_JSON method 14:18 tcohen #actions Tomas volunteers to write a patch to move boolean values into BIT 14:18 kidclamp tcoehn++ 14:18 kidclamp tcohen++ 14:18 barton tcoehn++ 14:18 josef_moravec_ restapi++ 14:20 tcohen ok, i'm waiting for the flooding emails and comments about the REST api 14:20 tcohen the other part of the topic 14:20 tcohen was 14:21 tcohen do we have an indentation coding guildeline for JSON? 14:21 tcohen I added it lat minute and don't have DNS resolution right now to check myself 14:22 ashimema not that i can see 14:23 ashimema I would ++ some though ;) 14:23 * ashimema likes tidy code 14:24 * Joubu votes for 2 tabs + 3 spaces 14:25 marcelr the best discussion go about tabs and spaces :) 14:25 tcohen1 am i online now? 14:25 oleonard Yes tcohen1 14:25 marcelr sure 14:25 ashimema we see you tcohen1 14:26 tcohen1 ok, wifi is back, edge connection was really bad 14:26 tcohen1 (nick tcohen 14:26 tcohen1 ok, i cannot chair as tcohen1 I think 14:27 khall is an op around to kick tcohen? 14:27 tcohen1 ? 14:27 tcohen1 try 14:28 khall I'm not an op, magnuse? 14:28 khall thanks magnuse! 14:28 magnuse like that? 14:28 wahanui like that is hard to vote on. :) 14:29 oleonard Let that be a lesson to you tcohen 14:29 khall lol 14:29 tcohen1 ok, we have JSON with 2 and 4 spaces 14:29 * tcohen unhides 14:29 tcohen any preference? 14:30 tcohen we should add it to our shipped .editorconfig file 14:30 Joubu :q 14:30 khall tcohen: couldn't hurt! 14:31 tcohen Joubu: i bet there's a vim plugin for editorconfig 14:31 jajm tcohen, there is 14:31 khall https://github.com/editorconfig/editorconfig-vim 14:32 tcohen the idea is that you can have your preferred indentation config globally, but the editor picks the right one for the Koha source 14:32 tcohen anyway 14:32 tcohen moving on I guesss 14:32 tcohen #topic Bug 17981 14:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17981 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Add the ability to preview generated notice templates 14:33 Joubu Nothing to do, just checkout the remote branch and test 14:33 Joubu it's on top of a quite big tree of patches, non-pushed yet 14:33 * magnuse wanders off 14:33 Joubu Everything is explained in the commit message 14:33 * oleonard is working on a template follow-up for it 14:34 tcohen oleonard: great 14:34 Joubu and yes, oleonard is going to make it awesome :) 14:34 tcohen #info Owen is working on a followup for 17981 14:34 khall oleonard++ 14:34 tcohen oleonard++ 14:35 tcohen #topic Critical bug for 3.22.x: bug 17943 14:35 Joubu I could also ask on the ML for some people to send me non-standard templates 14:35 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17943 critical, P2, ---, gmcharlt, NEW , "make test" failed when upgrading from koha-3.22.10 to 3-22.14 , also fresh installation of koha-3.22.14 made the same "make test" failing 14:35 Joubu to see if the conversion works as expected for complex templates 14:35 Joubu (that's all) 14:35 Joubu about 17943, I talked about it earlier 14:36 jajm i'll look at this bug asap 14:36 tcohen #info Julian is going to work on bug 17943 ASAP 14:36 tcohen #topic Security bugs to QA 14:37 Joubu there are some security bugs in the QA queue 14:37 marcelr will look at some on friday 14:37 Joubu maybe RM and RMaints should sync to push them altogether 14:37 marcelr if they are left 14:38 tcohen #info there are 6 security bugs on the QA queue, and one in NSO 14:38 khall barring unforseen events I'll be pushing those to master Friday morning if they are pqa 14:38 tcohen I haven't had any time to do QA besides a couple small things 14:38 Joubu https://bugs.koha-community.org/bugzilla3/buglist.cgi?bug_status=Needs%20Signoff&bug_status=Signed%20Off&bug_status=Passed%20QA&bug_status=Pushed%20for%20QA&bug_status=Failed%20QA&bug_status=Patch%20doesn%27t%20apply&list_id=188810&product=Koha%20security&query_format=advanced 14:39 tcohen khall: maybe coordinate with the rmaints about them 14:39 marcelr no bugs Joubu 14:39 khall @later tell cait we should coordinate on security bugs 14:39 huginn khall: The operation succeeded. 14:40 Joubu marcelr: that means you cannot see security bugs 14:40 marcelr ok, not logged in 14:40 marcelr other browser 14:40 marcelr that still works 14:40 tcohen khall: any comments on master/17.05? 14:41 khall tcohen: nothing too noteworthy. All the patches for merging our disparate payment functions into one are complete! 14:41 tcohen khall++ 14:41 khall next on the docket for me is to bring back the account offsets table 14:41 khall https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14826 14:41 huginn 04Bug 14826: enhancement, P5 - low, ---, kyle.m.hall, Needs Signoff , Resurrect account offsets table 14:42 khall that's about it 14:42 tcohen alright 14:42 tcohen #info Patches merging payment functions are all on master now 14:42 tcohen moving on 14:43 tcohen #topic Updates from the QA team 14:43 * marcelr is curious 14:43 tcohen hehe 14:43 marcelr queue is growing 14:43 Joubu too many bugs in the QA queue 14:44 marcelr if we go over 100, maybe put on your fast qa hat 14:44 Joubu need QA pov on bug 17933 14:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17933 major, P1 - high, ---, dpavlin, Signed Off , Internal software error when searching patron without birth date 14:45 tcohen the REST api bugs on the SO queue need to be refactored a bit 14:45 Joubu Does a QAer want to be dedicated to QAing "TT syntax for notices" patches? 14:45 Joubu 2 would be great 14:46 marcelr not especially :) 14:46 khall Joubu: I'd be happy to do that if you don't need me to contribute to the coding 14:46 marcelr but wont avoid them either 14:47 Joubu khall: I think a first glance on what I did would be much appreciated 14:47 Joubu khall: at least to know if I am in the right direction 14:47 khall Joubu: Can do! 14:47 jajm i see only 2 "TT" patches in the QA queue, am i missing somthing ? 14:47 khall just ping me with bug numbers as you have them ready 14:47 Joubu jajm: nope, only 2 are QAed, but lot in the NSO 14:48 tcohen I'm going to work on QAing bug 17255 14:48 Joubu khall: I think you can checkout the remote branch with everything in it, then squash everything. To get an overview 14:48 khall Joubu: good idea, can you post the url to that branch here for posterity? 14:48 Joubu tcohen: I'd like to get an eye on it before it's pushed 14:49 Joubu https://github.com/joubu/Koha/tree/bug_17981 contains everything 14:49 tcohen Joubu: np 14:50 Joubu tcohen: we should contact Sdjan about the authorship of his patches, kivilahtio did not provide follow-ups but new patches 14:50 Joubu and half of the changes are from the first patchset 14:51 tcohen good point, I'll try to contact kivilathio on that 14:51 tcohen ok, I think we can move on 14:52 tcohen #topic Set time of next meeting 14:52 marcelr 13utc is my favorite time 14:52 tcohen Proposals? 14:52 tcohen same for me 14:52 kidclamp I think we alternate though 14:52 marcelr ok 14:52 tcohen yeah 14:52 kidclamp or was the plan, so 20UTC would be next 14:53 tcohen if we keep two meetings a month 14:53 tcohen we can have on at 20 and one at 13 14:53 Joubu feb 8 20utc 14:54 tcohen and feb 22 14:54 tcohen 13 utc 14:54 tcohen ok? 14:54 barton sounds good to me. 14:54 kidclamp +1 14:54 barton +1 14:54 marcelr one at 13utc sounds ok 14:56 tcohen #info February meetings will be on Feb 8th (20UTC) and Feb 22nd (13UTC) 14:56 tcohen #koha apologies for the connection issues 14:56 tcohen thanks for attending the meeting 14:56 tcohen #endmeeting 14:56 huginn Meeting ended Wed Jan 25 14:56:46 2017 UTC. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) 14:56 huginn Minutes: http://meetings.koha-community.org/2017/development_irc_meeting_25_january_2017.2017-01-25-13.06.html 14:56 huginn Minutes (text): http://meetings.koha-community.org/2017/development_irc_meeting_25_january_2017.2017-01-25-13.06.txt 14:56 huginn Log: http://meetings.koha-community.org/2017/development_irc_meeting_25_january_2017.2017-01-25-13.06.log.html 15:00 oleonard Joubu: is the JavaScript related to '#convert_template' used somewhere? I don't see any instance of 'convert_template' in letter.tt 15:01 oleonard (Bug 17981) 15:01 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17981 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Add the ability to preview generated notice templates 15:02 marcelr thx tcohen 15:03 Joubu oleonard: nope, I wanted to add a "convert template" button to put the generated TT template to the textarea. But I finally abandoned the idea (for now?) 15:03 oleonard Okay thanks 15:11 jajm Joubu, about bug 17943, i'll probably revert bug 17494, but i think i should keep the first patch (https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57212) what do you think ? 15:11 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17943 critical, P2, ---, gmcharlt, NEW , "make test" failed when upgrading from koha-3.22.10 to 3-22.14 , also fresh installation of koha-3.22.14 made the same "make test" failing 15:11 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17494 major, P5 - low, ---, kyle, Pushed to Stable , Koha generating duplicate self registration tokens 15:14 Joubu jajm: yes, I think that should be enough 15:14 jajm ok thanks 15:38 Joubu oleonard: any information you could give me to recreate the CircAutoPrintQuickSlip issue? 15:39 Joubu things like: do you recreate on master? 15:40 Joubu because I tried master, 3.22.08 and the 16.05.06 and everything is fine 15:41 oleonard No, I don't get the error on master 15:45 Joubu superlibrarian user? 15:47 oleonard I do get the error when I check out tags/v03.22.08 and test with either superlibrarian or other librarian user 15:50 oleonard Same with tags/v16.05.06 15:55 Joubu kohadevbox, drop the DB, recreate from the installer on top of v3.22.08. logged as superlibrarian 15:55 Joubu I only switch CircAutoPrintQuickSlip to "clear the screen" 15:55 Joubu and it clears the screen as expected 15:55 Joubu I let this one to someone else 16:03 drojf oleonard: have you seen bug 17878? i think some custom js we use for the floating toolbar in cataloguing breaks it for IE 16:03 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17878 normal, P5 - low, ---, gmcharlt, NEW , Tag editors (and floating toolbar in MARC editor) not working with IE11 16:03 oleonard drojf: I haven't looked at it yet 16:04 oleonard I do have IE11 so I guess I should :| 16:04 drojf yay for IE users :P 16:04 Joubu oleonard: actually it should fail for me as well, but it does not :p 16:05 oleonard Should? 16:05 drojf [off] Joubu: just read the meeting log, congratulations! 16:06 oleonard Joubu: I do get the error on a new db in 16.05.06 16:06 Joubu oleonard: no actually not. $borrower is undef 16:06 Joubu oleonard: could you confirm you get the error if you directly hit /circ/circulation.pl, without param? 16:06 Joubu [off] thx! 16:07 oleonard Joubu: No error from directly hitting /circ/circulation.pl 16:07 Joubu ha.. 16:07 oleonard Joubu: I thought you were leaving this to someone else :) 16:08 Joubu me too... 16:09 Joubu there is something obvious I do not see 16:11 * Joubu checkouts master and forgets the last 15min 16:11 Holdings Hello everyone 16:11 Holdings I have a problem 16:12 Joubu me too, there is no more tea 16:12 Joubu hi Holdings 16:13 Holdings when i try to place a hold 16:13 Holdings and i click on "place hold" 16:14 Holdings i need to log in again 16:14 Holdings do you know why is that happening? 16:14 Joubu Which version are you using? How did yo install Koha? 16:14 Joubu at the opac or staff interface? 16:15 Joubu Is it a new installation or you just upgraded? 16:17 Holdings 16.05.01.000 16:17 Holdings its installed on vps 16:17 Joubu you should upgrade to the latest 16.05.x version 16:19 oleonard Holdings: When you log in again does it let you place the hold? 16:23 Holdings yes 16:23 Holdings it let me 16:23 Holdings but have other problems too 16:23 Holdings when i go to the opac 16:23 Holdings and i log in 16:24 Holdings the username appears on top 16:24 Holdings but if a make a search or anything i need to log in again 16:25 Holdings and the message "Log in to your account" shows up 16:26 Joubu what's the value of the pref "SessionStorage"? 16:30 Holdings temporary files 16:32 reiveune bye 16:34 Joubu try mysql, but temporary files should work 16:34 Holdings and i need to log every time 16:34 Holdings is not working 16:35 Holdings still the same problem 16:35 Joubu did you update to the latest 16.05.x? 16:36 Holdings no 16:36 Holdings i dont know if i can do it 16:37 Holdings because i cant screw this thing 16:41 Joubu so basically you have to log twice, that's it? 16:41 Holdings yup 16:41 Holdings practically every time 16:41 Holdings when i do a search 16:42 Holdings when i open the opac 16:42 Holdings when i want to place a hold 16:42 Holdings everytime 16:42 Joubu and then you are logged in or you have to login twice again? 16:43 Holdings let me explain it again 16:43 Holdings i open the opac and i log in 16:44 Holdings and i can see my stuff 16:44 Holdings but if i make a search 16:44 Holdings it shows like im not logged in 16:44 Holdings and i need to log again 16:45 Holdings and if i want to place a hold i need to log again 16:45 Joubu ok so it's unusable, but you do not want to break it :) 16:45 Holdings every time i make something like a search or anything i need to log again 16:45 Joubu it is a new install, that's it? 16:46 Holdings lol 16:46 Joubu How did you install it? 16:46 Holdings it not new 16:46 Holdings i have like 1000 books 16:46 Joubu ha, so you upgraded recently? 16:47 Holdings and its something i cant make unusable 16:47 Holdings no... 16:47 Holdings i didnt make any upgrades 16:47 Holdings i installed it like 6 moths ago 16:48 Joubu but the bug is new? 16:49 eythian @quote add <Joubu> ok so it's unusable, but you do not want to break it :) 16:49 huginn eythian: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). 16:49 Holdings i dont know 16:49 eythian damnit 16:50 Joubu you do not know if the bug is new? 16:50 Joubu I am sorry I am a bit lost 16:50 Holdings i dont know 16:50 Joubu Is the OPAC public? 16:51 Holdings nope 16:51 Holdings :-( 16:52 eythian have you tried a different browser? 16:54 Joubu ha, what is the error you get when you see the loggin form for the second time? 16:54 Joubu something about the IP? 17:00 Holdings im using google chrome 17:03 Holdings i tried on explorer and still not working 17:04 Holdings on firefox is the same thing 17:06 LibraryClaire laters #koha 17:31 LibraryClaire @wunder konstanz 17:31 huginn LibraryClaire: An error has occurred and has been logged. Please contact this bot's administrator for more information. 17:31 Holdings uys 17:31 Holdings guys 17:31 Holdings i need some help 17:32 Holdings i need to find biblioitems file 17:32 Holdings i have a problem with some records 17:34 cait_afk it's a database table 17:34 cait_afk not a file 17:35 Holdings well... i need to open it 17:35 Holdings because some records are wrong 17:35 cait_afk you cannot change it in the db 17:35 Holdings it show "null" instead of title 17:35 cait_afk if the record is wrong 17:35 cait_afk it might only not display 17:35 cait_afk does it only display null in the results list? 17:36 Holdings no 17:36 cait_afk what marc flavour is your data in? 17:36 Holdings on patron details 17:37 Holdings marc21 17:37 Holdings when i want to see current check out 17:38 Holdings and i look for a patron 17:38 Holdings it shows "null" instead of title 17:42 Holdings and if a click on "null" i can see the book information 17:48 Holdings hello 17:48 wahanui what's up, Holdings 17:49 Holdings anyone? 17:49 wahanui Anyone? Anyone? Bueller? Bueller? 17:49 Holdings Hey 17:58 martian523 good morning! 17:58 wahanui well, it's morning somewhere, yes 17:59 martian523 i was trying to get some help on my koha yesterday, but couldn't finish, hopefully someone can help me today? 18:00 martian523 upgraded from 3.18 to 16.05.07 recently. everything seems to be running pretty smooth until i hit some errors yesterday in the acquisitions 18:01 martian523 the following error came up when i was trying to look up vendors in acquisitions: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054. 18:03 martian523 then this error came up when i clicked on the money amount in the "ordered" column and "spent" column in the funds list: An error occurred fetching records: Table 'kohadb.aqorders' doesn't exist at /usr/share/koha/intranet/cgi-bin/acqui/spent.pl line 88. 18:23 Joubu martian523: this table must exist 18:23 Joubu Do you have a backup of your 3.18 DB to check if the table existed before? 18:24 martian523 i don't think so 18:24 Joubu Did you use the acquisition module before the upgrade? 18:24 martian523 i don't think i have a back up... 18:24 martian523 yep 18:24 martian523 it was ok before 18:24 Joubu do you have access to the DB? 18:25 martian523 yes 18:25 Joubu show tables; 18:25 Joubu will return the number of tables in your DB 18:26 martian523 hold on, let me find my IT 18:29 martian523 actually we can't get to mysql 18:29 martian523 what's the command to mysql? 18:30 martian523 what should be typed after kohasysusr@debian -w01:~$ 18:31 Joubu mysql? 18:31 wahanui somebody said mysql was currently limited to 100MB of RAM. 18:32 martian523 where do you find "show tables;"? 18:33 Joubu you need to be in the MySQL CLI 18:33 martian523 for some reason couldn't get in? 18:34 martian523 we've tried many different commands, but still couldn't get into MySQL shell 18:34 Joubu you need to know a mysql user and its password 18:34 Joubu one is defined in the koha-conf.xml file 18:41 martian523 sigh....we can open the koha-conf.xml file but no password 18:42 martian523 i'm going crazy.... 18:43 martian523 we almost made it, but just don't know what the password is 18:44 Joubu you have <user> and <pass> 18:53 martian523 i have to wait. IT is busy with something else 18:54 martian523 this is not fun. i hope the acquisition table can be recovered 19:18 martian523 Joubu, how do you get into mysql> ? 19:21 martian523 we got to: root@debian -w01:/home/kohasysusr# koha-mysql response we got: Usage: /usr/sbin/koha-mysql instancename 19:22 rangi what is your instancename 19:22 rangi the message tells you exactly what you need to type 19:22 martian523 what's the input for instancename? the reason we want to get into mysql shell is because we want to execute : "describe aqbooksellers;" 19:22 rangi when you ran koha-create what instancename did you choose? 19:23 rangi if you cant remember 19:23 rangi sudo koha-list 19:23 rangi will list the instances you have created 19:25 martian523 trying to look for it...seems like we didn't create it 19:25 martian523 is that bad? 19:25 rangi how did you install koha then? 19:30 martian523 we downloaded the koha package 19:30 martian523 so far up to koha 3.18, we were ok 19:31 martian523 right after the upgrade to 16.05.07 everything seems to be fine, until i wanted to do acquisitions 19:43 rangi so you installed with the koha packages? 19:43 rangi then 19:43 rangi sudo koha-list 19:43 rangi will tell you the instance you created 19:45 rangi if it doesnt, you are either on the wrong server, or you didnt install using the debian packages 19:57 martian523 @rangi got into mysql> 19:57 huginn martian523: I've exhausted my database of quotes 20:00 martian523 sorry 21:35 martian523 got into mysql...however, mysql> describe aqbooksellers; returned with: ERROR 1046 (3D000): No database selected 21:42 cait martian523: you have to do use <databasename> 21:42 cait it's usually something like koha_instancename 21:42 wizzycray so you didn't install using packages then? 21:43 wizzycray martian523, you could try "show databases" 21:46 cait thx wizzyrea :) 21:46 martian523 we initially installed koha with installing debian 21:47 wizzycray ok, on your command line, what do you see if you do 21:47 wizzycray sudo apt-cache policy koha-common 21:47 martian523 then extracting koha-3.14.11.tar.gz file 21:47 wizzycray ahh 21:47 wizzycray then you won't see anything from apt-cache policy :) 21:48 wizzycray right, so 21:48 wahanui somebody said right, so was the merge_authority.pl cronjob started by default? Or did I misunderstand what it is saying. 21:48 wizzycray in your mysql client, do 21:48 wizzycray show databases 21:48 wizzycray martian523 ^ 21:48 wizzycray do you spot your Koha database there? 21:49 martian523 nope. just returend with -> 21:49 martian523 blank 21:49 wizzycray ok, so 21:49 wizzycray put a ; 21:49 wizzycray then enter 21:49 wizzycray show databases; 21:49 wizzycray should be what you run 21:49 wizzycray all mysql client commands end with a semicolon 21:50 wizzycray -> means you have forgotten it. 21:50 wizzycray martian523 ^ 21:51 martian523 when put semicolon, returns with error 21:52 wizzycray not surprising 21:52 wizzycray do 21:52 wizzycray exactly this 21:52 martian523 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'a show databases' at line 1 21:52 wizzycray show databases; 21:52 wizzycray and press enter 21:52 wizzycray martian523 ^ 21:53 martian523 ok, got it 21:53 wizzycray awesome. 21:53 wahanui That'll be €1 for the awesome jar, wizzycray 21:53 * wizzycray happily pays 21:54 wizzycray so 21:54 wizzycray you see your koha database there? 21:54 wizzycray martian523 ^ 21:54 martian523 +--------------------+ | Database | +--------------------+ | information_schema | | kohadb | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.02 sec) 21:54 wizzycray great 21:54 wizzycray use kohadb; 21:54 wizzycray describe aqbooksellers; 21:55 wizzycray at this point idk what they were wanting you to check for 21:55 wizzycray martian523 ^ 21:55 martian523 to check if my table matches the table they sent to me yesterday 21:55 wizzycray but, that's how you look at stuff in your kohadb :) 21:55 martian523 thanks! 21:55 wizzycray in mysql 21:56 martian523 because right now my aquisitions returns with error 21:57 martian523 so yesterday they asked me to check my table with the table they gave me 21:57 wizzycray ah cool 21:57 wizzycray you could also do 21:57 wizzycray select * from aqbooksellers; 21:57 wizzycray to see the data in that table 21:58 martian523 everything looks normal to me except for varchar(10) saying "NO" in Null column 22:01 martian523 sorry got to attend meeting. be back later with solving this acquisitions issue. 22:17 cait wizzycray++ :) 22:28 martian523 I was trying to search for a vendor in acquisitions. I typed in the vendor name, pressed submit, and this error returned: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054. Then I tried just leaving the search blank and pressed submit. Same error. I also have funds listed in the acquisitions page. Tried to click on the dollar amount on the "ordered" and "spent" columns, and the follow err 22:29 martian523 An error occurred fetching records: Table 'kohadb.aqorders' doesn't exist at /usr/share/koha/intranet/cgi-bin/acqui/spent.pl line 88. 22:29 martian523 so i guess something went missing during the upgrade?? 22:34 wizzycray if you do 22:34 wizzycray describe aqorders; 22:34 wizzycray in your mysql db, does it return anything? 22:34 wizzycray martian523 ^ 22:34 wizzycray sorry I keep forgetting to put your name first 22:35 martian523 it's ok. =) yeah, the table 22:37 wizzycray hm, not sure how you could both have the table and not have the table. 22:37 cait other things work? circ and all that? 22:38 martian523 yeah, check in check out works 22:38 martian523 catalog search works 22:38 cait hm odd 22:38 wizzycray hm. ok 22:38 cait oh 22:38 martian523 just acquisitions 22:39 martian523 all of you are very helpful and i really appreciate your help 22:40 wizzycray ok martian523 - please exit out of the mysql client, with 22:40 wizzycray exit 22:40 martian523 ok 22:41 wizzycray would you please do 22:41 wizzycray locate koha-conf.xml 22:41 wizzycray I don't know if that will work 22:42 martian523 ok 22:42 wizzycray but if it does, it will be helpful 22:42 martian523 showed a list of things 22:42 wizzycray ooo 22:42 wizzycray paste them please paste.koha-community.org 22:44 martian523 http://paste.koha-community.org/279 22:44 wizzycray neat thank you 22:45 wizzycray right 22:45 wizzycray ok so 22:45 wizzycray in your favourite editor, open /etc/koha/koha-conf.xml 22:45 wizzycray or just look at it 22:46 wizzycray something like less /etc/koha/koha-conf.xml 22:46 martian523 you mean just type that in? 22:46 wizzycray sudo less /etc/koha/koha-conf.xml 22:46 wizzycray yep 22:46 wizzycray ^ with the sudo 22:46 martian523 got it 22:47 martian523 want me to paste it? 22:47 wizzycray um no 22:47 wizzycray it's got your db password in it 22:47 wizzycray for your kohadb :) 22:47 wizzycray BUT 22:47 wizzycray what I do want you to do 22:47 wizzycray is scroll down til you see <config> 22:48 wizzycray and look at what the values are for <database> 22:48 wizzycray and for <hostname> 22:48 wizzycray I'm *guessing* it will say 'kohadb' and 'localhost' but it might not! 22:49 wizzycray (I'm just trying to sort out if you are actually looking at the database you think you are) 22:50 martian523 you're correct 22:50 wizzycray and the mysql you connected to with the client 22:50 wizzycray if you know 22:50 wizzycray that was localhost? 22:50 martian523 database: kohadb hostname: localhost 22:50 wizzycray you did something like mysql -uroot -p 22:51 wizzycray to get into the mysql client? 22:51 martian523 yes 22:51 wizzycray fun trick, you can do 22:51 wizzycray (from the values in that koha-conf) 22:51 martian523 with the paranthesis? 22:51 wizzycray mysql -ukoha -p kohadb 22:51 martian523 in mysql? 22:51 wizzycray and the password from that config 22:52 wizzycray that eliminates the "use kohadb" part 22:52 wizzycray in the mysql client 22:52 wizzycray anyway 22:52 wizzycray so ok we are talking to the right db, but we both do and don't think a table exists. 22:52 wizzycray this is perplexing. 22:53 martian523 yes. very interesting 22:53 wizzycray hm 22:53 * wizzycray ponders 22:54 martian523 the worst case is to downgrade and upgrade again...but i really don't wanna do that 22:54 wizzycray mmm no 22:54 wizzycray can't do that anyway really. 22:55 wizzycray afk for a little, imma background process this problem and have some lunch :) 22:55 martian523 ok. thanks 22:55 martian523 i'll be away as well for a while 22:55 martian523 but you can think on that 22:55 martian523 while having lunch. =) 23:24 cait @wunder Konstanz 23:24 huginn cait: The current temperature in Mainaustraße, Konstanz, Germany is -4.1°C (12:18 AM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 78%. Dew Point: -7.0°C. Windchill: -4.0°C. Pressure: 30.33 in 1027 hPa (Steady). 23:35 bag @wunder pdx 23:36 huginn bag: The current temperature in Portland, Oregon is 7.0°C (2:53 PM PST on January 25, 2017). Conditions: Mostly Cloudy. Humidity: 82%. Dew Point: 4.0°C. Pressure: 30.30 in 1026 hPa (Steady). Winter Weather Advisory in effect until 1 PM PST Wednesday... 23:36 bag it’s warmed up here cait 23:43 CrispyBran Is there anyone here that works with the kohadevbox? 23:43 aleisha me 23:43 CrispyBran Have you used it in a VM under Windows? 23:44 aleisha no not Windows 23:44 CrispyBran bummer. OK