Time Nick Message
20:50 * chris_n wanders by
19:56 chris hiya richard
19:56 richard hi chris
19:52 chris back
19:36 DarrellUlm Hello
19:30 richard hi
19:29 DarrellUlm Hmmm, perhaps a list could be made!
19:21 DarrellUlm Ha! :)
19:20 jwagner I think it's one of those "love 'em or loathe 'em" things.
19:13 DarrellUlm The item type icons are useful to patrons many would say.
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: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:14 * chris will bbiab
18:13 chris and there isnt an opaconly one? (lots of sysprefs have one for opac one for staff)
18:13 chris jwagner: does it have an effect in the staff client?
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:12 jdavidb :P Checking in, switching from one interrupt-the most-important-thing task, to another.
18:12 * jwagner thought jdavidb was busy working on something -- what's he doing making comments in here?
18:11 * jdavidb runs n hides.
18:11 * jwagner glares at jdavidb
18:11 * jdavidb nominates jwagner to fix the bug she found. dooooo eeeet...
18:10 jwagner The syspref does seem to affect staff mode display, just not OPAC.
18:10 DarrellUlm Question on this, is non-XSLT going to be the standard again due to the speed issues of XSLT?
18:09 jwagner Yep, just tested & the icons show in non-XSLT as well for title display.
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:07 sekjal jwagner: is this the case in both XSLT and nonXSLT modes?
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:03 DarrellUlm A few things with the label tables, could just be my install, didn't cause any real probs
18:02 DarrellUlm All in all the upgrade works well from 3.0 -> 3.2
18:01 * owen realizes it's already April 1 somewhere: http://www.sitepoint.com/blogs/2010/04/01/microsoft-drop-trident-from-internet-explorer/
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:53 gmcharlt there isn't anything special about what you call the user account
17:53 gmcharlt DarrellUlm: as a non-root user, yes
17:52 DarrellUlm Hmmm, so should the <dev> install also be as the koha user? for some reason?
17:50 wizzyrea_laptop don't we all
17:50 DarrellUlm Just a test server, migrated stuff to 3.2a
17:50 chris owen: naw power cut, and disks needed a fsck
17:50 DarrellUlm Well, that makes sense (?) but certainly there is a reason.
17:49 gmcharlt dunno, depending on how much old equipment you have, may be cheaper to have atu deveop a taste for servers ;)
17:49 DarrellUlm Ah, I see
17:49 wizzyrea_laptop correct
17:49 DarrellUlm So don't run as root when rebuilding?
17:48 owen Thanks chris, I hope it wasn't a crisis
17:47 chris owen: websites back
17:45 wizzyrea_laptop but I could be remembering that wrong
17:45 wizzyrea_laptop yea, I believe so, i think 109 is perms.
17:45 DarrellUlm No, should I be when doing the rebuild_zebra
17:44 wizzyrea_laptop dumb question, are you running zebra as the koha user?
17:43 DarrellUlm Anyone getting Zebra Error 109 when searching? What's up with that?
17:43 wizzyrea_laptop ohh, ty
17:41 DarrellUlm Hello
17:10 gmcharlt log search? the borrowernumber of the staff user, I believe
17:08 wizzyrea_laptop like, name of librarian?
17:08 wizzyrea_laptop in the logs, where it says "librarian", what are you supposed to put in there
17:07 gmcharlt ah, thanks for hte udpate
17:07 ccurry ...clearly my fault! Cheers!
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 returns 140401
17:07 ccurry gmcharlt: just found an interesting thing: SELECT COUNT(*) FROM biblioitems
16:52 ccurry SELECT COUNT(*) FROM biblioitems WHERE marcxml IS NULL; gives me 0
16:52 ccurry is that statement missing something at the end, near ”?
16:50 gmcharlt ccurry: what do you get when you run the query select count(*) from biblioitems where marcxml is null or marcxml = '';
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: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:40 gmcharlt right
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:37 gmcharlt to help your googling, I should also point out that "left join" is short for left *outer* join
16:36 gmcharlt the output contains a row anyway, but the columns coming from the child table are presented as all being null
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:35 gmcharlt it's how a left join works
16:35 owen Why would issues.date_due be NULL?
16:34 owen ...and adds "LEFT JOIN issues ON items.itemnumber = issues.itemnumber"
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"
15:01 wizzyrea_laptop oh dear lol that's a doozy
15:00 sekjal huzzah!
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 hilongo ok .. aplied the patch for bug 4326 and worked out fine :)
14:37 hilongo hello moodaepo
14:37 hilongo hello collum
14:31 collum and all
14:30 moodaepo Hello #koha : )
14:30 collum Hi jdavidb
14:30 * paul_p waves at everyone too
14:29 * jdavidb waves at collum and moodaepo, too.
14:29 wizzyrea_laptop hi :)
14:29 * jdavidb waves at wizzyrea_laptop.
14:10 ccurry Thanks again. I'll let you know what I find in the sync error log.
14:10 ccurry not quite yet.
14:10 ccurry gmcharlt: awesome.
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:01 gmcharlt yep
14:00 ccurry and any apt-get install commands I issud without the -t option would pull from lenny sources?
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
13:59 ccurry ah; nice. thanks.
13:59 gmcharlt ccurry: you'd do apt-get install -t squeeze libmarc-xml-perl after update sources.list
13:58 owen ?
13:58 owen Perl doesn't care what it's getting when you "$sth->execute( @bind_params );"
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 Is this not true of Perl?
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:47 kf ok, i have no idea how these borrowers got renewed - will do some tests tomorrowe - bye #koha
13:41 ccurry That's good to know. I just cpanned it.
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:37 gmcharlt print STDERR $biblionumber . ' - ' . GetXmlBiblio($biblionumber);
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:36 ccurry sweet. and that error output will give me the record numbers, I assume, so I can check them out?
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: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:34 gmcharlt thought so
13:34 ccurry 0.88
13:33 gmcharlt perl -MMARC::File::XML -e 'print $MARC::File::XML::VERSION, "\n"'
13:33 gmcharlt ccurry: what do you get when you run
13:32 ccurry ok
13:32 gmcharlt ccurry: before you do that - just a sec - something else has occurred to me
13:32 ccurry Thanks for your help.
13:32 ccurry I'll run it again and let you know what errors I see.
13:31 ccurry I wish my shell history was longer; I could go back and see where it started
13:31 gmcharlt yes
13:31 ccurry That's interesting
13:31 ccurry Does the 2 in "sync_items_in_marc_bib.pl 2> bad_bibs" stand for STDERR
13:31 gmcharlt in that case, that may actually one bad record throwing off the parsing of the subsequent records
13:30 gmcharlt oh, interesting
13:30 ccurry *seems to have
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:29 gmcharlt don't need to run it to completion, you can cancel it after you get some bad bibs recorded
13:29 gmcharlt sync_items_in_marc_bib.pl 2> bad_bibs
13:28 gmcharlt e.g.
13:28 gmcharlt you can then rerun the script but pipe STDERR to a file
13:28 gmcharlt print STDERR GetXmlBiblio($biblionumber); # before the line that increments $num_bad_bibs
13:28 gmcharlt ccurry: we'll need to look at them - if you add the following line to the script
13:26 ccurry Many of the records id'ed as corrupt were created in Koha.
13:25 ccurry 219459 total
13:25 gmcharlt ccurry: that's a lot - how does that compare with the total number of bibs in your database?
13:24 ccurry Any way of determining exactly how these records are corrupt?
13:24 ccurry I then get "Number of bibs with errors: 79058" at the end of the script.
13:24 ccurry Could not retrieve bib x from the database - record is corrupt.
13:24 ccurry gmcharlt: First, good morning. Can you decipher an error message from misc/maintenance/sync_items_in_marc_bib.pl for me?
12:57 owen patch_attaching++
12:54 * sekjal adds this step to his bug-patching process
12:52 sekjal oops. patch now attached to bug report
12:51 hilongo sekjal: Thanks! checking it right now...
12:51 hilongo owen: nope ... at least I don't see it
12:50 owen Is the patch not attached to the bug report?
12:49 sekjal http://lists.koha.org/pipermail/koha-patches/2010-March/005897.html
12:47 sekjal I don't think it's been committed yet, but it's been sent to the list.
12:47 hilongo so... how do I get that patch... git fetch?
12:46 hilongo ahhh ... great ... :D
12:45 sekjal patch sent
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 Ah, I know this one. Bug 4326
12:45 hilongo hmm... nope ... checked that and date is ok in server
12:45 hilongo whenever a book is returned, the systems logs the return date as if the item was returned yesterday...
12:44 owen Wrong system date on your Koha server?
12:43 hilongo does anyone knows why my koha lives one day in the past?
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:42 hilongo Hello #koha :)
12:36 * chris_n forgets that not everyone uses an irc proxy
12:36 chris_n gmcharlt: lol :)
12:36 chris_n <chris> heh
12:36 chris_n * richard (~richard@spidette.katipo.co.nz) has joined #koha
12:36 chris_n * jdavidb_no_life has The Knack.
12:36 chris_n <jdavidb_no_life> Hey! That's about *me!*
12:36 chris_n * chris_n tries to imagine chris 's baby devouring his computer
12:36 chris_n <chris_n> http://www.youtube.com/watch?v=CmYDgncMhXw
12:36 chris_n <jdavidb_no_life> :P
12:36 chris_n <chris_n> hehe
12:35 owen chris_n: Thanks, now you're my buffer.
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 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 jdavidb @seen Colin
12:35 gmcharlt chris_n: chicken, meet egg :)
12:35 owen chris_n: That's where I was looking to check the buffer ;)
12:35 chris_n and g'morning
12:34 kf my librarian wonders because she wanted to renew borrowers and they had a strange date set
12:34 chris_n he was having problems last evening
12:34 chris_n owen: check the buffer
12:33 kf is there a way koha can renew borrowers automatically?
12:33 gmcharlt dunno - maintenance?
12:30 owen 404
12:30 owen http://stats.workbuffer.org/irclog/koha/today
12:30 owen Hey all, anyone now what's up with chris's IRC log?
12:20 kf hi jwagner
12:19 jwagner morning all
12:12 hdl_laptop hi kf
12:06 kf hi hdl
12:06 kf morning jdavidb :)
11:43 hdl_laptop hi jdavidb
11:42 jdavidb mornin', #koha.
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?
08:44 kf good morning alex_a
08:38 alex_a good morning kf
08:00 kf good morning #koha
07:32 hdl_laptop hi miguel
07:32 miguel hi all
07:32 hdl_laptop hi chris
07:22 Nouman student records, transcripts, enrollment & other functions
07:17 Nouman I want to Computerized Examination branch from manual work
07:17 Nouman is any one other which is related to Examination Branch of University
07:12 IrmaCalyx http://moodle.org/
07:12 chris you mean moodle?
07:11 Nouman Any one know the name of Online examination project
07:11 Nouman ok
07:11 chris hi Ropuch and IrmaCalyx
07:11 chris ive never heard of examination project
07:10 IrmaCalyx Hi there :-0
07:10 Ropuch Hi chris , IrmaCalyx
07:10 Nouman ok do u know examination project like koha or another famous
07:09 chris no its free software, not free ware, freeware is free proprietary programs
07:09 Nouman Chris: I think KOHA is opensource and free ware
07:09 chris hiya paul_p
07:09 paul_p hi chris & al
07:08 chris koha isn't freeware
07:08 Nouman Is any one know the Free ware Examination project similar like KOHA-ILS
07:07 Nouman I want to deploy Examination project also