IRC log for #koha, 2010-03-31

All times shown according to UTC.

Time S Nick Message
06:52 logbot_backup joined #koha
06:56 pastebot joined #koha
07:05 Kivutar joined #koha
07:07 francharb joined #koha
07:07 Nouman I want to deploy Examination project also
07:08 Nouman Is any one know the Free ware Examination project similar like KOHA-ILS
07:08 chris koha isn't freeware
07:09 paul_p hi chris & al
07:09 chris hiya paul_p
07:09 Nouman Chris: I think KOHA is opensource and free ware
07:09 chris no its free software, not free ware, freeware is free proprietary programs
07:10 IrmaCalyx joined #koha
07:10 Nouman ok do u know examination project like koha or another famous
07:10 Ropuch Hi chris , IrmaCalyx
07:10 IrmaCalyx Hi there :-0
07:10 laurence joined #koha
07:11 chris ive never heard of examination project
07:11 chris hi Ropuch and IrmaCalyx
07:11 Nouman ok
07:11 Nouman Any one know the name of Online examination project
07:12 chris you mean moodle?
07:12 IrmaCalyx http://moodle.org/
07:17 Nouman is any one other which is  related to Examination Branch of University
07:17 Nouman I want to Computerized Examination branch from manual work
07:22 Nouman student records, transcripts, enrollment & other functions
07:32 hdl_laptop hi chris
07:32 miguel hi all
07:32 hdl_laptop hi miguel
07:33 juan|away left #koha
07:35 jati joined #koha
07:35 jati left #koha
07:36 juan joined #koha
07:44 alex_a joined #koha
07:46 kf joined #koha
07:50 juan left #koha
07:51 juan joined #koha
07:51 Nouman left #koha
07:52 Nouman joined #koha
07:58 Nouman left #koha
08:00 kf good morning #koha
08:37 Nouman joined #koha
08:38 Nouman left #koha
08:38 alex_a good morning kf
08:44 kf good morning alex_a
09:01 kf hm my report is limited to 20 results in 3.01.61 - is there a trick I can get all results displayed?
09:41 hdl_laptop left #koha
11:09 laurence left #koha
11:20 hdl_laptop joined #koha
11:30 nengard joined #koha
11:34 IrmaCalyx left #koha
11:35 jdavidb joined #koha
11:42 jdavidb mornin', #koha.
11:43 hdl_laptop hi jdavidb
11:57 jwagner joined #koha
12:06 kf morning jdavidb :)
12:06 kf hi hdl
12:12 hdl_laptop hi kf
12:19 jwagner morning all
12:20 kf hi jwagner
12:28 sekjal joined #koha
12:29 owen joined #koha
12:30 owen Hey all, anyone now what's up with chris's IRC log?
12:30 owen http://stats.workbuffer.org/irclog/koha/today
12:30 owen 404
12:33 gmcharlt dunno - maintenance?
12:33 kf is there a way koha can renew borrowers automatically?
12:34 chris_n owen: check the buffer
12:34 chris_n he was having problems last evening
12:34 kf my librarian wonders because she wanted to renew borrowers and they had a strange date set
12:35 chris_n and g'morning
12:35 owen chris_n: That's where I was looking to check the buffer ;)
12:35 gmcharlt chris_n: chicken, meet egg :)
12:35 jdavidb @seen Colin
12:35 munin` jdavidb: Colin was last seen in #koha 1 week, 4 days, 19 hours, 58 minutes, and 14 seconds ago: <Colin> We don't want to get people's hopes up
12:35 chris_n <chris> hmm 7.56am the bots signed off, and i cant shell into my machine at home, i wonder if the baby has eaten it
12:35 owen chris_n: Thanks, now you're my buffer.
12:36 chris_n <chris_n> hehe
12:36 chris_n <jdavidb_no_life> :P
12:36 chris_n <chris_n> http://www.youtube.com/watch?v=CmYDgncMhXw
12:36 chris_n * chris_n tries to imagine chris 's baby devouring his computer
12:36 chris_n <jdavidb_no_life> Hey!  That's about *me!*
12:36 chris_n * jdavidb_no_life has The Knack.
12:36 chris_n * richard (~richard@spidette.katipo.co.nz) has joined #koha
12:36 chris_n <chris> heh
12:36 chris_n gmcharlt: lol :)
12:36 * chris_n forgets that not everyone uses an irc proxy
12:38 kmkale joined #koha
12:41 hilongo joined #koha
12:42 hilongo Hello #koha  :)
12:42 kf chris_n: translate.koha.org is down too, he wrote something on twitter that he will look at it after work
12:43 hilongo does anyone knows why my koha lives one day in the past?
12:44 owen Wrong system date on your Koha server?
12:45 hilongo whenever a book is returned, the systems logs the return date as if the item was returned yesterday...
12:45 hilongo hmm... nope ... checked that and date is ok in server
12:45 sekjal Ah, I know this one.  Bug 4326
12:45 munin` Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4326 normal, P4, ---, ian.walls@bywatersolutions.com, NEW, Items marked as returned yesterday, even if checked out today
12:45 sekjal patch sent
12:46 hilongo ahhh ... great ... :D
12:47 hilongo so... how do I get that patch... git fetch?
12:47 sekjal I don't think it's been committed yet, but it's been sent to the list.
12:49 sekjal http://lists.koha.org/pipermai[…]March/005897.html
12:50 owen Is the patch not attached to the bug report?
12:51 hilongo owen: nope ... at least I don't see it
12:51 hilongo sekjal: Thanks! checking it right now...
12:52 sekjal oops.  patch now attached to bug report
12:54 * sekjal adds this step to his bug-patching process
12:54 Nate joined #koha
12:57 owen patch_attaching++
12:59 owen left #koha
13:03 jwagner is now known as jwagner_meeting
13:15 ccurry joined #koha
13:17 brendan left #koha
13:24 ccurry gmcharlt: First, good morning. Can you decipher an error message from misc/maintenance/sync_items_in_marc_bib.pl for me?
13:24 ccurry Could not retrieve bib x from the database - record is corrupt.
13:24 ccurry I then get "Number of bibs with errors:               79058" at the end of the script.
13:24 ccurry Any way of determining exactly how these records are corrupt?
13:25 gmcharlt ccurry: that's a lot - how does that compare with the total number of bibs in your database?
13:25 ccurry 219459 total
13:26 ccurry Many of the records id'ed as corrupt were created in Koha.
13:28 gmcharlt ccurry: we'll need to look at them - if you add the following line to the script
13:28 gmcharlt print STDERR GetXmlBiblio($biblionumber); # before the line that increments $num_bad_bibs
13:28 gmcharlt you can then rerun the script but pipe STDERR to a file
13:28 gmcharlt e.g.
13:29 gmcharlt sync_items_in_marc_bib.pl 2> bad_bibs
13:29 gmcharlt don't need to run it to completion, you can cancel it after you get some bad bibs recorded
13:30 ccurry ok; it'll be a while; I don't think the errors started until the end, about 140K in; at this point it seems to id'ed all records as corrupt
13:30 owen joined #koha
13:30 ccurry *seems to have
13:30 gmcharlt oh, interesting
13:31 gmcharlt in that case, that may actually one bad record throwing off the parsing of the subsequent records
13:31 ccurry Does the 2 in "sync_items_in_marc_bib.pl 2> bad_bibs" stand for STDERR
13:31 ccurry That's interesting
13:31 gmcharlt yes
13:31 ccurry I wish my shell history was longer; I could go back and see where it started
13:32 ccurry I'll run it again and let you know what errors I see.
13:32 ccurry Thanks for your help.
13:32 gmcharlt ccurry: before you do that - just a sec - something else has occurred to me
13:32 ccurry ok
13:33 rhcl left #koha
13:33 gmcharlt ccurry: what do you get when you run
13:33 gmcharlt perl -MMARC::File::XML -e 'print $MARC::File::XML::VERSION, "\n"'
13:34 ccurry 0.88
13:34 gmcharlt thought so
13:34 gmcharlt if I'm right, what you actually should do is upgrade to MARC::File::XML 0.92 (you'll have to do it from CPAN, not the Debian package)
13:35 gmcharlt then when you rerun the sync script, it should only turn up one (or a handful) of records that are actually corrupt
13:36 ccurry sweet.  and that error output will give me the record numbers, I assume, so I can check them out?
13:37 gmcharlt that's in the log messages, but if you want to guarantee that the biblionumber is next to the malformed XML, you can do something like
13:37 gmcharlt print STDERR $biblionumber . ' - ' . GetXmlBiblio($biblionumber);
13:39 gmcharlt you can also get the right version of MARC::File::XML by pulling the libmarc-xml-perl package from squeeze instead of lenny
13:41 ccurry That's good to know.  I just cpanned it.
13:47 kf ok, i have no idea how these borrowers got renewed - will do some tests tomorrowe - bye #koha
13:47 kf left #koha
13:58 owen In PHP prepared statements you have to specify the type of variable you'll be putting in: " bind_param('i', $i); " $i is type "i", an integer.
13:58 owen Is this not true of Perl?
13:58 nengard left #koha
13:58 ccurry gmcharlt: so, to pull libmarc-xml-perl from squeeze, I'd just have to add the squeeze sources to sources.list and apt-get install as usual?  It's better to grab debian packages than cpan them, right?
13:58 owen Perl doesn't care what it's getting when you "$sth->execute( @bind_params );"
13:58 owen ?
13:59 gmcharlt ccurry: you'd do apt-get install -t squeeze libmarc-xml-perl after update sources.list
13:59 ccurry ah; nice.  thanks.
13:59 gmcharlt owen: Perl itself doesn't care; the database layer is hoping that the passed parameters will be of the right datatypes, of course
14:00 ccurry and any apt-get install commands I issud without the -t option would pull from lenny sources?
14:01 gmcharlt yep
14:01 gmcharlt as you presumably don't want to upgrade to sqeeze just yet, or at least, not just on account of a single Perl module
14:03 hdl_laptop left #koha
14:10 ccurry gmcharlt: awesome.
14:10 ccurry not quite yet.
14:10 ccurry Thanks again. I'll let you know what I find in the sync error log.
14:16 moodaepo joined #koha
14:21 collum joined #koha
14:23 moodaepo left #koha
14:26 moodaepo joined #koha
14:27 wizzyrea_laptop joined #koha
14:29 * jdavidb waves at wizzyrea_laptop.
14:29 wizzyrea_laptop hi :)
14:29 * jdavidb waves at collum and moodaepo, too.
14:30 * paul_p waves at everyone too
14:30 collum Hi jdavidb
14:30 moodaepo Hello #koha : )
14:31 collum and all
14:36 jwagner_meeting is now known as jwagner
14:37 hilongo hello collum
14:37 hilongo hello moodaepo
14:42 wajasu joined #koha
14:49 brendan joined #koha
14:58 schuster joined #koha
15:00 hilongo ok .. aplied the patch for bug 4326 and worked out fine :)
15:00 munin` Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4326 normal, P4, ---, ian.walls@bywatersolutions.com, NEW, Items marked as returned yesterday, even if checked out today
15:00 sekjal huzzah!
15:01 wizzyrea_laptop oh dear lol that's  a doozy
15:06 kmkale left #koha
15:09 wizzyrea_mobile joined #koha
15:11 wizzyrea_mobile left #koha
15:26 Kivutar left #koha
15:27 alex_a left #koha
16:01 francharb left #koha
16:15 nicomo left #koha
16:26 tomascohen joined #koha
16:33 owen In the inventory tool, when one chooses to "skip copies on loan," the SQL is modified to add "WHERE issues.date_due IS NULL"
16:34 owen ...and adds "LEFT JOIN issues ON items.itemnumber = issues.itemnumber"
16:35 owen Why would issues.date_due be NULL?
16:35 gmcharlt it's how a left join works
16:35 gmcharlt if a parent table (in this case, items) does not have a matching row in the child table (in this case, issues)
16:36 gmcharlt the output contains a row anyway, but the columns coming from the child table are presented as all being null
16:37 gmcharlt to help your googling, I should also point out that "left join" is short for left *outer* join
16:40 owen Okay, finally getting it... the "issues.date_due IS NULL" is looking at the result of the JOIN, not the contents of issues
16:40 gmcharlt right
16:48 ccurry gmcharlt: sync finished with same 79058 records identified as corrupt.  I got a huge list of bibnumbers in the log file, but nothing else.  I added "print STDERR $biblionumber . ' - ' . GetXmlBiblio($biblionumber);" on line 81, between "print "\nCould not retrieve bib $biblionumber from the database - record is corrupt.\n";" & "$num_bad_bibs++;"
16:48 ccurry Do I need to restart the server for the new perl module to take effect...or is there something else going on?
16:50 gmcharlt ccurry: what do you get when you run the query select count(*) from biblioitems where marcxml is null or marcxml = '';
16:52 ccurry is that statement missing something at the end, near  â€?
16:52 ccurry SELECT COUNT(*) FROM biblioitems WHERE marcxml IS NULL; gives me 0
16:58 tomascohen left #koha
17:07 ccurry gmcharlt: just found an interesting thing: SELECT COUNT(*) FROM biblioitems
17:07 ccurry returns 140401
17:07 ccurry This, I think, explains why the scripts ends there...140402 is the first biblionumber that throws an error.  I checked my live server and the same count gives me 219641.  I guess something went wrong in the loading of MySQL data in the test server.  I'll try loading the data fresh and see if the count is restored.  Thanks for your help and sorry I blamed your script for something that was...
17:07 ccurry ...clearly my fault!  Cheers!
17:07 gmcharlt ah, thanks for hte udpate
17:08 wizzyrea_laptop in the logs, where it says "librarian", what are you supposed to put in there
17:08 wizzyrea_laptop like, name of librarian?
17:08 paul_p left #koha
17:08 ccurry left #koha
17:10 gmcharlt log search?  the borrowernumber of the staff user, I believe
17:26 mib_7l6wcc left #koha
17:28 miguel left #koha
17:32 joetho joined #koha
17:34 juan left #koha
17:40 DarrellUlm joined #koha
17:41 DarrellUlm Hello
17:43 wizzyrea_laptop ohh, ty
17:43 DarrellUlm Anyone getting Zebra Error 109 when searching? What's up with that?
17:44 wizzyrea_laptop dumb question, are you running zebra as the koha user?
17:45 DarrellUlm No, should I be when doing the rebuild_zebra
17:45 wizzyrea_laptop yea, I believe so, i think 109 is perms.
17:45 wizzyrea_laptop but I could be remembering that wrong
17:47 chris owen: websites back
17:48 owen Thanks chris, I hope it wasn't a crisis
17:49 DarrellUlm So don't run as root when rebuilding?
17:49 wizzyrea_laptop correct
17:49 DarrellUlm Ah, I see
17:49 gmcharlt dunno, depending on how much old equipment you have, may be cheaper to have atu deveop a taste for servers ;)
17:50 DarrellUlm Well, that makes sense (?) but certainly there is a reason.
17:50 chris owen: naw power cut, and disks needed a fsck
17:50 DarrellUlm Just a test server, migrated stuff to 3.2a
17:50 wizzyrea_laptop don't we all
17:52 DarrellUlm Hmmm, so should the <dev> install also be as the koha user? for some reason?
17:53 gmcharlt DarrellUlm: as a non-root user, yes
17:53 gmcharlt there isn't anything special about what you call the user account
17:55 DarrellUlm true in general, I am just referring to the Koha Install - install for other software like Nagios on Linux for instance is different - Koha has many interesting aspects to the install
17:57 nengard joined #koha
18:01 * owen realizes it's already April 1 somewhere: http://www.sitepoint.com/blogs[…]nternet-explorer/
18:02 DarrellUlm All in all the upgrade works well from 3.0 -> 3.2
18:03 DarrellUlm A few things with the label tables, could just be my install, didn't cause any real probs
18:04 jwagner Just found either a bug or a puzzler.  The admin syspref noItemTypeImages appears to have no effect at all in the OPAC.  If an item type has an image assigned, it will display regardless of whether the syspref is on or off.  Is this by design?  Or should the OPAC be told to obey the syspref?
18:07 sekjal jwagner: is this the case in both XSLT and nonXSLT modes?
18:08 jwagner Regardless, I think -- I'm seeing the icons show up on the advanced search page which doesn't use XSLT, and when I searched the code I couldn't find any opac-related use of the setting.
18:09 jwagner Yep, just tested & the icons show in non-XSLT as well for title display.
18:10 DarrellUlm Question on this, is non-XSLT going to be the standard again due to the speed issues of XSLT?
18:10 jwagner The syspref does seem to affect staff mode display, just not OPAC.
18:11 * jdavidb nominates jwagner to fix the bug she found.     dooooo eeeet...
18:11 * jwagner glares at jdavidb
18:11 * jdavidb runs n hides.
18:12 * jwagner thought jdavidb was busy working on something -- what's he doing making comments in here?
18:12 jdavidb :P  Checking in, switching from one interrupt-the most-important-thing task, to another.
18:13 jwagner I'll open a bug report.  I wanted to see if anyone knew the history on this -- whether it was by design or not.
18:13 chris jwagner: does it have an effect in the staff client?
18:13 chris and there isnt an opaconly one? (lots of sysprefs have one for opac one for staff)
18:14 * chris will bbiab
18:17 jwagner chris, there is not an equivalent OPAC syspref.  If the syspref is set to not display images, they still show in staff advanced search.  They do not show in the staff title display page.
18:21 jwagner I hadn't noticed this before because I hate the item type icons and never configure a system with them if I can help it :-)
18:30 nengard left #koha
18:47 larsw joined #koha
19:03 nengard joined #koha
19:09 jdavidb left #koha
19:13 DarrellUlm The item type icons are useful to patrons many would say.
19:20 jwagner I think it's one of those "love 'em or loathe 'em" things.
19:21 DarrellUlm Ha! :)
19:29 DarrellUlm Hmmm, perhaps a list could be made!
19:30 richard joined #koha
19:30 richard hi
19:36 DarrellUlm Hello
19:40 jwagner left #koha
19:45 DarrellUlm left #koha
19:52 chris back
19:56 richard hi chris
19:56 chris hiya richard
20:09 collum left #koha
20:11 owen left #koha
20:50 * chris_n wanders by
21:02 sekjal left #koha
21:04 wajasu left #koha
21:09 nengard left #koha
21:12 wajasu joined #koha
21:16 schuster left #koha
21:39 rhcl joined #koha
21:46 Jo joined #koha
21:56 brendan left #koha
22:10 hdl_laptop joined #koha
22:36 saorge_ joined #koha
22:40 saorge left #koha
22:42 rhcl left #koha
23:55 Nate left #koha

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