Time  Nick            Message
19:28 oleonard        Happy weekend #koha
18:39 nuentoter_      oleonard: thank you very much, i currently feel like a buffoon lol my report worked just fine the first time, i simply needed to widen the column in officelibre, hence the ##### columns,
18:36 nuentoter_      hmmmm thats what i had without the space after comma and it didnt pull the title and author i simply got a column of ####
18:35 nuentoter_      i've been slowly stumbling through and self teaching sql, i understand the general makeup and idea and can piece things together, i have been reffering heavily to the reports library but really trying to figure it out on my own and fixing my mistakes as i go
18:35 oleonard        It doesn't matter
18:34 nuentoter_      after comma
18:34 nuentoter_      is there supposed to be a space?
18:33 oleonard        SELECT items.barcode,items.itemcallnumber, biblio.title, biblio.author
18:33 nuentoter_      i had added the biblio.title and author to the end of my first line
18:31 nuentoter_      I added them but it did not produce correctly, I was unsure of where to put that into the code
18:22 oleonard        You want biblio.title and biblio.author
18:22 oleonard        Actually nuentoter_ I see you're already joining biblio and biblioitems...
18:20 oleonard        https://wiki.koha-community.org/wiki/SQL_Reports_Library
18:20 oleonard        nuentoter_: Have you looked at the SQL library?
18:18 nuentoter_      ok back, now my question, i am pulling a report with barcodes(accession numbers) and call numbers but i would like book title and author as well, i do not see where in the items table i can pull this info http://paste.koha-community.org/40?tx=on&submit=Format+it%21
18:05 nuentoter       ok ill be back in a couple minutes with it.. thank you
18:02 huginn          nengard: The current temperature in North Acres, Austin, Texas is 36.0°C (12:57 PM CDT on July 22, 2016). Conditions: Clear. Humidity: 42%. Dew Point: 21.0°C. Pressure: 30.06 in 1018 hPa (Falling).
18:02 nengard         @wunder 78754
18:02 huginn          oleonard: The current temperature in Longview Hts, Athens, Ohio is 35.2°C (2:02 PM EDT on July 22, 2016). Conditions: Scattered Clouds. Humidity: 54%. Dew Point: 25.0°C. Pressure: 30.07 in 1018 hPa (Steady).
18:02 oleonard        @wunder 45701
18:02 oleonard        I think it's best just to throw it out there.
18:02 oleonard        nuentoter: You can wait to ask for permission, or you can just throw out your question and hope for a response
17:50 nuentoter       can someone in here maybe help me out with an sql report? im just starting to learn the proper syntax and can't seem to get what i want right now
17:31 huginn          New commit(s) kohagit: Bug 14793: New cataloguing plugin unimarc_field_225a_bis <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ed61bd9bba8925373241abd9f582c240695f8ce5> / Bug 16945: PatronSelfRegistration: Add note about setting PatronSelfRegistrationDefau... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=856f4426b33ad498bfeed3a58097276e85850bab> / Bug 16906: Simply remove the sDom definition to use the default
17:20 huginn          New commit(s) kohagit: Bug 16715: Proposed followup to use Sereal for serialization <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=66a8c9655079f141c9185aea329435e3a63bbd0a> / Bug 11606: (followup) minor typos <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b7afd4218867ce362f3c140d6dd7ffbceb2eb687> / Bug 11606: Add Novelist client to staff <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ca4f4c668
17:10 huginn          New commit(s) kohagit: Bug 16716: Replaced wrong GROUP BY with DISTINCT <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=52ac9a1ca3990102c3c635e3d9af06aae29f73e1> / Bug 15974: Rancor: Correctly select existing authorized value <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b01aa596abb91f8679c64e89197fbb2b3d9309cc> / Bug 16941: Can not add new patron in staff client <http://git.koha-community.org/gitweb/?p=koha.gi
15:43 gaetan_B        bye
15:06 morgane         bye !
15:04 nengard         you might buy from a small local publisher or 5, a big book jobber or 5, amazon,
15:03 nengard         some of our big libraires have more than 20
15:03 nengard         i thought you mean product vendors :) hehe
15:03 nengard         you mean book vendors?
15:03 oleonard        I'll bet cait has opinions.
15:02 oleonard        nengard: I feel like I spend a lot of time searching for vendors when testing things. I always wonder if it wouldn't be faster to just list them all.
15:02 reiveune        bye
15:02 nengard         oleonard wow ... i want to say more than 10 ...
14:47 oleonard        I wonder what is the most vendors a Koha library has
14:09 morgane         paul_p: ok thanks
14:06 paul_p          morgane no galen here since 10 days. I bet he's in holiday...
14:06 huginn          paul_p: gmcharlt was last seen in #koha 1 week, 2 days, 20 hours, 53 minutes, and 12 seconds ago: <gmcharlt> cait: pong
14:06 paul_p          @seen gmcharlt
14:06 paul_p          morgane = FYI
13:12 drojf           later #koha
12:54 tcohen          drojf: thanks for the insight
12:53 drojf           it actually has memcached, but not libcache-memcached-perl http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=debian/control;h=30d7f87f5eb8a8bded8ac00fa8eb0c512105b256;hb=HEAD#l166
12:52 tcohen          ah, it is still in build-deps
12:51 drojf           which is probably this weekend
12:51 drojf           it's not in there yet. it will be in the next master package
12:51 tcohen          drojf: I'll try that, thanks
12:50 tcohen          and memcached was one of them, due to the high number of devs regarding caching
12:50 tcohen          ftr, kohadevbox installs all the things that could be needed for debugging and developing
12:48 drojf           random internet knowledge i just googled, never tried it
12:48 drojf           apt with --install-suggests should work
12:47 tcohen          i'll dig a bit into it
12:47 tcohen          and suddenly started to break due to the missing dep
12:47 tcohen          kohadevbox pulls koha-perldeps
12:46 drojf           it#s not in there for some reason, but i will put it there
12:46 drojf           automatically, i mean
12:46 drojf           if it is listed as suggested, will that go into kohadevbox?
12:45 tcohen          i'll add libcache-memcache-perl manually in kohadevbox
12:45 drojf           at least not anymore
12:45 drojf           but that does not apply to memcached
12:45 drojf           so you can use it (in jessie) but it would break koha (in wheezy)
12:45 tcohen          yeap
12:45 drojf           we have something similar with youtube, because that was not in wheezy but in jessie
12:44 tcohen          I belive any option that can be set, should not be able to break user's instances
12:44 drojf           it's in all debians we care about. maybe that used to be different
12:44 tcohen          yeah, probably deserves some discussion
12:43 drojf           we could just assume everyone does use one, or not care, or whatever. i don't know if there are historic reasons
12:43 drojf           so it's not needed if you don't
12:42 drojf           it's only used if you declare a memcached server in the config
12:42 tcohen          it should
12:41 tcohen          *but*
12:41 tcohen          it is not marked as mandatory
12:41 tcohen          hi drojf
12:41 drojf           hi tcohen
12:40 wahanui         hello, tcohen
12:40 tcohen          bonjour
12:26 cait            sorry, have to run :(
12:26 cait            probably a bit hard to tell
12:26 cait            i am not sure how people use this
12:23 Joubu           the plugin is the only place where we can combine search on $a only, main heading, all headings, entire record
12:22 Joubu           no, from the header of the auth module
12:22 cait            the one from the opac?
12:21 Joubu           cait: no, just wanted to know if we want to keep the form like that or if we want to replace it with the other authority search
12:21 cait            were you asking if 15 pages is enough?
12:21 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16960 normal, P5 - low, ---, koha-bugs, NEW , Patron::Modifications should be fixed
12:21 cait            ah, i didn't undertand you either :)
12:21 Joubu           oleonard: yep, see bug 16960, khall is on it
12:19 Joubu           cait: k
12:19 cait            i will try to do bug work on sunday
12:18 cait            i have to run in a few minutes to catch my train
12:18 cait            Joubu: can you leave a coment that you don't understand?
12:14 oleonard        patron modification requests from the OPAC are broken in master :(
12:14 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16910 normal, P5 - low, ---, gmcharlt, NEW , Authority search plugin in cataloguing stops at 15 pages
12:14 Joubu           no bug 16910!
12:14 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15758 enhancement, P5 - low, ---, jonathan.druart, Needs Signoff , Move the C4::Branch related code to Koha::Libraries - part 4
12:14 Joubu           cait: I do not understand your comment on bug 15758
12:12 khall           Joubu: pm
12:07 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14757 enhancement, P5 - low, ---, kyle.m.hall, Pushed to Master , Allow the use of Template Toolkit syntax for slips and notices
12:07 Joubu           khall: Hi! See bug 14757, last comment
11:56 cait            oleonard: pianohacker chose desert over beer in berlin and went with me to eat waffles... I sure will miss him.
11:56 cait            yeah boo
11:56 oleonard        Boo, first nengard and now pianohacker. Boo I say.
11:46 oleonard        Hi all
11:21 druthb          drojf!
11:20 drojf           druthb!
11:20 huginn          druthb: The current temperature in Montrose (Mandell Place), Houston, Texas is 26.1°C (6:20 AM CDT on July 22, 2016). Conditions: Clear. Humidity: 94%. Dew Point: 25.0°C. Pressure: 30.05 in 1018 hPa (Rising).
11:20 druthb          @wunder 77098
11:20 huginn          drojf: The current temperature in Berlin Schoenefeld, Germany is 27.0°C (12:50 PM CEST on July 22, 2016). Conditions: Clear. Humidity: 34%. Dew Point: 10.0°C. Pressure: 30.04 in 1017 hPa (Steady).
11:20 drojf           @wunder sxf
11:20 huginn          drojf: The current temperature in Berlin, Germany is 27.4°C (1:00 PM CEST on July 22, 2016). Conditions: Clear. Humidity: 40%. Dew Point: 13.0°C. Pressure: 30.04 in 1017 hPa (Steady).
11:20 drojf           @wunder txl
11:19 drojf           heh
11:19 huginn          drojf: Error: HTTP Error 404: Not Found
11:19 drojf           @wunder ber
11:19 huginn          drojf: The current temperature in Berlin Tegel, Germany is 28.0°C (12:50 PM CEST on July 22, 2016). Conditions: Clear. Humidity: 26%. Dew Point: 7.0°C. Pressure: 30.04 in 1017 hPa (Steady).
11:19 drojf           @wunder berlin, germany
09:56 morgane         Hi gmcharlt, I made a request to have an account on the wiki and cait confirms it but I don't receive the confirmation email with the password. it's normal? how long i have to wait for it?
09:55 huginn          LibraryClaire: The current temperature in London City, United Kingdom is 22.0°C (10:50 AM BST on July 22, 2016). Conditions: Scattered Clouds. Humidity: 64%. Dew Point: 15.0°C. Pressure: 30.06 in 1018 hPa (Steady).
09:55 LibraryClaire   @wunder LCY
09:25 huginn          drojf: The current temperature in Berlin Tegel, Germany is 27.0°C (11:20 AM CEST on July 22, 2016). Conditions: Clear. Humidity: 34%. Dew Point: 10.0°C. Pressure: 30.04 in 1017 hPa (Steady).
09:25 drojf           @wunder berlin, germany
09:16 Joubu           let me know if it persists :)
09:16 marcelr         ok fine will update
09:16 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16008 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , noisy "fatal" warning when new file is moved in another patch
09:16 Joubu           marcelr: what you got should be fixed by     Bug 16008: Deal with removed files
09:16 marcelr         Joubu: probably i am not at the latest commit :)
09:15 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15839 enhancement, P5 - low, ---, jonathan.druart, Failed QA , Move the reviews related code to Koha::Reviews
09:15 Joubu           marcelr: about bug 15839 comment 36, did you fetch the qa tools repo?
09:09 Joubu           marcelr: ok for a die
09:03 marcelr         Joubu: perhaps a die , saw it somehwere else too
09:03 marcelr         oh sorry wrong report
09:03 marcelr         Joubu: the status is null, you only look for a 0
08:44 cait            hm i am not sure
08:41 morgane         cait: I haven't received an email yet, do you think it's normal?
08:25 Joubu           Do you suggest that we should catch it to display a nice warning to a librarian trying to modify the option' values with a non-existing profile_id?
08:25 Joubu           Here the profile_id is passed from a POST form, so it does not appear in the url
08:25 Joubu           We won't manage to catch everything, we will need to assume that records exist
08:24 huginn          04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15451 enhancement, P5 - low, ---, jonathan.druart, Passed QA , Move the CSV related code to Koha::CsvProfile[s]
08:24 Joubu           marcelr: about bug 15451 (find does not return anything). What do you suggest?
08:24 Joubu           marcelr: thanks for your QA work! :)
08:23 morgane         cait: not yet, may be I have to wait a little
08:23 lds             strange
08:23 lds             I restart zebra and all works again.
08:22 lds             hello I have a issue with zebra. Zebra work fine but sometimes zebra indexation dont work and i see in logs: [fatal] default.idx [No such file or directory].
08:22 cait            please check if you got an email
08:22 cait            confirmed the account
08:20 cait            can you pm me the email address used?
08:20 morgane         cait: thanks :)
08:19 cait            morgane: hm sec, i am taking a look if i can see somehting
08:17 morgane         Hi #koha, I made a request to have a wiki account few days ago but I didn't get any response. I just made another one. Somebody can give me the access to the wiki ? I want to edit a page about Mana (my intership project), to keep up to date the community on my progress.
08:16 eythian         hi
08:06 lds             hello
08:00 drojf           hi marcelr
07:58 marcelr         :)
07:58 LibraryClaire   hi marcelr
07:58 marcelr         hi #koha
07:49 rangi           drojf: awesome thanks
07:48 cait            lol
07:48 LibraryClaire   :D
07:48 drojf           LibraryClaire is catching pokemon from under your bed
07:47 drojf           yes, and less google. hehe
07:47 LibraryClaire   to be fair, so fair I haven't actually played properly, but if pokemon come near enough to my flat and I can catch them from my bed, I do :P
07:47 cait            that's another way of playing :)
07:47 cait            lol
07:47 drojf           but i have a catmandu fix to create marc records from the pokemon wiki thing ;)
07:46 cait            ah
07:46 drojf           cait: i am not
07:46 cait            drojf: makes me wnder... how are you playing it?
07:46 drojf           pokemon lookism :(
07:46 LibraryClaire   one of them is cute, i can catalogue him
07:45 drojf           it only counts when you do :D
07:45 LibraryClaire   not yet :P
07:45 drojf           did you catalogue them?
07:44 * LibraryClaire caught two pokemon this morning
07:44 drojf           ah, wrong phone? :P
07:43 * cait          grumps about not being able to play pokemon go
07:43 drojf           yes i will clean it a little and try some things and then put it up
07:43 drojf           when i was at university, i used koha to procrastinate. now i work with koha, so i harvest pokemon to procrastinate. and i don't care about pokemon :P
07:43 rangi           it'd be pretty neat to get all the pokemon go ones in ;)
07:42 rangi           sweet, can you put up your fix file?
07:42 cait            and morning drojf too
07:42 LibraryClaire   hi drojf :)
07:42 LibraryClaire   hi cait :)
07:41 drojf           hi LibraryClaire
07:41 cait            morning LibraryClaire
07:41 drojf           rangi: i failed at getJSON so far, but it works with downloaded json from bulbapedia ;)
07:40 rangi           drojf: cool :)
07:38 cait            i don't have a laptop with me this weekend - i hope someone else can do a quick qa
07:38 drojf           hi cait and rangi
07:37 * cait          waves
07:37 rangi           signed off now
07:37 rangi           heh, i was just about to submit the same thing
07:36 cait            Joubu++
07:25 petter          morning
07:24 fridolin        hie
06:59 morgane         hi !
06:59 alex_a          bonjour
06:57 wahanui         bonjour, gaetan_B
06:57 gaetan_B        hello
06:50 wahanui         hello, reiveune
06:50 reiveune        hello
06:01 huginn          drojf: The operation succeeded.
06:01 drojf           @later tell tcohen libcache-memcached-perl is not mandatory, but i can put it in as suggested (strange that it isn't), do you pull those in automatically?
05:32 drojf           nevermind, it's back
05:28 drojf           git problems anyone?
05:28 drojf           erm
05:28 drojf           Please make sure you have the correct access rights and the repository exists.
05:28 drojf           git fetch   fatal: Could not read from remote repository.
04:35 huginn          drojf: The operation succeeded.
04:35 drojf           @later tell rangi i still have to make it use getjson from url to be a real pokemon harvester, but http://paste.koha-community.org/39
04:31 drojf           morning #koha