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