IRC log for #koha, 2010-09-07

All times shown according to UTC.

Time S Nick Message
00:04 brendan left #koha
00:05 aarkerio joined #koha
00:06 aarkerio HI! I can add a book to my cart but I don't see the "Check out" option
00:06 aarkerio need I change some permission to teacher rol ?
00:10 aarkerio I added the book to my Cart
00:12 anitsirk_ left #koha
00:16 aarkerio left #koha
00:17 brendan joined #koha
00:46 irma joined #koha
00:47 irma hi all
00:50 wasabi heya irma
00:53 irma heya wassabi :)
00:59 brendan hello all :)
01:01 richard is now known as rich-away
01:42 Elwell left #koha
02:06 brendan left #koha
02:06 brendan joined #koha
02:06 brendan @wunder 93117
02:06 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 17.1�C (7:04 PM PDT on September 06, 2010). Conditions: Haze. Humidity: 75%. Dew Point: 13.0�C. Pressure: 29.75 in 1007.3 hPa (Steady).
02:44 rich-away is now known as richard
02:45 anitsirk joined #koha
02:49 anitsirk left #koha
02:50 jcamins is now known as jcamins_a
02:59 anitsirk joined #koha
02:59 brendan left #koha
03:00 anitsirk left #koha
03:05 Amit joined #koha
03:05 Amit heya chris
04:40 irma left #koha
05:04 cait joined #koha
05:04 cait hi #koha
05:20 cait @wunder Konstanz
05:20 munin cait: The current temperature in Konstanz, Germany is 12.0�C (7:00 AM CEST on September 07, 2010). Conditions: Light Rain. Humidity: 93%. Dew Point: 11.0�C. Pressure: 29.77 in 1008 hPa (Falling).
05:39 richard left #koha
06:10 cait left #koha
06:18 laurence joined #koha
06:28 indradg joined #koha
06:30 magnus joined #koha
06:34 darling left #koha
06:45 chris Evening
06:53 paul_p joined #koha
06:56 magnus Morning ;-)
07:04 kf joined #koha
07:05 kf good morning #koha
07:08 francharb joined #koha
08:01 Amit left #koha
08:48 davi joined #koha
10:47 Amit joined #koha
11:02 * kf shares some chocolate cookies
11:32 Amit left #koha
11:39 collum joined #koha
11:43 magnus thanks!
11:50 wasabi left #koha
11:51 wasabi joined #koha
11:55 kf hi magnus :)
11:55 kf it was a trap... was feeling lonely ;)
11:55 magnus hiya kf - i was trapped then ;-)
11:56 * magnus is trying to wrap his head around sparql
11:58 kf semantic web sparql?
11:59 magnus yup
12:21 nengard joined #koha
12:22 owen joined #koha
12:24 owen Hi #koha
12:25 magnus hi owen
12:29 * owen wonders if slef got any response to his NISO CORE proporsal
12:34 nengard hi all
12:39 schuster joined #koha
12:41 * owen googles NEFLIN
12:41 schuster WELCOME BACK owen!
12:41 owen Thanks schuster
12:44 kf hi owen and schuster
12:47 kf NEFLIN reminds me of GREMLINs
12:48 * kf googles now too to find out if she said something really stupid
12:49 owen Librarians love their acronyms
12:49 kf at least you can say neflin
12:52 owen left #koha
12:55 owen joined #koha
12:56 Nate joined #koha
13:02 nengard reminder: send me koha newsletter articles/tips/tricket/news/ etc ASAP!
13:04 jcamins_a is now known as jcamins
13:05 jcamins Good morning, #koha
13:07 kf hi jcamins
13:12 tcohen joined #koha
13:19 schuster nengard - I just sent you an email about quick spine label setup - use it or not...
13:21 nengard thanks schuster!
13:23 nengard login nengard indigo
13:23 nengard hmmm
13:23 magnus oops?
13:24 nengard was testing something ... oh well
13:25 Topic for #koha is now reminder: send nengard koha newsletter articles/tips/tricket/news/ etc ASAP!
13:26 nengard time to go teach koha
13:26 nengard be back later
13:26 nengard left #koha
13:28 sekjal joined #koha
13:34 schuster left #koha
13:37 schuster joined #koha
13:59 magnus kf++ # for signing off on a patch ;-)
14:06 kf thx magnus :)
14:12 wizzyrea joined #koha
14:13 wizzyrea chris_n: about?
14:13 wizzyrea lol, nm, list consultation fail.
14:13 kf hi wizzyrea
14:13 * chris_n greets wizzyrea
14:13 wizzyrea ...
14:13 wizzyrea double list consultation fail.
14:13 wizzyrea :)
14:14 wizzyrea have you ever seen a message like this re: the label maker?
14:14 wizzyrea
14:14 wizzyrea and good morning everybody
14:15 chris_n interesting, but no
14:20 moodaepo @wunder 56001
14:20 munin moodaepo: The current temperature in MSU Physics Dept, Mankato, Minnesota is 12.5�C (9:21 AM CDT on September 07, 2010). Conditions: Overcast. Humidity: 87%. Dew Point: 10.0�C. Pressure: 28.81 in 975.5 hPa (Rising). Wind Advisory in effect until 3 PM CDT this afternoon...
14:20 jcamins chris_n: yesterday someone reported getting Koha 3.something to run under Windows.
14:20 wizzyrea that is a special sort of insanity
14:21 chris_n jcamins: I saw that, but wasn't he asking "how to" rather?
14:21 * chris_n has a perfectly fine working install of 3.whatever on XP at home
14:21 chris_n and lots of gray hair to show for it :-)
14:22 chris_n 3.1.x that is
14:22 jcamins I don't think so. I understood him to be reporting that he had gotten it working, and was wondering why there didn't seem to be much about successfully running Koha on Windows.
14:22 jcamins Of course, I may have been mistaken.
14:23 chris_n on second read, it seems you're right
14:23 kf jcamins: I think he was asking where to put a tutorial for installing under windoes
14:23 chris_n as I say, it's not impossible
14:23 chris_n just impractical
14:23 kf is someone subscribed tot he win-32 list?
14:24 jcamins Not me. I had enough trouble getting Koha to run under FreeBSD.
14:24 jcamins I want nothing to do with Win32.
14:24 kf :)
14:24 kf I can understand that
14:24 jcamins Heck, I have enough trouble with Koha under Debian!
14:25 kf chris_n: can you perhaps take a look at bug 4904? I think it's a double encoding problem and send a patch for it...
14:25 munin Bug[…]w_bug.cgi?id=4904 major, PATCH-Sent, ---, katrin.fischer, ASSIGNED, Problem with printing fines in overdue notices
14:25 wizzyrea I tried to install it once on OpenBSD
14:25 kf but nobody else has my problem :(
14:25 wizzyrea then again on OSX
14:25 kf chris_n: perhaps you can confirm that my patch will not break something
14:25 jcamins wizzyrea: Both of those sound excessively challenging.
14:26 wizzyrea then I did it successfully on ubuntu :P
14:26 wizzyrea they were excessively challenging
14:26 chris_n kf: I'll try to take a look later today or tomorrow for you
14:27 kf that would be great, thank you
14:29 jcamins Are the web standard police going to come and arrest me for ignoring the fact that we use <br/>s (a lot of them) in OpacMainUserBlock?
14:32 kf the web standard police?
14:32 kf :)
14:33 wizzyrea jcamins: you could just wrap your blocks in <p>
14:34 magnus left #koha
14:36 wizzyrea we did something kind of clever
14:36 wizzyrea we made an install of portable firefox for use with the NEKLS koha install
14:36 wizzyrea so that we can tie it to the receipt printer and still let "big" firefox use whatever printer it likes
14:36 jcamins wizzyrea: We do that too. But it looks kind of like this <p>First paragraph</p><br/><br/><br/></br><p>Second paragraph</p><br/><br/><br/><hr/><br/><p>Third paragraph</p>
14:37 jcamins Yeah, I've been thinking that might be a good idea.
14:37 wizzyrea I don't recommend prism
14:37 wizzyrea it's a pita
14:43 Johnindy joined #koha
14:46 mib_ce99s joined #koha
14:46 mib_ce99s left #koha
15:04 kf bye all
15:04 kf left #koha
15:04 jcamins Woohoo! LLC name has seemingly been fixed!
15:21 jcamins is now known as jcamins_a
15:29 jcamins_a is now known as jcamins
15:30 aarkerio joined #koha
15:32 aarkerio Hi! I am newbie in Koha. I importes a MARC and the create an Item. In OPAC I can found the book but
15:33 aarkerio how can I ask for borrow it?
15:34 aarkerio I mean in OPAC interface
15:34 jcamins aarkerio: You can only check out books from the staff interface.
15:35 aarkerio mmmm, so if I add a book to my cart is for buy it?
15:36 jcamins No, Koha is a library system, not an ecommerce system.
15:36 aarkerio then what I do with items in my cart?
15:37 wizzyrea put holds on them
15:37 aarkerio I can add the book to my cart
15:37 wizzyrea right. It's mostly for your reference, so you can keep track of books you might want to check out
15:37 wizzyrea adn you can place holds on the books in your cart so the library staff can pull them and have them ready for you
15:38 aarkerio ok, in OPAC I can see  "my summary" tab
15:38 aarkerio and "Checked Out" text, what I am checking out?
15:39 wizzyrea that is a list of items that library staff has checked out for you (issued)
15:39 wizzyrea (charged)
15:39 aarkerio or if I as student found a book, what is the next step? go to desk and show my library card to staff?
15:39 wizzyrea yes
15:40 aarkerio so, staff go to "Patrons", found the user and made the checkout?
15:41 owen Staff go to "Circulation," find the user (or scan their library card) and make the checkout
15:42 aarkerio mm,  cool!
15:43 aarkerio I see "Enter item barcode" but I don't have any, can I type ISBN manually?
15:43 wizzyrea o, that's rough.
15:44 aarkerio mmm, or number item?
15:46 aarkerio mm, how can I create the barcodes for books?  "Cataloging"
15:50 aarkerio this is too old:     right?
15:51 owen Yes
15:51 owen
15:52 owen Cataloging -> Search for your book -> Add/Edit items/holdings
15:52 nengard joined #koha
15:55 brendan joined #koha
15:56 CGI534 joined #koha
15:56 CGI534 left #koha
15:58 cait joined #koha
15:58 aarkerio thanks!
15:58 cait hi #koha
15:58 aarkerio in  "p - Barcode"  y see tree dots "..."
15:59 cait it means a plugin can be linked to this field - there is a sys pref for barcode generation, I think it does not work until you turn it on
16:00 aarkerio hi cait,  is barcode an external plugin?
16:01 cait you can link so called plugins to fields in cataloging
16:01 cait perl files, but they come with koha
16:01 cait so not really external
16:01 cait the ... indicate there is one linked to the field
16:02 cait if you want to generate barcodes try to turn on the syspref
16:03 aarkerio ok, I will print the PDF, thanks all for your patience!!
16:06 aarkerio left #koha
16:06 chris_n owen++ # for helping me teach my librarian's to fish
16:07 owen Sorry, tell 'em to get their butts back in the library!
16:07 * owen fears his exclusive fishing blog has been discovered
16:07 chris_n hehe
16:07 cait link? ;)
16:19 laurence left #koha
16:22 stephane_ left #koha
16:59 owen is now known as owen-away
17:06 rhcl Anybody else have problems with disappearing names? sekjal thinks possibly related to uppercasesurnames system preference.
17:07 rhcl
17:08 jcamins Wow, that's really weird.
17:09 jcamins Never encountered it, sorry.
17:09 cait we dont use the uppercasename pref and never had problems so far
17:14 rhcl turning off uppercasesurnames system preference fixes the problem
17:15 paul_p left #koha
17:19 rhcl hey munin, fetch me bug 5148
17:19 munin Bug[…]w_bug.cgi?id=5148 normal, P5, ---, gmcharlt, NEW, Definition with surname won't work
17:20 chris_n left #koha
17:22 chris_n joined #koha
17:22 owen-away rhcl: Turning on uppercasesurnames is what leads to the problem?
17:22 owen-away is now known as owen
17:24 saorge_ left #koha
17:24 rhcl yes, if you turn on that syspref, the problem appears, turn it off and it disappears
17:25 rhcl I guess I should file a bug report.
17:25 saorge joined #koha
17:25 sekjal is now known as sekjal_a
17:26 owen rhcl: Yes, I'd say that's a pretty bug clue right there :)
17:27 rhcl bug 5201
17:27 munin Bug[…]w_bug.cgi?id=5201 major, P5, ---, kyle.m.hall, NEW, Patron last name dropped when record edited
17:27 jcamins Is there any way to merge authorities in the Staff client?
18:01 LBA joined #koha
18:14 CGI476 joined #koha
18:14 CGI476 left #koha
18:16 wizzyrea can someone verify that publication/acquisition date sorting is working in 3.2?
18:16 wizzyrea int he opac
18:16 wizzyrea pretty please
18:16 owen publication and acquisition sorts are very different
18:17 wizzyrea yep
18:17 owen I've never trusted Koha's publication date sort, but have usually found the acquisition sort to work well
18:17 wizzyrea the pubdate sort is as good as the data you give it > gigo
18:17 owen Right
18:17 wizzyrea but since acqdate is system generated it works better
18:17 owen Unfortunately for our garbage-filled catalog
18:17 wizzyrea < same
18:19 owen Ah, do you mean "working" as in, "doesn't just redirect you to the advanced search page?"
18:19 wizzyrea well, lol, no
18:19 wizzyrea I was wondering if the sort actually, you know, sorted.
18:20 wizzyrea (i recognize it's hard to tell with pubdate)
18:20 owen I don't even get results, I get sent back to the advanced search screen
18:20 wizzyrea EW
18:20 jcamins We don't have any acquisition dates, and our database is too full of garbage to be of use.
18:20 jcamins (for testing pubdate searching)
18:20 cait pub date sorting or searching?
18:20 wizzyrea sorting and searching
18:21 cait we have pretty good data for pub date
18:21 cait let me check
18:21 jcamins I meant sorting, not searching, sorry.
18:21 owen wizzyrea: Specifically, I can't *re-sort* from the results screen. I can specify a sort from the advanced search form and get sorted results
18:22 wizzyrea hmm. my 3.2 seems to allow that but I dont have the newest patches
18:22 wizzyrea if there are any
18:22 jcamins pubdate search works on my demo catalog.
18:22 wizzyrea though
18:22 cait looks ok to me in 3.1.161
18:22 owen Anyone remember what Koha is looking at for the pubdate sort?
18:23 cait yep
18:23 cait ah, sort
18:23 cait no
18:23 jcamins Something that makes me weep every time I remember.
18:23 cait search is one of the coded fields, 007 008 one of those
18:24 wizzyrea
18:24 jcamins What version is HEAD at?
18:24 owen is what I'm seeing
18:24 cait wizzyrea: have you checked the coded fields of those records?
18:25 wizzyrea well I'm actually wondering if it's a case of GIGO
18:25 cait yeah, I meant 61 :(
18:25 jcamins Okay, that's what I have too.
18:25 jcamins Oh.
18:25 jcamins Good.
18:25 wizzyrea now that I'm looking at it
18:25 cait GIGO?
18:25 wizzyrea garbage in, garbage out
18:25 jcamins I was just worrying that I had done something bad to my formerly-at-HEAD installation.
18:25 wizzyrea as in, you give it bad data, who knows what you'll get out
18:25 wizzyrea ;)
18:26 cait ah
18:26 cait thx :)
18:29 collum left #koha
18:29 francharb left #koha
18:31 jcamins Has anyone used FastCGI with Koha, successfully?
18:35 sekjal_a is now known as sekjal
18:36 * owen does not love Perl's "something's wrong" warning
18:37 nengard LOL
18:37 nengard k
18:38 jcamins nengard: training? Hi librarians!
18:38 nengard jcamins - nope that's done :)
18:38 nengard but thanks for saying hi anyway :) hehe
18:38 jcamins Oh, well, you can pass my greetings on when you see them next. :)
18:43 jcamins If I wanted to link, say, 690 fields to authorities, could I do it?
18:44 jcamins Hm.
18:44 jcamins It would seem it is linked to the authorities. Never mind.
18:53 brendan left #koha
19:06 tcohen left #koha
19:11 CGI050 joined #koha
19:12 CGI050 left #koha
19:16 LBA left #koha
19:49 chris morning
19:49 * chris is catching up on emails before heading off to do some more training
19:50 nengard left #koha
19:55 jcamins There must be quite a story behind the insecure syspref.
19:58 chris jcamins: automated testing
19:58 jcamins Ah.
19:58 jcamins Okay, that makes sense.
19:58 chris if you want to run 50000 issues through the system
19:58 chris using curl or the like, its easier to bring it up on a local interface, with insecure set
19:58 chris and hammer it
20:07 cait morning chris
20:07 chris hiya cait
20:07 cait :)
20:07 cait what do you train? koha?
20:08 chris yeah, opac, members and circulation today
20:08 cait cool :)
20:08 wizzyrea ooh
20:08 owen Anyone else worry about the fact that the opac displays patron first and last name on comments?
20:08 chris[…]k-hits-Canterbury
20:08 cait owen: hm yes
20:09 chris[…]ums/mqz-drum.html
20:09 sekjal left #koha
20:09 owen wizzyrea: You've got comments enabled, do your patrons use it?
20:11 wizzyrea hardly at all
20:11 wizzyrea chris: oh my@
20:11 Braedon chris: there was a geologist on the news last night saying the 5 aftershock the night before was definitely the biggest they would get. Thought it was a risky statement at the time.
20:12 chris yeah
20:12 * owen is trying to fix Bug 4473, thus thinking about opac comments
20:12 munin Bug[…]w_bug.cgi?id=4473 enhancement, P5, ---, oleonard, NEW, Recent comments view for the OPAC
20:12 chris usually there is one, that is 1 magnitude less, hopefully that was it
20:12 chris or there isnt going to be much christchurch left
20:12 wizzyrea omgosh, that security video of the quake in a supermarket is wild
20:13 cait :(
20:13 wizzyrea :( indeed
20:14 owen left #koha
20:15 wizzyrea these videos are so sad. :(
20:15 chris ok better go get ready, bbl
20:22 richard joined #koha
20:25 brendan joined #koha
20:26 wizzyrea bug 5203
20:26 munin Bug[…]w_bug.cgi?id=5203 minor, P5, ---, cnighswonger, NEW, Creating a label template causes fatal error if description field is empty
20:28 cait bed time
20:28 cait bye all
20:28 cait left #koha
20:33 jcamins Is there some convenient jquery that can add a choice to the Advanced Search screen?
20:34 wizzyrea owen's the real expert, but go ahead and ask
20:34 wizzyrea what are you specifically trying to add?
20:34 jcamins Auction date, in this case.
20:34 wizzyrea is that indexed?
20:34 jcamins Oh, let me try that question again with the key word included:
20:35 wizzyrea I mean, can you limit by that at all anyway?
20:35 jcamins On our catalog you can.
20:35 jcamins adate:
20:35 jcamins Ideally, it should be an option in the dropdowns with "Keywords," etc.
20:35 wizzyrea so your query would be like​rt_by=pubdate_dsc&adate=<somedate>
20:35 jcamins Right.
20:36 wizzyrea hm. lessee.
20:37 Braedon twilight? Don't tell me you are one of THOSE people wizzyrea :P
20:37 wizzyrea no, it's just a search that 1. always has items and 2. has lots of them and 3. has lots of holds
20:37 wizzyrea so it's ez to test with
20:37 wizzyrea ;)
20:38 Braedon haha
20:38 Braedon fair enough
20:38 jcamins I think someone was talking about doing this back before I knew what jquery was.
20:38 wizzyrea $("select[name='idx']") would get you the select dropdown
20:38 wizzyrea now... adding the option...
20:38 wizzyrea (I think)
20:39 wizzyrea[…]list-using-jquery
20:39 wizzyrea might help
20:39 jcamins Ah. Nifty. Thanks!
20:40 Braedon what would we do without stackoverflow?
20:40 Braedon or rather, what did we do before stackoverflow
20:40 jcamins Woohoo! It works!
20:40 jcamins wizzyrea++
20:40 wizzyrea ^.^
20:40 jcamins Ooh! It even works on the basic search screen!
20:40 wizzyrea thank teh googlez
20:41 wizzyrea :)
20:41 Braedon thanks be to our overlords
20:41 Braedon they provide us with the answers
20:41 jcamins :)
20:41 Braedon and only ask of us our souls
20:42 jcamins Speak for yourself.
20:42 Braedon :P
20:42 richard wizzyrea: just noticed there isn't a link to the main koha list on[…]ha-mailing-lists/
20:42 jcamins I live in New York City. ;)
20:43 richard there's a link to the katipo website but not to
20:43 jcamins Time to close up.
20:43 jcamins Night, all.
20:43 anitsirk joined #koha
20:44 jcamins is now known as jcamins_a
20:44 Braedon fair thee well
20:44 wizzyrea richard:
20:45 wizzyrea :)
20:45 wizzyrea now, that may not be entirely clear.
20:45 richard ah
20:45 richard didn't actually notice the link
20:46 wizzyrea you bring up a good point though, that it could be clearer
21:00 schuster left #koha
21:06 redmr joined #koha
21:08 redmr left #koha
21:21 Nate left #koha
21:45 LBA1 joined #koha
21:45 LBA1 left #koha
21:49 LBA joined #koha
21:49 LBA left #koha
22:02 jransom joined #koha
22:08 brendan @wunder 93117
22:08 munin brendan: The current temperature in Northwest Goleta, Goleta, California is 20.5�C (3:04 PM PDT on September 07, 2010). Conditions: Overcast. Humidity: 70%. Dew Point: 15.0�C. Pressure: 29.86 in 1011.1 hPa (Falling).
22:32 anitsirk_ joined #koha
22:33 anitsirk left #koha
22:33 anitsirk_ is now known as anitsirk
22:45 anitsirk left #koha
22:46 anitsirk joined #koha
23:05 chris *sigh*
23:07 jransom spam ....
23:07 chris yeah
23:07 chris did you get it?
23:08 jransom no
23:08 jransom did you
23:08 jransom actually i might have
23:08 jransom deleted it unread
23:08 chris had it forwarded to me
23:08 chris ill forward
23:08 * chris is in paeroa
23:08 chris training, but at tea break
23:08 wasabi 'Maria Thangaraj' ?
23:08 richard getting a photo of the big l&p bottle?
23:09 chris its tiny
23:09 chris ok back into it
23:09 wasabi ah, thats old spam of mine..
23:10 wasabi chris, werk or holiday in paeroa?
23:11 jransom we should all register
23:11 chris work
23:11 jransom although space is very limited ... lol
23:11 chris hauraki go live in a few weeks
23:11 davi left #koha
23:11 alex_a left #koha
23:11 chris doing the staff traning now
23:12 chris well paul is doing the members, i just did opac
23:12 chris im back up after to do circulation
23:13 wasabi ahh, hauraki - good stuff
23:13 chris yeah going well
23:13 jransom thats great news
23:13 jransom how exciting :)
23:13 chris yup :)
23:14 jransom tell Paul I said hi
23:15 jransom what!
23:16 jransom you havn't done it yet ...
23:16 chris hey guys
23:16 jransom by golly :)
23:16 chris public logging
23:16 jransom Chris: ta
23:19 wasabi biab
23:29 LBA joined #koha
23:31 chris hi LBA
23:32 mib_yjs7r joined #koha
23:33 mib_yjs7r Hello all
23:33 mib_yjs7r i need help with some basic stuff
23:33 mib_yjs7r koha express
23:34 chris is that a liblime product? we probably cant help with that, they are running a really old version of koha
23:34 chris but have a try, we might be able to
23:34 mib_yjs7r say a student has an overdue item, and I've set it up so that she receives an overdue notice -- is there a way to know if the notice has been sent?
23:35 chris in official koha yes, you can see that in the members screen
23:35 chris in the messaging or notices tab (on the left hand side)
23:35 chris not sure how the liblime fork looks anymore
23:36 chris mib_yjs7r: if you had db access you could also look at the message_queue table
23:36 mib_yjs7r which is where?
23:37 chris its in the database, do you get database access with liblime express?
23:38 mib_yjs7r I guess I don't
23:38 chris mib_yjs7r: its useful to be aware that liblime are actively hostile to the community, and while we do our best to help their users, sometimes due to the fact they do things different to everyone else we cant
23:39 chris if you go to the staff interface
23:39 chris and do a search for the borrower
23:39 chris and get to the details page
23:39 chris yell out when you get there :)
23:40 mib_yjs7r in the borrower's account there is a "messaging" tab
23:40 mib_yjs7r but it does nothing
23:41 chris is there a notices tab?
23:42 mib_yjs7r Nope
23:42 chris ok, in the url you see the borrower number?
23:43 chris take a note of that
23:43 chris the go to reports
23:43 chris choose create from sql
23:44 chris type into the sql box
23:44 LBA hi chris and all....just lurking
23:44 chris select * from message_queue where borrowernumber=the_number
23:44 chris save that, and then run that report
23:44 chris that sould hopefully tell you
23:45 mib_yjs7r ok, i'll try that... thanks!
23:46 mib_yjs7r never created or ran a sql report, hope i don't breake anything :-)
23:46 mib_yjs7r break
23:46 chris that should be fine :)
23:49 mib_yjs7r asks for a report name, notes, type
23:49 mib_yjs7r or should i have clicked on "build new"?
23:50 chris is there a link create from sql?
23:50 mib_yjs7r yes i clicked on it and asks for above
23:50 mib_yjs7r report name i guess i can name it whatever
23:50 chris put a name in then, and you can leave the others blank
23:51 mib_yjs7r i don't understand this part: "select * from message_queue where borrowernumber=the_number"
23:52 chris cut and paste that in, into the big box for sql
23:52 chris changing the_number to the number that you took a note of before
23:52 mib_yjs7r ok i guess that's the "notes:" box
23:52 chris no
23:52 chris (this is what i mean by being hard, this is different to koha, in koha there is a box called sql)
23:54 mib_yjs7r there is no sql box, just a box that says "notes:" to the upper left
23:54 chris maybe there is another screen after
23:55 chris try putting it in the notes
23:55 chris cant hurt :)
23:55 mib_yjs7r sorry
23:56 mib_yjs7r i saw the sql box!
23:56 mib_yjs7r i guess i'm blind
23:56 chris :)
23:56 mib_yjs7r ok i saved it
23:57 chris cool
23:57 chris try running it now
23:57 mib_yjs7r now how do I run it? :p
23:57 chris go back to reports, choose use saved
23:58 mib_yjs7r i notice there are some reports saved alreadt
23:58 mib_yjs7r i guess the liblime people created them
23:59 mib_yjs7r should i download as comma or tab separated text?
23:59 wasabi mib_yjs7r:  you should ask your vendor to install php-myadmin on your koha-server
23:59 chris i wouldnt download them as either

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary