Time Nick Message
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 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: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
08:00 kf good morning #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?
11:42 jdavidb mornin', #koha.
11:43 hdl_laptop hi jdavidb
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: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: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` 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_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/pipermail/koha-patches/2010-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:57 owen patch_attaching++
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 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 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: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 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: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: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:37 hilongo hello collum
14:37 hilongo hello moodaepo
15:00 hilongo ok .. aplied the patch for bug 4326 and worked out fine :)
15:00 munin` 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_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
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
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:10 gmcharlt log search? the borrowernumber of the staff user, I believe
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
18:01 * owen realizes it's already April 1 somewhere: http://www.sitepoint.com/blogs/2010/04/01/microsoft-drop-trident-from-internet-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 :-)
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 hi
19:36 DarrellUlm Hello
19:52 chris back
19:56 richard hi chris
19:56 chris hiya richard
20:50 * chris_n wanders by