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 127.0.0.1 pasted "Code Snippet" (6 lines) at http://paste.koha-community.org/547 00:17 pastebot "mtompset" at 127.0.0.1 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 127.0.0.1 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 127.0.0.1 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