Time  Nick          Message
23:59 cait1         thx :)
23:56 kidclamp_away have a good night
23:56 kidclamp_away :-D
23:56 kidclamp_away go to bed cait!
23:55 cait1         probably tomorrow, time to sleep
23:55 kidclamp_away lemme know when you are done and I will fix those
23:54 cait1         i think we fixed it and it was merged back in
23:54 cait1         but that's all from code review, so still pretty good :)
23:54 kidclamp_away that's one of my words I always mess up
23:54 cait1         recieved in a comment
23:54 cait1         and you reintroduced a typo ;)
23:53 kidclamp_away hah
23:42 mtompset      cait1: I believe you are correct.
23:36 cait1         should t/db_dependent/Koha/Acquisition/Basket.pm not be Basket.t?
23:36 cait1         kidclamp_away: maybe you will wan tto take that karma back - I am taking another look at bug 15685
23:07 cait1         huh?
23:07 kidclamp_away :-)
23:06 kidclamp_away cait++
23:06 kidclamp_away cait++
23:06 kidclamp_away cait++
22:11 Joubu         bye #koha!
22:08 mtompset      Ah, okay. Because my fall-back for blame is caching. It's all caching's fault. :)
22:05 Joubu         There is a env var SLOW_SERVER (set on jenkins) that can be checked, to skip these kind of tests. But it's sad
22:04 Joubu         slowly
22:04 Joubu         tests have been executed too slow, it compares now with now - 1s => They differ, the test fails
22:02 mtompset      Joubu: Then what is "not ok 5 - borrowers.updated_on should have been set to now on creating" for t_db_dependent_Patrons_t.borrowers.updated_on should have been set to now on creating (184)?
21:52 wizzyrea      hehe
21:52 Joubu         just too slow...
21:52 jenkins       Joubu you may not issue bot commands in this chat!
21:52 Joubu         jenkins: you are stable, stop lying
21:42 jenkins       * Jonathan Druart: Bug 19027 - Circulation rules: Better wording for standard rules for all
21:42 jenkins       * Jonathan Druart: Bug 18985 - SQL reports 'Last edit' and 'Last run' columns sort
21:42 jenkins       * Jonathan Druart: Bug 18941 - C4::Budgets GetBudgetByCode should return active budgets
21:42 jenkins       * Jonathan Druart: Bug 18941 - Unit tests
21:42 jenkins       * Jonathan Druart: Bug 13012: Add more tests
21:42 jenkins       * Jonathan Druart: Bug 13012 - suggestion.suggesteddate should be set to NOW if not defined
21:42 jenkins       * Jonathan Druart: Bug 19071: Fix Members/IssueSlip.t
21:41 jenkins       * Jonathan Druart: Bug 19071: Fix Circulation/issue.t
21:41 jenkins       * Jonathan Druart: Bug 19070: Fix Circulation/Branch.t
21:41 jenkins       * Jonathan Druart: Bug 19073: (bug 15758 follow-up) Dereference correct value from
21:41 jenkins       * Jonathan Druart: Bug 19074: Do not crash if cardnumber does not exist
21:41 jenkins       * Jonathan Druart: Bug 19074: Fix category display in Batch patron modification.
21:41 jenkins       * Jonathan Druart: Bug 18555: (QA-Followup) Remove duplicate code
21:41 jenkins       * Jonathan Druart: Bug 18555: Create patron list from patron import
21:41 jenkins       * Jonathan Druart: Bug 19047: Fix AddBiblio call in ShelfBrowser.t
21:41 jenkins       * Jonathan Druart: Bug 19047: Fix AddBiblio call in Reserves.t
21:41 jenkins       * Jonathan Druart: Bug 19042: Add mock IndependentBranches=0 for the other test
21:41 jenkins       * Jonathan Druart: Bug 19042: Silence warnings t/db_dependent/Letters.t
21:41 jenkins       Project Koha_Master_D8 build #239: UNSTABLE in 1 hr 58 min: https://jenkins.koha-community.org/job/Koha_Master_D8/239/
21:15 cait          wasn't mozart austrian?
21:14 eythian       @later tell cait those crazy Germans https://youtu.be/3In4aG2Lq6E
20:26 rangi         vendor_list--
20:26 rangi         and now im done
20:22 fjcosta       i,d better read OPAC rules, thanks for the clue
20:18 pianohacker   fjcosta: if the materials are checked out in some way, you can use the circulation rules to limit, say, type I patrons to 0 total checkouts for type II and III material.
20:16 fjcosta       thanks for replying
20:16 fjcosta       that my doubt
20:16 fjcosta       no material inside the library yet
20:15 fjcosta       actually i've just installed koha and create a library, the admin and the 3 types of patrons
20:04 pianohacker   fjcosta: are these materials checked out before being accessed, or available from the OPAC?
20:00 fjcosta       Would someone kindly help me. What is the easiest way establishing 3 different types of patrons (readers): I, II e III, each with different permissions to acces/read material, defined as to type of material (books, pdf, audio, ...): patron type I can access only type I material; patron type II can access  type I and II material, and patron type III can access type I, II, and III materials. Thank you very much
19:07 MichaelKuhn   Thank you very much! It's not that important, I'll try it here again at another time
19:06 pianohacker   MichaelKuhn: tcohen isn't here at the moment, unfortunately; it might be best to file an issue on kohadevbox or ask on the mailing list
19:03 MichaelKuhn   (sorry for my writing mistakes, ups)
19:03 fjcosta       would anyone  Would someone kindly help me. What is the easiest way establishing 3 different types of patrons (readers): I, II e III, each with different permissions to acces/read material, defined as to type of material (books, pdf, audio, ...): patron type I can access only type I material; patron type II can access  type I and II material, and patron type III can access type I, II, and III materials. Thank you very much
19:02 MichaelKuhn   cait already told me about https://github.com/digibib/kohadevbox/issues/213 but Installaing 0.67 doesn't help a thing...
19:02 MichaelKuhn   This is followed by "PLAY RECAP ********************************************************************* jessie                     : ok=30   changed=2    unreachable=0    failed=1     Ansible failed to complete successfully. Any error output should be visible above. Please fix these errors and try again."
19:02 MichaelKuhn   Hi Tomas, wehen trying to install the buld the kohadebox, the process ends with "TASK [kohadevbox : Install Koha | Install older JSON::Validator (jessie)] ****** fatal: [jessie]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to install package: E:Could not open file http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/libjson-validator-perl_0.67+dfsg-1~koha1_all.deb - open (2: No such file or directory), E:Unable
19:01 Joubu         stupid jenkins
19:01 jenkins       * Jonathan Druart: Bug 18900: wrong number format in receiving order
19:01 jenkins       * Jonathan Druart: Bug 18900: (QA followup) Make tests conditional to locale existence
19:01 jenkins       * Jonathan Druart: Bug 18900: add UT to Number/Price.t
19:01 jenkins       * Jonathan Druart: Bug 5471: Use uri_escape_utf8 to handle utf8 chars correctly
19:01 jenkins       * Jonathan Druart: Bug 5471 - Quotes in tags fail
19:01 jenkins       * Jonathan Druart: Bug 18980: Show distinction between shared and private lists in staff
19:01 jenkins       * Jonathan Druart: Bug 18980: Remove js function Check from opac-shelves
19:01 jenkins       * Jonathan Druart: Bug 18980: Add js to dynamically show/hide the Anyone remark
19:01 jenkins       * Jonathan Druart: Bug 18980: Add remark next to "Anyone seeing this list" permission
19:01 jenkins       * Jonathan Druart: Bug 18857 - Add buttons to left hand side of circ rules table
19:01 jenkins       * Jonathan Druart: Bug 19067: Test Makefile.PL mapping
19:01 jenkins       * Jonathan Druart: Bug 19067: Map clubs/ into INTRANET_CGI_DIR in Makefile.PL
19:01 jenkins       Project Koha_Master_D8 build #238: FIXED in 2 hr 3 min: https://jenkins.koha-community.org/job/Koha_Master_D8/238/
19:01 wahanui       o/ '`'`'`'`'`'`'`'`'`
19:01 jenkins       Yippee, build fixed!
19:00 wahanui       For now...
19:00 Joubu         fjcosta: it works!
18:56 fjcosta       test
18:52 LeeJ          take care #koha
18:52 LeeJ          bug submitted! Now back to working on the project. Will be on tomorrow afternoon
18:51 LeeJ          alrighty
18:44 LeeJ          Joubu: will do..thank you very much as always!
18:38 Joubu         bug*
18:38 Joubu         LeeJ: just describe the bugs and assign it to me
18:37 LeeJ          Joubu: okay..what would be a concise description of the problem? Not sure how it should be phrased
18:36 Joubu         Koha/Plugins.pm
18:35 LeeJ          Joubu: which file is that in?
18:34 pianohacker   excellent!
18:34 pianohacker   sweet
18:34 Joubu         no more (known) cache-related bugs :)
18:34 Joubu         pianohacker: pretty good :)
18:34 * LeeJ        waves to cait
18:33 pianohacker   oh, come to think of it, how has the Plack caching stuff we spent so much work on been behaving?
18:33 Joubu         s/At run time, //
18:33 Joubu         we should check the existence of the directory as well
18:33 Joubu         I guess. At run time, they are loaded once, then stay loaded
18:32 Joubu         77         if ( can_load( modules => { $plugin_class => undef } ) ) {
18:32 Joubu         it's caused by:
18:32 * cait        waves!
18:32 Joubu         heh yes, you can open a bug report
18:31 LeeJ          thank you Joubu..it makes me want to pull my hair out because I'm on a deadline and it's causing more headaches :(
18:30 pianohacker   hi Joubu!
18:30 Joubu         hi pianohacker !
18:30 Joubu         lemme check
18:30 pianohacker   hi LeeJ :)
18:29 * LeeJ        waves to pianohacker
18:29 pianohacker   helloooooooo
18:28 LeeJ          I don't understand how in the world that's causing a problem
18:24 LeeJ          because just running sudo koha-plack --restart kohadev then checking the list cleared it away
18:23 LeeJ          however, now it appears it's actually plack causing a problem
18:23 LeeJ          so my first thought was cache related
18:23 LeeJ          I'm working on a custom plugin for work and when I try to uninstall a plugin on master it remains on the plugins list until I run restart_all
18:22 Joubu         why do you want to disable memcached? :)
18:15 LeeJ          Joubu: is that documented on the wiki? couldn't find it during a search
18:15 LeeJ          Joubu: thank you as always
18:12 Joubu         then restart plack
18:12 Joubu         sudo service memcached stop
18:11 LeeJ          how would one go about disabling memcached? having trouble with a plugin I wrote not disappearing from the list when I click uninstall (unless I run restart_all) and it doesn't appear my inserted tables get dropped either
18:08 LeeJ          hi #koha
17:08 oleonard      Always interesting to get a Google result from the #koha log when trying to solve problems
17:02 oleonard      I guess that implies that there is some sort of connection
17:02 oleonard      Is the fact that the error I'm getting is "Proxy Error" a clue?
17:00 * tcohen      thinks
17:00 tcohen        1.9.7 is the latest
16:59 tcohen        oleonard: try upgrading vagrant
16:59 oleonard      Vagrant said 5.0.10 was a known compatible version
16:59 oleonard      I installed that version because vagrant was not recognizing my installed virtualbox and was trying to install one itself.
16:58 tcohen        maybe it had the same bug
16:58 oleonard      ?
16:58 tcohen        maybe 5.0.10 matches the Vbox generation?
16:57 tcohen        Vbox 5.1.22 had internal networking issues
16:57 oleonard      Vbox 5.0.10, Vagrant 1.8.4.
16:56 tcohen        oleonard: Vbox 5.1.22?
16:52 oleonard      Anyone have any suggestions for diagnosing connection problems with kohadevbox? tcohen?
16:48 KotH          is there a reason, why the label creator does not support code128 in the drop down box? (the underlying code would support it)
16:34 Joubu         with adblock enabled, the #share_list element is hidden
16:34 Joubu         something very weird: /cgi-bin/koha/opac-shareshelf.pl?op=invite&shelfnumber=16
16:32 mtompset      proxy error? That is a strange thing to get.
16:05 oleonard      Anyone know why I might get "proxy error" when trying to access a newly-upped devbox?
15:58 oleonard      bot down!
15:58 mtompset      Have we lost a bot?
15:57 mtompset      @seen aleisha
15:37 mtompset      Hello.
15:36 wahanui       it has been said that mtompset is back to working on Koha stuff for a bit.
15:36 Guest1969     heya mtompset
15:36 mtompset      Joubu: People run the craziest things.
15:15 Joubu         v3.0.6, really?
15:03 cait          josef_moravec++ :)
14:55 mtompset      Greetings, josef_moravec
14:54 josef_moravec hi mtompset
14:54 mtompset      Greetings, #koha.
14:44 * cait        sends a big hammer
14:42 oleonard      ...and then of course this "install" process never completes.
14:39 * cait        sends cookies
14:39 oleonard      That's a rhetorical question because I'm on Windows and must suffer alone.
14:38 oleonard      Why is 'vagrant up' trying to install Virtualbox when it's already installed?
14:05 * oleonard    grumble grumble vagrant grumble
14:05 Joubu         cait: by you? :)
14:01 cait          Joubu: 18331 signed off!
13:53 * tcohen      neither
13:52 cait          and we could download it... so not sure that's it
13:52 cait          he said the same error
13:51 cait          i did
13:51 cait          wonder what it could be
13:51 tcohen        please tell michael to reprovision, maybe it was a temporary networking issue
13:51 tcohen        cait: it doesn't fail for me (JSON::Validator)
13:15 * cait        waves
13:12 marcelr       hi Joubu
13:10 Joubu         Hi #koha
13:01 magnuse       khall++
12:59 cait          :)
12:59 marcelr       thx khall_dnd++
12:59 khall_dnd     marcelr: looks good! pqa!
12:45 cait          maybe it's time for late lunch
12:45 cait          trying to test bug 18331 but losing focus
12:25 * cait        sends mate
12:25 cait          tcohen: and good morning :)
12:23 tcohen        ok
12:22 cait          was here earlier, might reach out to you
12:22 tcohen        I haven't reached the office to try myself
12:22 cait          tcohen: MichaelKuhn ran into the problem with the json library too, we couldn't fix it together
12:18 marcelr       wait for my latest patches
12:18 marcelr       not yet at least
12:18 marcelr       no biblio records tcohen
12:18 * tcohen      was worried of data
12:17 marcelr       too much in SO
12:17 tcohen        marcelr: records broken?
12:17 magnuse       kia ora tcohen
12:14 marcelr       koha records are broken
12:13 marcelr       146 in SO
12:12 marcelr       hola tcohen
12:11 tcohen        morning
12:08 magnuse       20000 before you know it, cait
11:58 cait          it seems like 19000 was just a few days ago... already 1907x now, we go up fast
11:58 cait          but it works :)
11:58 cait          atheia: i think you could probably have used t TT plugin too
11:56 atheia        wheee :-)
11:56 cait          :)
11:55 cait          atheia: 17073 done
11:55 marcelr       you could always come back, cait
11:55 cait          wonder when that will go away
11:55 * cait        still has the urge to set pqa instead of signed off...
11:55 marcelr       would be great
11:55 cait          khall_dnd: it sould apply to your interests :)
11:55 khall_dnd     sure!
11:54 cait          having them in before 15th would be ideal
11:54 marcelr       hey khall_dnd could you qa bug 19049 (to_marc plugins)
11:54 cait          marcelr: yep, hoping the same
11:54 khall_dnd     what's up?
11:54 marcelr       khall_dnd around?
11:53 marcelr       hope we can backport them soon
11:53 cait          thx for fixing the regression - marcelr++
11:50 cait          like a charm
11:50 marcelr       so the test worked now?
11:50 marcelr       cait++
11:50 wahanui       signing off is probably a great idea! or at http://wiki.koha-community.org/wiki/Sign_off_on_patches
11:50 cait          marcelr: signing off
11:48 cait          real mountain or just the ILL tests?
11:47 atheia        cait would love to, but should probably stop procrastinating and do climb this mountain right here…
11:47 cait          ;)
11:45 cait          atheia: i got some more bugs filed...
11:43 endmar        fine
11:40 ashimema      atheia++
11:40 cait          i have on idea about your prolbem
11:40 cait          endmar: maybe best to try th emailing list
11:40 cait          hi rsantellan
11:40 cait          atheia: you are on a roll today :)
11:39 atheia        cait — cosmetics (19074): have pushed a patch there too.
11:38 rsantellan    good morning #koha
11:28 endmar        relayhost = smtp.gmail.com::587 smtp_sasl_auth_enable = yes smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd smtp_sasl_security_options = noanonymous smtp_tls_CAfile = /etc/postfix/cacert.pem smtp_use_tls = yes myorigin = /etc/mailname mydestination = 172.27.44.29 mailbox_size_limit = 0 recipient_delimiter = + inet_interfaces = all inet_protocols = ipv4 default_transport = smtp relay_transport = smtp mynetworks = 127.0.0.0/8
11:28 endmar        Hi All, Here is the settings on the mail.cf
11:11 marcelr       we need it for qa too
11:11 cait          marcelr: no worries, wouldn't have stopped me :)
11:10 marcelr       cait: the pod coverage warning is false; will add a note about that one
11:10 cait          thx!
11:10 atheia        OK 19073 is now ready for sign off.
11:08 cait          74 is just cosmetics
11:08 cait          yes, 19073 is the important one
11:07 atheia        hah, OK will fix :-)
11:07 cait          let me check
11:07 cait          i filed 2 bugs
11:07 cait          bug 19073
11:07 cait          will finish with the one i am working on and then go back there
11:06 atheia        Argh… I misunderstood! You hadn't filed 19074 for the branchcode issue?
11:06 cait          thx
11:06 marcelr       cait: the follow-up should handle the unit test
10:58 cait          scary
10:58 cait          wow
10:58 atheia        Yeah looks like a Feb 2016 refactor introduced the bug… so it's been there for a year and a half… not bad :-)
10:55 cait          parameters not passed on
10:54 cait          i wondered if it was something like that
10:54 atheia        Problem was that branchcode values in the select weren't set.
10:54 cait          thx atheia
10:54 cait          cool!
10:54 atheia        cait: got a fix for 19074.  Will upload a patch to the bug
10:51 marcelr       working on it now
10:51 cait          almost ready to sign off
10:51 cait          marcelr: let me know when the patch is up
10:50 endmar        Okay
10:50 cait          endmar: that was for me
10:49 endmar        How can I do that?
10:49 marcelr       the bug in the test is a relative path problem
10:49 marcelr       you could write one for excel and another for ...
10:49 marcelr       you can have miltiple to_marc and you have to choose
10:48 endmar        is coming through my gmail account
10:48 cait          i think a side effect of this is tht you could have mulitple plugins installed?
10:48 endmar        Cron <swebshet@swebshet> my_library_koha/usr/share/koha/bin/cronjobs/process_message_queue.pl
10:47 marcelr       luckily
10:47 cait          but htat's out of scope :)
10:47 cait          it handles unmapped columns a bit oddly
10:47 cait          yep it does
10:47 marcelr       haha
10:46 wahanui       However, now everything else is broken.
10:46 marcelr       it works
10:46 cait          keep fingers crossed
10:46 marcelr       yeah
10:46 cait          anyway, will try to load m file now
10:46 cait          checking the name of the plugin? seems a bit overcomplicated for cosmetics
10:46 marcelr       i could remove it conditionally?
10:45 cait          maybe just scratch plugin
10:45 cait          plugin is part of the name
10:45 cait          ah i see
10:45 cait          hm sec
10:44 wahanui       well, any suggestion is great
10:44 marcelr       any suggestion?
10:44 cait          plugin is a bit doubled up :)
10:44 cait          Other formats, handled by plugin CSV2MARC plugin
10:44 marcelr       you mean?
10:44 cait          can you change the pull down?
10:44 marcelr       yes it is only the unit test
10:44 cait          while you are on it
10:44 cait          does it make sense to continue testing?
10:44 cait          ok
10:43 marcelr       ah cait: i can reproduce, fix coming
10:42 marcelr       t::lib::Mocks::mock_config( 'pluginsdir', dirname(__FILE__) . '/..' );
10:41 marcelr       it is looking in the t subdir
10:41 marcelr       yeah but for the test that does not matter
10:41 cait          is my plugin directory
10:40 cait          <pluginsdir>/var/lib/koha/kohadev/plugins</pluginsdir>
10:40 marcelr       i saw some of these things before with devbox
10:40 cait          I will continue testing, just installed Kyle's csv to marc plugin
10:40 marcelr       it is not found, but is it looking in the right dir ?
10:40 cait          it's hard to tell for me
10:39 marcelr       where it should find a module for a plugin
10:39 kidclamp      hi cait
10:39 marcelr       no the test adds a dir to pluginsdir
10:39 cait          hm no plugins installed by default?
10:39 marcelr       you do not find the plugin
10:39 cait          marcelr: dunno
10:38 marcelr       cait: 19049 might be a dev setup issue ?
10:38 cait          bug numbers are never going down that way...
10:38 cait          atheia: the second test led me to filing bug 19074
10:37 cait          hi kidclamp!
10:37 cait          both seem to work ok
10:37 cait          that's what i see too, tested also with patron category and opac onte
10:37 cait          yep
10:34 atheia        It seems to just be ignored…
10:33 atheia        I just did a test for batch patron modification: changing first name & clearing city worked, but changing library did not.
10:33 cait          i have a tendency to run into odd bugs testing something entirely else
10:33 wahanui       interesting is sometimes good and sometimes bad
10:33 atheia        cait: interesting
09:59 cait          bug 19073
09:55 cait          it doesn't do it
09:55 cait          I am trying to test a single branch library bug and wanted to shift them all to one brnach
09:55 cait          is batch patron modidfication broken for someone else?
09:54 wahanui       somebody said question was "What is the meaning of life, the universe and everything?"
09:54 cait          hm ok question
09:47 * cait        should be cleaning the apartment .. but it's too grey
09:46 cait          thx LibraryClaire :)
09:44 LibraryClaire https://giphy.com/gifs/family-guy-fox-family-guy-foxtv-l0HlPwMAzh13pcZ20
09:43 cait          i miss that
09:43 cait          @wunder Konstanz
09:36 magnuse       kumquat it is
09:22 magnuse       +1
09:22 cait          +1
09:19 ashimema      lol
09:18 liw           0 and 1 are such boring, mundane, bourgeois numbers to start counting from. I suggest a range of 12765...kumquat
09:17 magnuse       the gui seems to make 1 the lowest number, but i see plenty of zeros in production dbs
09:15 magnuse       reserves.priority - should it be counting from 0 or 1?
09:02 john          let me check...i will join u after some time...
09:02 cait          so by adding this, you tell it to compare to the date part only
09:02 john          ok..
09:02 cait          issue_date is not actually a date, it's a timestamp witht he hours too
09:02 john          ahaaa!!
09:02 cait          just adding the date (   ... )
09:01 cait          makes it work for me
09:01 cait          ... WHERE  date(c.issuedate)  BETWEEN ..
09:01 john          no..i
09:01 cait          john: did it work?
09:01 cait          you too
09:01 john          ok..guyzz...see u after some time....
09:01 MichaelKuhn   @cait: Thanks! And have a good day!
09:00 cait          so in the afternoon changes are getting better
09:00 cait          he is in Argentina
08:59 MichaelKuhn   @cait: Yes, I want to figure it out, otherweise it's just a waste of time... Do you know if I'll meet Tomas here some time?
08:59 cait          try to change c.issuedate to  date(c.issuedate)
08:59 Guest1943     heya cait
08:59 wahanui       after is what PBP reccomends
08:59 cait          after where
08:59 cait          in the last line
08:57 * ashimema    is in a call now.. if cait's not spotted the issue by the time I come back I'll take a quick look too
08:57 cait          It would be good to figure this out so we can fix either the repo or the kohadevbox
08:57 pastebot      "john" at 192.168.2.4 pasted "SELECT DATE_FORMAT(c.issuedate" (13 lines) at http://paste.koha-community.org/580
08:56 MichaelKuhn   @cait: Thanks anyway! In fact I'm stuck at the exact same point as some months ago when I gave up... This time I will try a little harder.
08:56 cait          it's easier to see the problem
08:56 cait          it's still cut off abit, if you go an dpaste the whole thing to http://paste.koha-community.org
08:54 john          then i give start date and end date same day(today)
08:54 john          WHERE c.issuedate  BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>>  ORDER BY c.issuedate DESC
08:53 john          this is the code i have use- SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date,  i.barcode AS Barcode, b.title AS Title, b.author AS Author,  p.cardnumber AS Card_No, p.firstname AS First_Name,  p.surname AS Last_Name  FROM issues c  LEFT JOIN items i ON (c.itemnumber=i.itemnumber)  LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber)  LEFT JOIN biblio b ON (i.biblionumber=b.biblionumbe
08:53 cait          MichaelKuhn: sorry, i am out of  my league here, maybe tcohen will be able to help you a little later
08:51 KotH          own*
08:51 KotH          wizzyrea: oh.. and koha doesn't require its on VM like all that modern python/ruby/node.js crap out there
08:50 KotH          wizzyrea: getting my label printer working was the most time i've spend with koha since i first installed it
08:49 MichaelKuhn   @cait: After the update it was libjson-validator-perl 0.97, so I had again to install 0.67, but the error is STILL the same.
08:49 KotH          wizzyrea: it's more just following the instructions. i run half a dozen webservices of different kind for myself. koha is one of the most complex pieces of software that i use. yet it just works and doesn't require more than maybe 2h per year in maintenance. stuff like gitlab cost me 2-3h per month
08:49 ashimema      what she said
08:48 ashimema      :)
08:48 cait          can you use paste.koha-community.org to share please?
08:48 ashimema      can you use the paste above to paste the whole sql in john.. the last bit of it got missed ;)
08:48 cait          hm it's cut off at the end
08:48 john          ok
08:48 cait          hm let my try that for a second
08:46 john          but i have checked out 5 books today
08:46 cait          MichaelKuhn: it' sreally odd about the error, i had thorught it would have gone away now, it worked for me
08:46 john          ya
08:46 wahanui       no result is shown
08:46 john          but no result
08:45 john          i need how much of books check out today....i used these sql codes (SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date,  i.barcode AS Barcode, b.title AS Title, b.author AS Author,  p.cardnumber AS Card_No, p.firstname AS First_Name,  p.surname AS Last_Name  FROM issues c  LEFT JOIN items i ON (c.itemnumber=i.itemnumber)  LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber)  LEFT JOIN bi
08:45 cait          hm
08:45 MichaelKuhn   @john: Yes, the package was to solve my problem with the kohadevbox
08:44 ashimema      what report are you running john
08:44 john          ohhh..!!!
08:43 ashimema      I think the package was for MichaelKuhn not your john
08:43 MichaelKuhn   @cait: Still the same error. But when calling "vagrant up --provision" ist says there is a new newer version of the box 'debian/jessie64', so I'm now just running "vagrant box update".
08:43 john          @cait i  installed pakege u have given..and checked with today report..but shows empty again..!!
08:41 john          ya
08:40 cait          i was hoping the bot had saved the link
08:40 cait          https://wiki.koha-community.org/wiki/SQL_Reports_Circulation
08:40 john          yes cait
08:40 cait          hm sec
08:40 cait          koha reports?
08:40 john          i mean link
08:40 john          please give me the koha report referance page
08:39 cait          looking here, the older one was at the bottom http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/
08:38 MichaelKuhn   @cait: You're probably right. I could have noted that also!
08:38 cait          it might be not so clever to recognize that as a newer version
08:38 cait          and we had 0.97 earlier
08:38 cait          could you try to install againw ith that other link? it seems it asks for 0.67
08:38 MichaelKuhn   PLAY RECAP ********************************************************************* jessie                     : ok=30   changed=2    unreachable=0    failed=1     Ansible failed to complete successfully. Any error output should be visible above. Please fix these errors and try again.
08:38 MichaelKuhn   TASK [kohadevbox : Install Koha | Install older JSON::Validator (jessie)] ****** fatal: [jessie]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to install package: E:Could not open file http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/libjson-validator-perl_0.67+dfsg-1~koha1_all.deb - open (2: No such file or directory), E:Unable to determine file size for fd -1 - fstat (9: Bad file descriptor), E:Read error -
08:38 MichaelKuhn   @cait: Instead of "vagrant provison" (as Tomas wrote) I now wrote "vagrant up --provision" (as you wrote) - same error again...:
08:36 cait          it might be that we got the wrong one
08:36 cait          http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/libjson-validator-perl_0.67+dfsg-1~koha1_all.deb
08:36 cait          i tihnk it might be my fault, I just noticed there is a package for another version there too
08:36 cait          hm can you share it again?
08:36 MichaelKuhn   @cait: No... :-( it shows exactly the same error again...
08:34 ashimema      cait++
08:34 ashimema      :)
08:34 MichaelKuhn   @cait: Thank you very much! According to Tomas I now just executed "vagrant provision" and the process is running again now.
08:32 cait          iam not sure if you shoudl do a vagrant halt to shut it down first before you up it again, but it will probably tell you
08:32 cait          and then vagrant up --provision - if you have used SYNC_REPO or something before add that too of course
08:31 cait          exit
08:31 cait          now you exit
08:31 cait          good
08:31 MichaelKuhn   @cait: Yes, exactly: "sudo dpkg -i libjson-validator-perl_0.97-1~kohadev1_all.deb" - I did that and it worked. It doesn't ask for a password.
08:29 ashimema      :)
08:29 cait          someone might correct me if i am wrong :)
08:29 cait          and then i think it's.... sudo dpkg -i file ?
08:27 cait          use the wget to get the package
08:27 cait          now you are inside the devbox
08:27 cait          yep
08:27 MichaelKuhn   @cait: "vagrant ssh" brings me to the prompt saying "vagrant@kohadevbox:~$ "
08:27 cait          and install that
08:27 cait          then you can wget http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/libjson-validator-perl_0.97-1~kohadev1_all.deb
08:26 john          @cait i took report for today but it shows empty
08:26 cait          what happens when you do vagrant ssh?
08:25 MichaelKuhn   @cait: Tomas wrote: "Browse the repo and look for the .deb files you need, install them manually" - what repo does he mean and how to install the deb files manually inside the unfinished kohadvebox?
08:23 cait          john: i suggest finding a report first that works for you on the sql reports page and then take a look at scheduling it as cron with runreport.pl, that will email you every day
08:22 ashimema      but we use runreport.pl with cron cait ;)
08:22 MichaelKuhn   I may be wrong of course (I never really used it myself)
08:22 cait          but i think some deemed it unsafe on server side
08:22 ashimema      hehe
08:22 cait          you coudl make it work
08:22 ashimema      mmm.. the menu always has.. but the feature was broken for a very long time last I looked
08:21 cait          i think most are using runreport.pl
08:21 MichaelKuhn   @ashimema: Yes, the menu looks as if it is able to do that
08:21 cait          hm not to my knowledge
08:21 ashimema      does the task scheduler work these days for recurring tasks then?
08:21 MichaelKuhn   I had the same problem some months ago, but noone could help, so I gave up at this moment
08:21 cait          https://github.com/digibib/kohadevbox/issues/213
08:20 cait          what you can do - do vagrant ssh, download the package, install it, and then provision, worked for me
08:19 cait          i thought it had been fixed, guess it's back
08:19 cait          hi MichaelKuhn - there is an issue for that on the kohadevbox tracker, one sec
08:18 MichaelKuhn   You could go to Koha menu "Reports" and create such a report, then go to Koha menu "Tools > Task scheduler" - there you have the possibility to run a report at a given time (though I have never used that myself)
08:18 magnuse       john: have you looked at https://wiki.koha-community.org/wiki/SQL_Reports_Circulation
08:17 john          how much books issued and returned
08:16 john          i need daily issue and return report
08:15 MichaelKuhn   Hi John, what daily report you want to take exactly?
08:15 MichaelKuhn   How can I fix this error?
08:15 MichaelKuhn   The process stopped with this message: "PLAY RECAP ********************************************************************* jessie                     : ok=30   changed=18   unreachable=0    failed=1     Ansible failed to complete successfully. Any error output should be visible above. Please fix these errors and try again."
08:14 MichaelKuhn   Hi - I want to install a kohadevbox to possibly be able to make signoffs in the future. Howerv, after waiting for about two hours, the following message appeared: "TASK [kohadevbox : Install Koha | Install older JSON::Validator (jessie)] ****** fatal: [jessie]: FAILED! => {"changed": false, "failed": true, "msg": "Unable to install package: E:Could not open file http://debian.koha-community.org/koha/pool/main/libj/libjson-validator-perl/libjson-valida
08:14 john          pls
08:14 john          can anybody help me--how to take daily report from koha
08:13 john          am back
08:13 john          hiiii
07:52 ashimema      hehe
07:51 * magnuse     scrambles
07:50 cait          btw still waiting for manual submissions from all of you! ;)
07:50 * magnuse     would totally vote for cait as rm
07:50 marcelr       cait for RM !
07:49 cait          nah
07:49 magnuse       one day...
07:49 cait          release maintainer
07:49 cait          arg
07:49 magnuse       cait++
07:49 cait          I think I find enough to do with documentation team and release manager, thx :)
07:49 magnuse       except i don't think she would do that as long as she is rmaint, reduce the number of eyeballs...
07:48 ashimema      think she's deserves an honorary place on the qa team forever ;)
07:48 ashimema      lol.. I'm sure no-one would bat an eye lid at cait doing a qa ;)
07:48 cait          not just refusing
07:47 cait          no longer on the QA team
07:47 atheia        ah, well fair play — I'll need to badger others…
07:47 cait          can't do that :)
07:47 magnuse       woohoo! :-)
07:47 atheia        Well, now we need QA :-D
07:46 cait          atheia: I saw you marked stock rotation signed off, so don't need me :)
07:46 cait          good we get to keep you at least :)
07:46 atheia        So I should be relatively unaffected by this change :-)
07:45 atheia        I am still scheduled to continue work as normal — I am by and large marginal to the enormous work that Andrew and Martin have put in for Rebus List
07:44 magnuse       please let atheia write those tests before he too becomes unavailable for 6 months? :-)
07:44 magnuse       yeah, i saw that and was afraid it would have that effect...
07:43 ashimema      we should really put on that page what continents are forbidden from bidding
07:42 ashimema      https://twitter.com/Kortext1/status/895241370008526848 means I'm tied up for the next 6 months on non-koha stuff unfortunately
07:42 magnuse       only one proposal on https://wiki.koha-community.org/wiki/KohaCon18_Proposals
07:41 magnuse       marseille is probably not until next year?
07:40 * ashimema    thinks it's unlikely he'll be making hackfest this year
07:40 magnuse       rumour says there will be a hackfest in sweden this fall...
07:40 magnuse       hiya ashimema
07:40 magnuse       too long...
07:40 magnuse       hm, how far are we from the next hackfest in marseille?
07:40 ashimema      mornin' #koha
07:40 cait          :)
07:40 * cait        waves
07:40 wahanui       kamelåså
07:40 LibraryClaire hi magnuse
07:39 magnuse       and hiya BüchereiKlara
07:39 magnuse       kia ora cait!
07:39 john          ok
07:37 magnuse       i didn't do much :-)
07:37 LibraryClaire john you can use the batch item modification tool to edit multiple items at once
07:37 john          thank u magnuse for your great support...!!!
07:36 john          but the problem is..i need to change the location for every item...!!
07:35 john          work fine
07:35 john          i changed the location (main library to my organization library)
07:35 marcelr       o/
07:34 magnuse       hiya marcelr
07:34 magnuse       john: how?
07:34 marcelr       hi #koha
07:34 john          magnuse...bug fixed
07:33 magnuse       john: which version are you using?
07:31 magnuse       https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16824
07:31 magnuse       this is bug 16824, but it does not have any more info, i'm afraid
07:30 john          ok magnuse thank u so muuch..!!
07:30 magnuse       hm, then i'm out of ideas i'm afraid
07:29 magnuse       there should be dropdown menus for both fields
07:29 john          yes it is set us main library..
07:29 magnuse       is permanent location and current location set to valid libraries?
07:28 magnuse       ah, sorry i mean the same thing
07:26 john          no homebranch
07:26 john          @magnuse> on edit item screen there is (permanent location and current location)
07:21 john          ok just a sec i will check
07:21 john          @magnuse there should be, on the edit item screen
07:20 magnuse       there should be, on the edit item screen
07:19 john          @magnuse> there is no field like home branch and holding branch
07:10 magnuse       john: does the item have a value in the fields for homebranch and holdingbranch, and does that value correspond to libraries you have defined in koha?
07:10 john          when i am trying to check out it shows  "No branchcode argument passed to Koha::Calendar->new at /usr/share/koha/lib/C4/Circulation.pm line 3425."
07:09 * magnuse     waves
07:03 wahanui       help is at http://koha-community.org/support/ if no-one here can help.
07:03 john          help!!!!!!!!!!!!!!!!
07:03 john          when i am trying to check out it shows  "No branchcode argument passed to Koha::Calendar->new at /usr/share/koha/lib/C4/Circulation.pm line 3425."
07:00 john          please help me....!!!
06:59 john          when i am trying to check out it shows  "No branchcode argument passed to Koha::Calendar->new at /usr/share/koha/lib/C4/Circulation.pm line 3425."
06:59 john          i have a small error on chckout
06:58 john          am new to koha
06:58 john          hii all
06:55 alex_a        bonjour
03:53 Ami           hi  all
03:40 Guest1940     hi dcook
03:31 dcook         rangi: np :)
03:21 Amit          hi Gm all
03:18 rangi         dcook: ill take a look thanks for heads up
03:08 huginn        dcook: The operation succeeded.
03:08 dcook         @later tell eythian I'm late collecting my messages but thanks for the birthday wishes. I recall it being a nice time ^_^
03:08 huginn        dcook: The operation succeeded.
03:08 dcook         @later tell wizzyrea Just get your message from 3 months ago. Thanks! It did work out!
03:07 dcook         Rather http://git.koha-community.org/stats/koha-master/activity.html
03:07 dcook         Hey rangi, it looks like koha-stats is having some issues. Looks like it's running but that it hasn't picked up anything since June: http://git.koha-community.org/stats/koha-master/index.html