IRC log for #koha, 2017-07-25

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:02 wizzyrea https://bugs.koha-community.or[…]_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.or[…].cgi?id=17698#c24
00:04 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 DBI->trace(2);
00:06 my $check_category = Koha::Patron::Categories->find( $categorycode );
00:06 DBI->trace(0);
00:06 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 C4::Context->dbh->trace(2);
00:08 ..that syntax works too
00:10 ..its really handy for WTF sql bugs
00:11 mtompset boy it is noisy.
00:12 But I'm not sure I can make sense of it.
00:13 It seems to have gotten the correct SQL query built.
00:13 Binding parameters: SELECT COUNT( * ) FROM `categories` `me` WHERE ( `categorycode` = 'CPL' )
00:14 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 "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 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/[…]ml#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 .. which removes that referer/url noise
00:30 trace(1) looks better
00:30 mtompset that aside... any ideas?
00:31 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 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)
00:41 Francesca joined #koha
00:45 Francesca joined #koha
00:50 Francesca joined #koha
01:11 dcook joined #koha
01:30 Francesca joined #koha
01:31 Francesca joined #koha
01:34 Francesca joined #koha
02:04 Francesca joined #koha
02:59 JoshB joined #koha
03:23 Francesca joined #koha
05:35 cait joined #koha
05:37 Scott-CSPL joined #koha
06:19 LibraryClaire joined #koha
06:47 AndrewIsh joined #koha
06:52 paul_p joined #koha
06:53 laurence joined #koha
07:01 fridolin joined #koha
07:22 sophie_m joined #koha
07:24 greenjimll joined #koha
07:35 cait joined #koha
07:37 gaetan_B joined #koha
07:37 gaetan_B hello
07:43 * cait waves
07:43 cait good morning #koha
09:14 eddie joined #koha
09:52 * kidclamp waves
10:01 eythian hi
10:25 fridolin joined #koha
10:37 Francesca joined #koha
11:19 caboose joined #koha
11:24 JesseM joined #koha
11:27 meliss joined #koha
12:08 nengard joined #koha
12:11 edveal joined #koha
12:28 jzairo joined #koha
12:29 talljoy joined #koha
12:34 LeeJ joined #koha
12:34 * LeeJ waves
12:34 LeeJ morning #koha
12:36 * LeeJ settles into his new office
12:38 kellym joined #koha
12:41 Joubu hi #koha
12:42 khall joined #koha
12:45 JesseM hi Joubu
12:47 LeeJ hi to everyone!
12:47 gerundio joined #koha
12:50 edveal joined #koha
12:54 marcelr joined #koha
12:54 marcelr hi #koha
13:03 LeeJ hi marcelr
13:03 marcelr hey LeeJ
13:09 kmlussier joined #koha
13:15 Dyrcona joined #koha
13:17 NateC joined #koha
13:17 gerundio hi everyone
13:19 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 25G worth of "inventory.pl: Use of uninitialized value in string eq at /usr/share/koha/intranet/c​gi-bin/tools/inventory.pl line 326" in 2.5h
13:21 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 I just stopped the zebra process and things seems calmer now
13:26 meliss joined #koha
13:26 gerundio any idea what could be behind this behavior?
13:33 cait we recenty had a dateformat problem with inventory
13:33 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 New commit(s) kohagit: Bug 17829: Fix import patron <http://git.koha-community.org/[…]6494816ecaeedb200>
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
13:46 AdamB_ joined #koha
13:49 kellym joined #koha
13:58 jac joined #koha
14:09 Joubu cait: so, what's next? :)
14:09 cait sorry, didn't check today
14:09 any movement on the bugs?
14:10 i think next is pushing, backporting... and a clean-up script/instructions
14:10 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[…]_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 but i think issues is the most important
14:10 i'd agree
14:10 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 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 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 I'll test that with reboot
14:18 I've had today the same issue with old_reserves
14:18 huggly bug
14:21 cait yes, we have seen it in 3.22 too with reserves
14:21 but it fails silently
14:21 just in the logs
14:22 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 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:31 LibraryClaire left #koha
14:34 fridolin cait: cleanup_database you mean ?
14:34 i plan to add old_xxx and deleted_xxx
14:35 even statistics
14:35 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 fridolin joined #koha
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 O:-)
14:38 cait we are aiming for a tool to anonymize frequently
14:38 agreed on that point
14:39 but removing the link to borrowers would already help with that
14:39 you can do that from the interface with one of the tools, but I think it would be nicer as a cronjob
14:39 also depetedborrowers
14:39 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 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 concept of how long to store which data... so I thought about it quite a lot
14:41 fridolin yep
14:41 i'm more a datakiller, simple and performant
14:41 most libraries just dont know it exists ;)
14:42 and privacy is always in danger when data exists, even anonymously
14:56 tcohen joined #koha
14:56 cait ours are pretty keen on satistics
14:56 more and more so even
14:56 more pressure on the libraries to deliver reports and numbers
14:56 so i think anonymization could be a good middle ground
14:56 tcohen morning
14:57 cait morning tcohen
14:59 TGoat joined #koha
15:02 Joubu jajm: around?
15:06 jajm Joubu, i'm leaving, sorry
15:06 fridolin left #koha
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[…]_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 :)
15:10 cait have to leave too and work on something non-koha when i get home tonight
15:10 will be back tomorrow
15:10 cait left #koha
15:18 jbeno joined #koha
15:23 laurence left #koha
15:43 greenjimll joined #koha
15:43 jenkins Project Koha_Master_D8 build #227: UNSTABLE in 2 hr 0 min: https://jenkins.koha-community[…]ha_Master_D8/227/
15:43 Jonathan Druart: Bug 17829: Fix import patron
15:43 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=17829 enhancement, P5 - low, ---, jonathan.druart, RESOLVED FIXED, Move GetMember to Koha::Patron
15:48 cait joined #koha
15:55 greenjimll joined #koha
16:17 greenjimll joined #koha
16:20 LeeJ joined #koha
16:20 * LeeJ waves
16:25 CJSHayward joined #koha
16:25 CJSHayward I am interested in installing Koha along the lines outlined in https://web.archive.org/web/20[…]y.org/wiki/Debian rather than bundled with a complete life support system.
16:26 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:35 CJSHayward joined #koha
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:43 edveal joined #koha
16:51 Joubu CJSHayward: you can list the instances with koha-list, the delete them one by one with koha-remove
16:52 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 i.e. jessie-based
17:49 LeeJ anyone have any suggestions how to get jQuery's datetimepicker to function in the OPAC?
17:49 for a plugin
17:54 cait hm
17:54 you need the time part, right?
17:55 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 https://github.com/bywatersolu[…]ng-hard-due-dates
17:58 or kitchen sink maybe: https://github.com/bywatersolu[…]ugin-kitchen-sink
17:58 when in doubt - copy and paste :D
18:06 LeeJ kidClamp++ # for having his thinking cap on today when I don't
18:07 kidClamp: ahhh...looks like rolling hard due dates uses calendar.inc
19:08 jbeno1 joined #koha
20:05 huginn New commit(s) kohagit: Bug 18982: Create a circ rule for the data we created <http://git.koha-community.org/[…]ed1067ed61f822a4b> / Bug 18982: Create a specific itemtype for these tests <http://git.koha-community.org/[…]2e59e90daa1b1524a> / Bug 18982: category.categorycode must be uppercase <http://git.koha-community.org/gitweb/?p=koha.git;
20:18 CJSHayward_ joined #koha
20:35 cait Joubu: bug 18984 - interesting!
20:35 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18984 enhancement, P5 - low, ---, magnus, NEW , Remove support for NORMARC
20:38 Joubu heh, good :)
20:41 edveal_ joined #koha
20:44 edveal joined #koha
20:48 edveal joined #koha
21:28 rangi oh cool :)
21:30 cait hm?
21:34 wizzyrea ooh, do they not use normarc anymore?
21:34 or do they do like, bibframe now
21:36 cait marc21
21:37 wizzyrea neat
21:44 JoshB left #koha
21:52 alexbuckley joined #koha
22:00 eythian https://mpsh.ru/25406-ukrainka[…]-nevozmozhno.html <-- wizzyrea, now you know what to expect from your move to NZ
22:02 wizzyrea everything will be in russian?
22:05 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[…]ha_Master_D8/228/
22:13 * Jonathan Druart: Bug 18982: Use KOHA_INTRANET_URL instead of syspref staffClientBaseURL
22:13 * Jonathan Druart: Bug 18982: category.categorycode must be uppercase
22:13 * Jonathan Druart: Bug 18982: Create a specific itemtype for these tests
22:13 * Jonathan Druart: Bug 18982: Create a circ rule for the data we created
22:13 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=18982 normal, P5 - low, ---, jonathan.druart, Pushed to Master , selenium tests needs too many prerequisites
22:53 lisettelatah joined #koha
23:03 jac joined #koha
23:22 edveal joined #koha
23:59 Francesca joined #koha

← Previous day | Today | Next day → | Search | Index

koha1