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