Time  Nick       Message
00:02 wizzyrea   https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17698 it might have been this one
00:02 huginn     04Bug 17698: enhancement, P5 - low, ---, aleisha, Needs Signoff , Make patron notes show up on staff dashboard
00:04 wizzyrea   https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17698#c24
00:04 wizzyrea   here
00:04 huginn     04Bug 17698: enhancement, P5 - low, ---, aleisha, Needs Signoff , Make patron notes show up on staff dashboard
00:05 mtj        mtompset: when i get really stuck... i wrap the code block in a DBI trace
00:06 mtj        DBI->trace(2);
00:06 mtj        my $check_category = Koha::Patron::Categories->find( $categorycode );
00:06 mtj        DBI->trace(0);
00:06 mtj        i think that trace syntax should work
00:06 mtompset   And where does that output go?
00:07 mtj        default error log, afaik
00:08 mtj        C4::Context->dbh->trace(2);
00:08 mtj        ..that syntax works too
00:10 mtj        ..its really handy for WTF sql bugs
00:11 mtompset   boy it is noisy.
00:12 mtompset   But I'm not sure I can make sense of it.
00:13 mtompset   It seems to have gotten the correct SQL query built.
00:13 mtompset   Binding parameters: SELECT COUNT( * ) FROM `categories` `me` WHERE ( `categorycode` = 'CPL' )
00:14 mtompset   but it is returning 0
00:15 mtj        trace(1) might be nicer for your situ
00:16 pastebot   "mtompset" at pasted "Code Snippet" (6 lines) at http://paste.koha-community.org/547
00:17 pastebot   "mtompset" at pasted "Log Snippet" (104 lines) at http://paste.koha-community.org/548
00:20 mtompset   Any novice mistakes that I made from what you can tell?
00:22 mtj        that dump is too nosiy for me to parse
00:23 mtj        trace a single statement
00:23 mtompset   I'm tweaking.
00:25 pastebot   "mtompset" at pasted "just a Koha::Patron::Categories->find( $categorycode );" (85 lines) at http://paste.koha-community.org/549
00:25 mtompset   I think I might try to REMOVE the URL noise.
00:28 mtj        https://httpd.apache.org/docs/2.4/mod/core.html#errorlogformat
00:28 pastebot   "mtompset" at pasted "less noisy" (85 lines) at http://paste.koha-community.org/550
00:29 mtj        i use 'ErrorLogFormat "%M"' in my apache vhost file
00:29 mtj        .. which removes that referer/url noise
00:30 mtj        trace(1) looks better
00:30 mtompset   that aside... any ideas?
00:31 mtompset   why does the execute generate 0E0?
00:33 mtj        hmm, i cant set it calling a count().. so thats odd hey
00:33 mtompset   I changed the code trae.
00:33 mtompset   my $category = Koha::Patron::Categories->find( $categorycode );
00:36 mtj        no ideas
00:37 mtompset   Well, thanks for the debugging tips.
00:37 mtj        ..other than trace(2)  looks to be a bit noisy - try trace(1)
07:37 gaetan_B   hello
07:43 * cait     waves
07:43 cait       good morning #koha
09:52 * kidclamp waves
10:01 eythian    hi
12:34 * LeeJ     waves
12:34 LeeJ       morning #koha
12:36 * LeeJ     settles into his new office
12:41 Joubu      hi #koha
12:45 JesseM     hi Joubu
12:47 LeeJ       hi to everyone!
12:54 marcelr    hi #koha
13:03 LeeJ       hi marcelr
13:03 marcelr    hey LeeJ
13:17 gerundio   hi everyone
13:19 gerundio   I'm using koha 3.22.07 and after a library staff member performed an inventory operation in the intranet UI our error log sky rocketed
13:19 gerundio   25G worth of "inventory.pl: Use of uninitialized value in string eq at /usr/share/koha/intranet/cgi-bin/tools/inventory.pl line 326" in 2.5h
13:21 gerundio   after clearing up the logs and stoping apache, a "0" file under a /tmp subdir consumed all the 25G in a blink of an eye
13:21 gerundio   I just stopped the zebra process and things seems calmer now
13:26 gerundio   any idea what could be behind this behavior?
13:33 cait       we recenty had a dateformat problem with inventory
13:33 cait       but it just caused an error
13:36 gerundio   @cait, whatever the process was, it wrote a lot of entries just like that every second in the error log
13:36 huginn     gerundio: I'll give you the answer just as soon as RDA is ready
13:36 huginn     New commit(s) kohagit: Bug 17829: Fix import patron <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c650764e951eb35c60482e06494816ecaeedb200>
13:37 cait       it seems quiet here tonight, maybe somoene on the mailing list will know more
13:39 Joubu      Hi gerundio, the last version of the 3.22 series is 3.22.21, could you try with it?
13:40 gerundio   @Joubu, not at the moment
13:40 huginn     gerundio: I'll give you the answer as soon as RDA is ready
13:44 gerundio   @huginn ok, I'll be here
13:44 huginn     gerundio: I've exhausted my database of quotes
13:44 gerundio   lolol, bot, should've figured
14:09 Joubu      cait: so, what's next? :)
14:09 cait       sorry, didn't check today
14:09 cait       any movement on the bugs?
14:10 cait       i think next is pushing, backporting... and a clean-up script/instructions
14:10 cait       what do I do if the script says there are duplicated ids?
14:10 Joubu      sounds like bug 18966 is SO, tcohen added his SO patches but did not switch the status
14:10 huginn     04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Needs Signoff , Move of checkouts - Deal with duplicate IDs at DBMS level
14:10 cait       it's rather easy for issues compared to some of the others
14:10 cait       but i think issues is the most important
14:10 cait       i'd agree
14:10 cait       I have added mine to the 16.11 ones as I didn't test with all versions
14:12 Joubu      fridolin, mtj: around this week? Ready to release in the next days?
14:13 fridolin   yep
14:13 fridolin   iam
14:14 cait       same here
14:14 Joubu      fridolin: will you have time to take a look at 18966?
14:15 fridolin   Joubu: yep i will take time , lets say Thurthday
14:15 fridolin   Joubu: check on 17.05.x you mean right ?
14:15 Joubu      yes
14:16 fridolin   looks like optimize table can reset the next id
14:16 fridolin   I'll test that with reboot
14:18 fridolin   I've had today the same issue with old_reserves
14:18 fridolin   huggly bug
14:21 cait       yes, we have seen it in 3.22 too with reserves
14:21 cait       but it fails silently
14:21 cait       just in the logs
14:22 cait       and the reserve will be either filled or cancelled... losing that is not that big of a proble compared to an issue with connected fines
14:26 cait       Is someone working on clean-up instrucstions?
14:26 Joubu      @later tell khall Hi! Do you have plan for bug 15707?
14:26 huginn     Joubu: The operation succeeded.
14:34 fridolin   cait: cleanup_database you mean ?
14:34 fridolin   i plan to add old_xxx and deleted_xxx
14:35 fridolin   even statistics
14:35 fridolin   some of our databases are reeeeely old  and those tables always get bigger
14:36 cait       @later tell fridolin - no, I meant a way to actually return the book from the account, as the new patches will stop the transaction
14:36 huginn     cait: The operation succeeded.
14:36 Joubu      cait: I am not willing to propose it, I think support companies should provide and share such fix when they will face the different problems
14:37 cait       @later tell fridolin and simply truncating them will cause you unhappy libraries - old issues is used for statistics rather heavily
14:37 huginn     cait: The operation succeeded.
14:38 fridolin   cait: not all libraries do stats, and some have 10 years old rows, useless
14:38 cait       depends on the library i guess
14:38 fridolin   and not so good for privacy
14:38 fridolin   O:-)
14:38 cait       we are aiming for a tool to anonymize frequently
14:38 cait       agreed on that point
14:39 cait       but removing the link to borrowers would already help with that
14:39 cait       you can do that from the interface with one of the tools, but I think it would be nicer as a cronjob
14:39 cait       also depetedborrowers
14:39 cait       remove everything that is not needed for reports (branchcode, categorycode, sort1 sort1 maybe...)
14:39 fridolin   deletedbiblioitems is huge in database
14:39 cait       we need to keep inventorybooks here
14:39 fridolin   it takes space in innobd buffer pool
14:40 cait       so throwing out data to identify the book deleted... could be a problem
14:40 cait       but yeah, having the options is sitll good, not stopping you :)
14:40 fridolin   i'll propose a simple truncation of tables
14:40 cait       just have spent some time working on a concept aroudn those
14:40 cait       concept of how long to store which data... so I thought about it quite a lot
14:41 fridolin   yep
14:41 fridolin   i'm more a datakiller, simple and performant
14:41 fridolin   most libraries just dont know it exists ;)
14:42 fridolin   and privacy is always in danger when data exists, even anonymously
14:56 cait       ours are pretty keen on satistics
14:56 cait       more and more so even
14:56 cait       more pressure on the libraries to deliver reports and numbers
14:56 cait       so i think anonymization could be a good middle ground
14:56 tcohen     morning
14:57 cait       morning tcohen
15:02 Joubu      jajm: around?
15:06 jajm       Joubu, i'm leaving, sorry
15:07 Joubu      jajm: it would be great if you could take a look at bug 18966, it is delaying stable releases
15:07 huginn     04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18966 blocker, P5 - low, ---, jonathan.druart, Signed Off , Move of checkouts - Deal with duplicate IDs at DBMS level
15:08 Joubu      that can wait tomorrow :
15:08 Joubu      :)
15:10 cait       have to leave too and work on something non-koha when i get home tonight
15:10 cait       will be back tomorrow
15:43 jenkins    Project Koha_Master_D8 build #227: UNSTABLE in 2 hr 0 min: https://jenkins.koha-community.org/job/Koha_Master_D8/227/
15:43 jenkins    Jonathan Druart: Bug 17829: Fix import patron
15:43 huginn     04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17829 enhancement, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Move GetMember to Koha::Patron
16:20 * LeeJ     waves
16:25 CJSHayward I am interested in installing Koha along the lines outlined in https://web.archive.org/web/20160511060408/https://wiki.koha-community.org/wiki/Debian rather than bundled with a complete life support system.
16:26 CJSHayward I've got Koha listening in some sense, at least, but I get an error page: "Software error:  Can't call method "config" on unblessed reference at /usr/share/koha/lib/Koha/Database.pm line 56. For help, please send mail to the webmaster (webmaster@localhost), giving this error message and the time and date of the error."
16:32 LeeJ       CJSHayward: it would take some digging into the Koha commit log but it appears you are having repo conflicts. Which version of Koha are you attempting to install?
16:33 CJSHayward I attempted to install "stable." Would you advise I wipe completely (I don't have anything valuable in the system) all Koha installation(s) and reinstall? If so, how can I do that?
16:36 LeeJ       CJSHayward: if you're trying to install the version of stable listed in that link you posted (which would mean you are trying to install Koha 3.22) that is most likely the problem you have as since 3.22 there have been significant changes to most of the Koha modules (in this case Database.pm)
16:36 CJSHayward Ok; thank you.
16:37 LeeJ       CJSHayward: the current stable version is 17.05
16:37 CJSHayward So is there an easy way to wipe all installation(s) and reinstall?
16:38 LeeJ       none that I'm aware of other than starting over, I'm afraid. However, I could be wrong. Asking on the Koha lists may yield more helpful information
16:51 Joubu      CJSHayward: you can list the instances with koha-list, the delete them one by one with koha-remove
16:52 Joubu      you should consider using the wiki page https://wiki.koha-community.org/wiki/Debian, and install a recent Koha version on top of a recent Debian-base OS
16:52 Joubu      i.e. jessie-based
17:49 LeeJ       anyone have any suggestions how to get jQuery's datetimepicker to function in the OPAC?
17:49 LeeJ       for a plugin
17:54 cait       hm
17:54 cait       you need the time part, right?
17:55 cait       trying to remember if we have that somewhere.... but i think we might not in the OPAC
17:57 kidClamp   check the rolling hard due dates plugin LeeJ - I think that has date picker
17:58 kidClamp   https://github.com/bywatersolutions/koha-plugin-rolling-hard-due-dates
17:58 kidClamp   or kitchen sink maybe: https://github.com/bywatersolutions/koha-plugin-kitchen-sink
17:58 kidClamp   when in doubt - copy and paste :D
18:06 LeeJ       kidClamp++ # for having his thinking cap on today when I don't
18:07 LeeJ       kidClamp: ahhh...looks like rolling hard due dates uses calendar.inc
20:05 huginn     New commit(s) kohagit: Bug 18982: Create a circ rule for the data we created <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=5b84987f28b43f0c92eeff9ed1067ed61f822a4b> / Bug 18982: Create a specific itemtype for these tests <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ca0568f58393cff3fce6b362e59e90daa1b1524a> / Bug 18982: category.categorycode must be uppercase <http://git.koha-community.org/gitweb/?p=koha.git;
20:35 cait       Joubu: bug 18984 - interesting!
20:35 huginn     04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18984 enhancement, P5 - low, ---, magnus, NEW , Remove support for NORMARC
20:38 Joubu      heh, good :)
21:28 rangi      oh cool :)
21:30 cait       hm?
21:34 wizzyrea   ooh, do they not use normarc anymore?
21:34 wizzyrea   or do they do like, bibframe now
21:36 cait       marc21
21:37 wizzyrea   neat
22:00 eythian    https://mpsh.ru/25406-ukrainka-o-novoy-zelandii-v-carstve-narkomanii-i-leni-zhit-nevozmozhno.html <-- wizzyrea, now you know what to expect from your move to NZ
22:02 wizzyrea   everything will be in russian?
22:05 wizzyrea   hm.
22:05 eythian    Volcanos, snakes, etc.
22:13 jenkins    Project Koha_Master_D8 build #228: STILL UNSTABLE in 2 hr 0 min: https://jenkins.koha-community.org/job/Koha_Master_D8/228/
22:13 jenkins    * Jonathan Druart: Bug 18982: Use KOHA_INTRANET_URL instead of syspref staffClientBaseURL
22:13 jenkins    * Jonathan Druart: Bug 18982: category.categorycode must be uppercase
22:13 jenkins    * Jonathan Druart: Bug 18982: Create a specific itemtype for these tests
22:13 jenkins    * Jonathan Druart: Bug 18982: Create a circ rule for the data we created
22:13 huginn     04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18982 normal, P5 - low, ---, jonathan.druart, Pushed to Master , selenium tests needs too many prerequisites