Time Nick Message
23:30 jcamins_away No difference.
23:28 jcamins_away Thanks.
23:28 jcamins_away Ah, good point.
23:28 rangi it will tell you
23:28 rangi run the query using explain
23:27 jcamins_away Is there any performance hit for using BETWEEN?
23:25 jcamins_away This is also true.
23:24 maximep my sysadmins learned that search doesn't work much without zebrasrv today
23:24 maximep haha
23:23 jcamins_away Useful lesson of the minute: you cannot move koha-dev to a different partition while zebrasrv is running without causing problems.
23:21 maximep I can help with that :p
23:19 thd French lesson today.
23:18 maximep thanks for the help!
23:18 maximep and a patch if i can
23:18 maximep and write a bug report tomorrow with suggestions
23:17 maximep to fix it for my clients
23:17 maximep for now I thin I will just revert that patch
23:16 maximep well maybe not
23:16 maximep CanBookBeReserved could be 3 lines hehe
23:15 rangi but they are used by the merge stuff
23:15 maximep so I will posta bug report tomorrow
23:15 rangi id say kill the other ones
23:15 maximep well, I have to go
23:15 rangi and actually just return an array of itemnumbers
23:15 rangi yeah i think a couple of new subs in Items.pm .. that behave sanely
23:14 rangi analytics stuff
23:14 rangi oh i see
23:14 rangi then have to figure out what get_hostitemnumbers_of does
23:14 rangi but in a sub
23:14 maximep sure haha
23:13 rangi :)
23:13 rangi SELECT itemnumber FROM items where biblionumber = ?
23:13 rangi yeah
23:13 maximep from a biblionumber. Must exists a simpler way
23:12 rangi all we want is all itemnumbers
23:12 rangi in that CanBookBeReserved
23:12 maximep i see, haha
23:12 rangi basically i think we should not use those 2 functions
23:12 rangi yeah
23:12 maximep my 6 months of perl arent enough to quickly understand
23:12 thd What a great loss from the original once FRBR-like Koha. :(
23:12 maximep a comment or 2 in that code would help :/
23:11 rangi eeew
23:11 rangi cos it uses get_itemnumbers_of
23:11 rangi ah no it doesnt
23:11 rangi does the right thing even if the pod says it doesnt
23:11 rangi get_hostitemnumbers_of
23:10 rangi yeah thats hideous
23:10 maximep wow
23:10 maximep references on array of itemnumbers.
23:10 maximep get_hostitemnumbers_of returns a reference on a hash where key is a biblionumber and values are
23:08 thd I never paid much attention to Reddit because it lacks the significant computer technology centric focus of Slashdot. The horde has certainly left Slashdot in recent years but some extraordinarily insightful commentators still seem to contribute when I have checked even if there number has also declined.
23:08 rangi yuck
23:07 maximep so itemnumber really is $item->{$biblionumber}->[0]
23:07 rangi is wrong
23:07 rangi if not it looks like the get_itemnumbers_of
23:07 maximep };
23:07 maximep ]
23:07 maximep '224369'
23:07 maximep '167411' => [
23:07 maximep $VAR1 = {
23:07 maximep 2 sec, will paste what is $item
23:07 rangi ?
23:06 rangi so ti should be still calling it with an itemnumber
23:06 rangi ie @items is an array of itemnumbers now
23:06 rangi ?
23:06 rangi which is the same
23:05 maximep yup
23:05 rangi item should be an itemnumber in that case
23:05 rangi hmm
23:05 maximep i think
23:05 maximep well
23:05 maximep ian -_-
23:04 rangi but yeah, that should be fixed
23:04 maximep http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=823b807ac9e20706bdd3931962e126affc72cbeb
23:04 rangi it worked until your apache went OOM :-)
23:04 rangi for some def of worked ;-)
23:04 rangi so yeah it will have been broken with that change
23:04 maximep at least it worked :p
23:04 rangi and slllloooowwwww
23:04 rangi GetItemsInfo is hideos
23:03 rangi i know why then
23:03 rangi ahhh
23:03 maximep 3.2 used GetItemsInfo
23:03 maximep it uses get_itemnumbers_of and get_hostitemnumbers_of
23:03 rangi prolly can find the commit that did it, with git blame
23:03 maximep yup
23:03 rangi same in master?
23:03 maximep in 3.6
23:02 maximep wow, took me an hour to find the bug. Looks like CanBookBeReserved called CanItemBeReserved with en item instead of an itemnumber. fuuuuuuuun
23:01 rangi http://www.reddit.com/r/koha <-- we have this too
23:01 rangi http://www.reddit.com/r/AskReddit/
23:01 rangi askreddit
23:01 rangi yep
23:00 thd Does reddit have anything like 'ask slashdot'?
22:58 rangi the horde is over at reddit
22:58 thd Fortunately, I had some previously unposted text to recycle.
22:58 rangi more a small queue at a bus stop
22:58 rangi not so much a horde any more
22:58 thd I could never compose a useful reply to anything on Slashdot before the horde has left.
22:57 thd I think that I have only posted about twice ever in the past.
22:56 thd rangi: I have forgotten all my past logins, therfore, I created a new one.
22:56 rangi seeings its about 5 years since i last loggedin
22:56 rangi but id highly doubt i have any mod points
22:56 rangi id have to remember my login
22:55 thd The slashdot horde abandons topics after about two hours, therefore, my answer will have no attention from the horde.
22:52 thd If anyone has mod points on Slashdot and likes my comprehensive answer to today's library automation system question, http://ask.slashdot.org/comments.pl?sid=2604686&cid=38604004 , please mod up my answer.
22:01 rangi :)
22:01 maximep thanks, will try it to see if it helps
22:01 maximep oh wow, what a big patch
21:58 huginn 04Bug 4530: major, PATCH-Sent, ---, srdjan, ASSIGNED , Circulation & fines rules aren't always applied from most specific to less specific
21:58 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4530 <-- related maybe
21:58 rangi lemme find it
21:58 rangi about circulation rules
21:58 rangi there is one
21:55 maximep can't find it in bugzilla :S
21:54 maximep anyone know of a bug in 3.6.0 where holds use default rules instead of the cirtulation rules ?
20:49 rangi heh
20:44 cait :)
20:44 cait hi wizzyrea
20:38 rangi heya wizzyrea1
20:36 * wizzyrea1 waves
19:38 seneca thanks!
19:38 seneca yeah, we haven't been using emailings yet, so anything in there is just whatever ended up there... It'll be easier to test it with a clear queue
19:35 cait it's only nice to look them up sometimes
19:35 cait or delete those sent
19:35 cait but should be safe to truncate it
19:35 cait f
19:35 cait no way to do it from staf
19:31 seneca Does anyone know if there's a way to clear the message queue through the staff client, or is it safe to just do it from mysql?
19:25 rangi cya magnuse
19:25 magnuse good time of the day, #koha!
19:24 magnuse re: throwing things on the ground... http://en.wikipedia.org/wiki/Sinking_%28behavior%29
19:22 ibeardslee awww
19:22 rangi don't talk to me about 'IP' stuff :)
19:22 rhcl_away usually it's just a matter of disabling javascript
19:22 rangi yup
19:21 ibeardslee </rant>
19:21 ibeardslee just arse
19:21 ibeardslee I right click many articles to open in a new tab
19:21 * rangi has had this discussion with people
19:21 ibeardslee right click in firefox on the image, pops up the "can't save" message, and then get the right click menu anyway
19:21 rangi because um .. they already have
19:20 rangi and not have someone download it
19:20 rangi you cant show the image in a browser
19:20 magnuse Darth Vador?!?
19:20 ibeardslee it's a bit arse that it can be worked around anyway
19:20 rangi http://www.youtube.com/watch?v=gAYL5H46QnQ
19:20 rangi because its friday
19:19 rangi yup
19:18 rhcl_away http://static2.stuff.co.nz/1325732670/301/6218301.jpg
19:18 rangi who make them do it
19:18 rangi its usually not the developers fault .. but the 'content owners'
19:18 rhcl_away http://www.stuff.co.nz/oddstuff/6218259/Burger-chain-joins-the-dark-side
19:18 rangi yes
19:17 rhcl_away I must say that I find web developers cheap attempts to prevent viewing of images really irritating.
19:15 rangi OUCH
19:15 rangi Red zone: About 5000 homes are in this zone and can not be rebuilt. The Government has made an offer to these homeowners as part of today's announcements.
19:15 rangi but gives good explanation
19:15 rangi http://www.nzherald.co.nz/nz/news/article.cfm?c_id=1&objectid=10734019 <-- old
19:15 huginn New commit(s) needsignoff: [Bug 7407] HidePatronName not working anymore <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7407>
19:14 magnuse ouch
19:13 rangi is the short answer
19:13 rangi unsafe for humans to be there
19:13 rangi yeah, theres whole blocks in chch like that
19:12 rhcl_away rebuilding or removing due to earthquake damage apparently
19:11 rhcl_away in NZ, what does it mean to be "red zoned"?
19:11 magnuse "Pastry is the name given to various kinds of baked products made from ingredients such as flour, sugar, milk, butter, shortening, baking powder and/or eggs." http://en.wikipedia.org/wiki/Pastry
19:10 jcamins_away Different techniques is how I'd differentiate in my kitchen.
19:10 rangi :)
19:10 rangi we should ask francharb_afk and fredericd
19:09 jcamins_away Hmm.
19:09 rangi it was what is the difference
19:09 jcamins_away Bread is very important.
19:08 magnuse ah hah!
19:08 rangi fairfax own stuff.co.nz
19:08 rangi :)
19:08 rangi the office had a pointless argument about bread vs pastry the other day
19:07 magnuse fairfax?
19:07 magnuse ah, cool
19:07 rangi nope, he does www.stuff.co.nz
19:07 rangi and he knows what UNIMARC is ... so i may steal him from the fairfax team at some point
19:07 magnuse not working on koha?
19:07 rangi (florent is the newest perl developer at catalyst .. from lyon)
19:06 cait wb rangi
19:06 rangi and tell me its made wrong
19:06 rangi florent will probably arrive soon
19:06 magnuse (at least the pain au chocolat bit ;-)
19:06 rangi yes it is :)
19:06 magnuse ooh, nice!
19:05 * rangi pretends he is back in a marseille and eats a pain au chocolat and drinks a coffee for breakfast
19:05 magnuse welcome back rangi! ;-)
19:05 rangi back
19:05 magnuse seneca: have you looked at the debian packages of koha? it's an easy way to install koha, if you decide to start the install over from scratch http://wiki.koha-community.org/wiki/Koha_3.4_on_Debian_Squeeze (unless you need to install translations - that is being worked on but not ready yet)
18:59 tcohen bye #koha
18:56 jcamins_away So it would seem. :-)
18:56 cait they would have been stupid to not accept you :)
18:56 cait of course
18:56 magnuse so filling out endless forms payed off! ;-)
18:55 magnuse jcamins_away: hooray!
18:55 cait yay!!
18:55 jcamins_away cait, got the apartment.
18:55 tcohen bye rangi
18:55 rangi ok my bus stop bbiab
18:54 tcohen C4::Letter.pm told me that they are just marked as sent
18:54 seneca cool
18:53 magnuse with status = sent
18:53 magnuse yeah, looks like they stay there
18:52 cait back
18:52 tcohen not sure, i think they stay there
18:51 seneca or do they stay there?
18:51 seneca Is that db location erased when the process_message_queue script is run?
18:50 magnuse http://schema.koha-community.org/tables/message_queue.html
18:50 seneca I just didn't know where to look for them
18:50 seneca ah, so they're saved in the db, I'll look there
18:49 tcohen ?
18:49 tcohen SELECT * FROM message_queue;
18:48 seneca the overdue notices script is running without error, is there a way for me to see what messages are in the queue to be sent by Koha?
18:48 seneca Indeed ;)
18:48 seneca OK, next question:
18:47 magnuse it's all part of the fun :-)
18:47 tcohen it happens, its not a big deal really
18:45 seneca thanks all
18:45 seneca wow - I feel silly
18:45 tcohen good luck seneca
18:45 seneca They are in the crontab
18:44 tcohen just before setting the cronjobs
18:44 seneca apologies for taking everyone's time
18:44 tcohen put those variables on the cron.d/koha
18:44 seneca wow, that would do it
18:44 seneca or, I'm just on crack
18:44 seneca a minute ago...
18:44 seneca but I swear it was set
18:44 seneca no path
18:44 seneca that gives nothing
18:44 seneca ok...
18:43 seneca should it be?
18:43 tcohen echo $PERL5LIB ¿
18:43 tcohen exactly
18:43 seneca so is the command line not using the ENVs?
18:42 seneca OK, that worked... so weird
18:42 tcohen i missed an 'e' in that line
18:42 seneca I was relying on the shell ENVs that are set
18:42 seneca Let me try specifying it all in one line...
18:41 tcohen doesn't work?
18:41 tcohen PERL5LIB=/home/koha/kohaclon KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml /home/koha/kohaclone/misc/...
18:41 seneca but echo $KOHA_CONF from the command line is returning the correct file...
18:41 seneca command line
18:40 tcohen or through cron job?
18:40 seneca yeah
18:40 tcohen r u running it from command line?
18:39 seneca the overdue script in kohaclone/misc/cronjobs
18:39 tcohen what was the command you're running?
18:39 seneca Makes sense...
18:38 tcohen which is wrong
18:38 tcohen from that error I read that some script is searching fr C4/Context.pm there
18:38 seneca some
18:38 seneca Some perl system scripts or som koha scripts?
18:38 seneca Hmm...
18:37 seneca There is also, apparently from this error message, a C4 in /etc/perl...
18:37 tcohen that are using the wrong PATH
18:37 tcohen yes, BUT you have some scripts
18:37 seneca and it is
18:37 tcohen the folder C4 should be found there
18:36 tcohen PERL5LIB=/home/koha/kohaclone means
18:36 seneca I believe that path has been set since we started using this VM and Koha install... what should it be?
18:36 seneca oh?
18:35 tcohen you've messed up with your paths
18:35 seneca ?
18:35 tcohen exactly
18:35 seneca PERL5LIB=/home/koha/kohaclone
18:35 tcohen seneca: post the output of set | grep PERL5
18:33 huginn New commit(s) needsignoff: [Bug 7097] HidePatronName not hiding in all places <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7097>
18:33 rangi I've never in hmm 12 years of koha seen anyone put perl modules in /etc
18:33 rangi seneca no
18:32 sekjal it might not be as bad as I think... I'm only hearing what you're describing, and my Linux skills are < 1337, but doing a new install seems easier to me
18:32 seneca oh... So C4 in /etc is not standard?
18:31 sekjal sounds prone to introducing subtle issues
18:31 rangi eeww code in /etc
18:31 sekjal and the history you're describing, having downloaded it some years ago, then upgraded the OS
18:31 sekjal I've never seen the path /etc/perl/C4/Context.pm
18:28 seneca What's sounding complicated to you? I guess that's what I'm not understanding.
18:28 sekjal yes
18:28 seneca Then transfer the configs and the mysql db?
18:28 sekjal needlessly so
18:28 sekjal this VM you're currently using sounds... complicated
18:27 sekjal then download Koha, and run through the installation
18:27 sekjal I think starting over fresh with a stock Debian Squeeze VM is the way to go
18:27 seneca not sure I'm thinking about this correctly...
18:27 seneca OK... is there any update I need to do to Koha to make it play nice with the current Perl in Squeeze?
18:26 sekjal minimum Perl 5.10
18:26 sekjal yes
18:26 seneca But koha does use the same Perl installation as the system, right?
18:26 sekjal all the stuff that is distinctly "Koha" and not an external dependency
18:26 sekjal seneca: that's where the code library is (all the subroutines)
18:25 seneca In other words, why does it have its own C4 dir?
18:25 sekjal not knowing how bad it'd be to clean up, I'm almost inclined to recommend that you start from a fresh Debian Squeeze install
18:25 seneca How does Koha usually do it's Perl install? Does it have its own version?
18:24 seneca as there has been... but the error seems to be coming from the /etc version
18:24 sekjal it sounds like this VM may have some very strange cumulative history that you'll have to dig through
18:24 seneca there is one in there
18:24 sekjal I do git installs
18:24 sekjal seneca: that's usually where I put
18:24 seneca on=one
18:24 seneca Is C4/context.pm supposed to be the on in kohaclone?
18:23 seneca I just upgraded to squeeze (apt-get dist-upgrade) yesterday, though
18:22 seneca I downloaded the debian with koha VM a couple of years ago, and it worked for us, so we kept it.
18:22 seneca but Koha has been updated via git
18:22 seneca of what, koha? It started life as a pre-made VM
18:22 sekjal what kind of install did you do?
18:21 sekjal seeing C4/Context.pm in etc/perl is... extremely weird
18:21 seneca heh
18:21 sekjal reading further
18:21 sekjal ...
18:20 sekjal replace with what works for you
18:20 sekjal note that my path is for a git install using the default directories
18:20 sekjal seneca: sounds like you need do your "export KOHA_CONF=/home/koha/koha-dev/etc/koha-conf.xml" command
18:19 seneca hmm, thanks :)
18:19 seneca maybe that ENV needs to be changed...
18:18 seneca Is squeeze still on Perl 5?
18:18 magnuse might be, but that's beyond me, i fear - maybe rangi or sekjal would know...
18:17 seneca Is there a problem that the error is coming from the system Context.pm and not the Koha version (in kohaclone)?
18:16 seneca unable to locate Koha configuration file koha-conf.xml at /etc/perl/C4/Context.pm line 312.
18:16 seneca here's the full error message:
18:16 magnuse not sure what could cause the error then...
18:15 seneca Though...
18:15 seneca hehe
18:15 magnuse hehe, should have seen that coming ;-)
18:15 seneca that's how I just figured out the perms
18:15 seneca yeah
18:14 magnuse seneca: and you are definitely sure the file is where KOHA_CONF says it should be?
18:13 seneca same as they have been...
18:13 seneca perms are 644
18:13 seneca magnuse, yes, KOHA_CONF and PERL5LIB are both set
18:12 edveal Great
18:12 sekjal so just hide the class, and you're good
18:12 sekjal edveal: yes, it can be done. the holdqueue report has classes for each column
18:11 kf and have to leave - bbiab
18:11 magnuse seneca: do "echo $KOHA_CONF" and check that what you get matches the location of the file
18:11 kf it's possible but not sure there is a snippet for that already
18:10 edveal Question for the jquery folks gurus out there. How can I hide a column within the Holds Que report? If it is even possible.
18:10 kf hm
18:09 seneca yeah, both
18:09 wahanui magnuse: I forgot both
18:09 magnuse wahanui: forget both
18:09 wahanui both is best
18:09 kf both?
18:08 seneca though the ENV variable is set correctly (I think)
18:08 kf did you export the koha variables?
18:08 seneca "unable to locate Koha configuration file koha-conf.xml"
18:08 seneca Today, after I've installed the liblocale package, I'm getting another error when running the overdue notice script:
18:07 seneca Needed that package so that I could run the koha overdue notices script
18:07 seneca Puzzle: I upgraded from Debian lenny to squeeze yesterday, so that I could avoid the lenny EOL next month and install the liblocale package with the Currency info.
17:38 rangi that is actually pretty good!
17:38 rangi oh
17:37 oleonard Koha presents all the same challenges that any web-based software might, with the added complexity of rule #123
17:36 oleonard I'm not good at pithy one-liners, but Koha is a great project to work on because it encompasses so many different potential interests: application design, user interface design, data processing, reports
17:34 magnuse yeah 123++
17:32 kf that's good too :)
17:32 huginn rangi: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011)
17:32 rangi @quote get 123
17:32 rangi i thought 123 might work
17:31 magnuse just a database, with crazy rules
17:31 rangi lol
17:31 oleonard "Easy--just a big database!"
17:30 rangi how would you describe the koha project in one short sentence ... (it's to make the academy kids want to work on koha for their project week)
17:29 rangi ok
17:21 * oleonard shivers
17:21 huginn oleonard: Error: No such location could be found.
17:21 oleonard @wunder My office
17:20 huginn jcamins: The current temperature in APRSWXNET Jackson Heights NY US, Corona, New York is 2.2�C (11:48 AM EST on January 05, 2012). Conditions: Mostly Cloudy. Humidity: 52%. Dew Point: -7.0�C. Windchill: -1.0�C. Pressure: 29.88 in 1011.7 hPa.
17:20 jcamins @wunder 11375
17:20 huginn oleonard: The current temperature in Ohio University, Athens, Ohio is 3.0�C (12:20 PM EST on January 05, 2012). Conditions: Clear. Humidity: 63%. Dew Point: -3.0�C. Windchill: 3.0�C. Pressure: 29.91 in 1012.8 hPa (Falling).
17:20 oleonard @wunder 45701
17:16 huginn magnuse: The current temperature in Bodo, Norway is -5.0�C (5:50 PM CET on January 05, 2012). Conditions: Partly Cloudy. Humidity: 68%. Dew Point: -10.0�C. Windchill: -10.0�C. Pressure: 29.06 in 984 hPa (Rising).
17:16 magnuse @wunder boo
17:16 kf hi magnus_afk :)
17:16 magnus_afk hiya rangi and kf
17:16 kf light thunderstorm... interesting
17:16 huginn kf: The current temperature in Konstanz, Germany is 2.0�C (6:00 PM CET on January 05, 2012). Conditions: Light Thunderstorm. Humidity: 94%. Dew Point: 2.0�C. Pressure: 29.60 in 1002 hPa (Rising).
17:16 kf @wunder Konstanz
17:15 huginn rangi: The current temperature in Wellington, New Zealand is 16.0�C (6:00 AM NZDT on January 06, 2012). Conditions: Scattered Clouds. Humidity: 77%. Dew Point: 12.0�C. Pressure: 29.89 in 1012 hPa (Steady).
17:15 rangi @wunder nzwn
17:14 rangi morning
17:08 Oak time to sleep... later \o
17:04 magnus_afk yay!
17:04 Oak :)
17:04 Oak magnus
17:03 magnus_afk kia ora #koha
17:03 magnus_afk Oak
16:50 reiveune bye
16:32 * Oak goes to interview people in the street
16:30 huginn Oak: The operation succeeded.
16:30 Oak @later tell Brooke thank you thank you! :-)
16:30 Oak did you bring your laptop to work?
16:28 Oak good
16:28 kf yep
16:28 Oak do you have a rain coat with you?
16:28 Oak hmm
16:27 kf umbrella would be a bad plan - too much wind
16:26 kf heh
16:25 Oak i win
16:25 * Oak hands kf a hot cup of coffee
16:25 * jwagner hands kf an umbrella and raincoat
16:25 Oak but i know someone who does.
16:24 Oak i don't have it
16:24 Oak need umbrella?
16:24 kf but think it's getting better :)
16:24 kf thre was heavy rain
16:20 Oak kf, time to go home no?
16:00 kf I thought it might be related to holds, because the error pointed to a line where holds were dealt with for display
16:00 kf libsysguy: cool you were able to solve it
15:51 libsysguy kf I think it was just a merge error...i just deleted that file and copy/pasta from master and it works
15:36 libsysguy if you have time...the error that we were talking about the other day...with the unexpected end of input...I was wondering why you thought it would only occur on patrons with holds
15:35 kf kind of
15:35 libsysguy kf you around?
15:34 libsysguy o/
15:14 kf hi mle and vfernandes
15:07 vfernandes i'm having a little problem that someone can help me... i'm using koha 3.2.6 with UNIMARC. my problem is that searching for standard number isn't working
15:06 * mle waves
15:04 vfernandes hi koha community :)
14:42 tcohen that was an expensive task, as the marc itself is saved in the log
14:41 nengard it's nice to see that i just had to report a bug to get an answer to my question - like i said i've been asking about this for the manual for 4 years now
14:41 tcohen and the change was then logged
14:41 tcohen (the marc/marcxml stuff)
14:41 tcohen the biblio itself was modified
14:41 tcohen nengard, prior to removing items from marc/marcxml every time an item was borrowed
14:41 nengard libraries might be okay with that - whereas they won't be okay with things slowing down checkouts and such
14:41 sekjal but I don't believe it would affect circ transactions or normal response time
14:40 sekjal so accessing the log table becomes slow
14:40 sekjal nengard: I don't think it's so much an issue of slowing down transactions, as storing TONS of data
14:39 nengard but does it actually slow things down?
14:39 nengard yes, i just tested and when i checked an item out it added two lines to the cataloging log
14:33 tcohen (because we log the whole marc there)
14:33 jcamins nengard: I've never noticed any particular performance issues, though.
14:33 jcamins nengard: the warning may still be correct, then.
14:33 jcamins jwagner: thanks.
14:33 tcohen because we don't do a ModBiblio, which was reallly expensive
14:33 tcohen i think it is not a problem any more, thou
14:32 tcohen inside
14:32 tcohen logaction("CATALOGUING", "MODIFY", $itemnumber, Dumper($item)) if C4::Context->preference("CataloguingLog");
14:32 tcohen which happens to have :
14:32 tcohen jcamins, i might be wrong, but I just checked that AddIssue calls ModItem
14:31 jwagner jcamins, you forgot biblioitems from your truncate list. Also need to check for any issues or reserves.
14:31 jcamins tcohen: does it actually log anything? 3.6, it seems to me, is not logging issues in the cataloguing log.
14:30 nengard but wasn't before
14:30 nengard so it is incorrect now
14:30 jcamins nengard: I stand corrected.
14:29 tcohen jcamins: AddIssue calls ModItem which happens to do some logging
14:29 sekjal nengard: I believe it's been incorrect since 3.4 was released, and items were removed from the biblio.
14:26 jcamins In other news, updating from 3.2.2 to master takes a long time.
14:23 jcamins Fastest way to remove all auths and bibs? TRUNCATE biblio; TRUNCATE items; TRUNCATE auth_header; ?
14:22 nengard someone can correct it if we're wrong - otherwise i can update the preference text easily enough
14:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7403 normal, P5 - low, ---, paul.poulain, NEW , CataloguingLog warning incorrect
14:22 nengard bug 7403 submitted
14:20 nengard last
14:20 nengard i've asked this at least once a year for the lat 4 years!
14:19 nengard and thank you jcamins
14:19 nengard that's what i thought!!!
14:19 jcamins nengard: at least, so far as I know.
14:19 jcamins nengard: it is not correct.
14:18 nengard has anyone ever tested and confirmed the warning on the cataloguinglog preference? it says that its slows things down cause it tracks everytime the barcode is scanned - is that right? is the warning valid?
14:04 * oleonard is too loose with his Ctrl-W's
14:03 oleonard I'll bet we've got a lot that won't show up because deleteditems was broken for a while wasn't it?
14:02 oleonard whatever I was supposed to be doing this morning, now I'm deleting records with no items...
14:00 nengard makes it less useful in my opinion
14:00 nengard the action_logs table tracks who did what when - but it doesn't store the query anymore
13:59 nengard agreed
13:59 oleonard and then it shows up on circ-home
13:59 oleonard So build a circ-related report and then say, "Offer a link to this report to staff with circ permission"
13:58 oleonard Oh, you know what we need? A way to build a report and then be able to grant permission for that report to those without reports permission
13:56 oleonard Now we need a report to show who deleted that last item and forgot to delete the record ;)
13:55 oleonard nengard++ # for very useful report
13:53 jcamins oleonard: that could be a useful feature.
13:51 oleonard I really wish reports output would automatically link bib numbers (and borrowernumber, and itemnumber, etc)
13:49 nengard thanks!
13:49 nengard k
13:46 oleonard Yes, that's what I tried.
13:46 nengard brain not woking yet :)
13:46 nengard if you change NOT IN to IN ? right?
13:45 oleonard Looks to me like it's working correctly
13:43 nengard kf oleonard does that look right
13:43 nengard that should be IN not NOT IN
13:43 nengard wait
13:42 nengard i thnk this will do the trick
13:42 pastebot "nengard" at 98.114.30.184 pasted "report of bibs where last item deleted" (5 lines) at http://paste.koha-community.org/186
13:30 kf should read all first
13:30 kf what oleonard said :)
13:30 kf ... ok
13:30 kf and add a clause
13:30 kf for iwth no items
13:30 kf than do that report
13:30 kf ok
13:30 oleonard bibs with no items where biblionumber in deleted_items?
13:30 jcamins deleted_items?
13:30 nengard that has no items attached
13:30 nengard we want a bib with deleted items
13:29 nengard cause you can add a bib with no items
13:29 nengard oleonard, we don't want a bib with no items
13:26 jcamins Either that or find something that you wrote before you changed your name to Engard.
13:25 oleonard I thought that one was in the SQL library... bibs without items?
13:25 jcamins Use it for something only tangentially related.
13:25 nengard not gonna happen
13:25 jcamins Nah, I'm voting for using a pseudonym.
13:25 nengard okay - on another note - ideas on how to get a report of bib records that have had their last item deleted
13:24 kf ...
13:24 kf I think she should just keep bombing them with mails
13:24 kf lol
13:23 nengard heh
13:23 jcamins nengard: you could collaborate with bengard on a library-themed tabletop RPG, and use a pseudonym.
13:22 jcamins You could see if you can find a sympathetic NACO coordinator, though I don't think I've heard of them doing that sort of update either.
13:21 * druthb knows one NACO librarian, and he's crazy as a pet raccoon.
13:21 nengard why can't i update my own authority record
13:21 nengard what makes an LOC catalogers more skilled than me?
13:21 nengard libraries are just so damn set in their ways
13:20 nengard that's insane, i have built brand recognition with my name, i'm not gonna change it cause LOC has stupid rules
13:19 jcamins Less expensive. Legally changing your name costs money, and nengard would have to do it twice.
13:19 kf hmm
13:19 kf oh
13:19 * jcamins would probably go with the pseudonym option.
13:19 jcamins Yeah, pseudonym would work too.
13:19 kf ...
13:19 kf artist's name
13:19 kf or a pseudonym
13:19 kf hm
13:19 jcamins I'm not even sure if they'll change the details then.
13:18 nengard and i don't mind the LOC won't do that - i know it's a lot of work - but they should provide a tool for other catalogers to do it and make it official
13:18 kf are you suggesting she should ge a divorce?
13:18 kf lol
13:18 jcamins nengard: right, the only thing you can do is change your name.
13:18 nengard I want the details on my record changed
13:18 nengard I don't want my name changed
13:18 oleonard Ocelot
13:17 jcamins Name Authority Cooperative O-something.
13:17 * oleonard is still boggling at the fact that nengard can't get her authority record updated
13:17 kf NACO?
13:15 jcamins nengard: the only way you're going to get your record updated is if you change your name, or get a NACO library to catalog something that you wrote under a different name.
13:14 jcamins Ah.
13:13 kf or my coworker did after I asked her nicely :)
13:13 kf http://pollux.bsz-bw.de/DB=2.1/PPNSET?PPN=30945400X&INDEXSET=1
13:13 kf jcamins: nope, only updated the pnd record :)
13:13 jcamins LC doesn't update authorities.
13:13 jcamins How on earth did she do that?
13:12 jcamins nengard: and kf managed to update it?
13:12 nengard jcamins LOC won't update my authority
13:10 jcamins Apparently cloning VMs is really slow.
13:08 jcamins What's going on with authorities? :)
13:07 kf it's your fault I learned something about authorities today :)
13:06 nengard oh! got it
13:06 kf so.. formally it's right
13:06 kf nengard: it's because that is linked to literary studies
13:06 kf nengard: we checked that
13:05 jcamins Cool! The new VirtualBox includes the option to clone VMs!
13:04 nengard I guess the only thing that's not right is that I'm not a linguist :)
13:04 nengard kf thanks for updating my authority!!!
13:03 nengard i updated the url
13:03 nengard but i was able to comment
13:03 nengard jcamins me either
13:01 jcamins Good morning.
13:00 jcamins I don't have a Slashdot account.
13:00 druthb g'morning, jcamins
12:59 * druthb wonders when other #koha-ites will jump on http://ask.slashdot.org/story/12/01/05/0415249/ask-slashdot-tech-for-small-library-automation
12:53 druthb o/
12:19 kf hi AmitG
12:06 AmitG heya kf :D
11:55 kf mib_45i41s: the 2 prefs are independent - if you want to send out notices for newly created accounts - then set it to 'Send' - or leave it off
11:54 kf mib_45i41s: sorry, got distracted
11:54 kf no it doesn't
11:32 mib_45i41s I know that sounds like a silly question!
11:32 mib_45i41s kf: sorry, one last question. Should I chang it to "Send" or "Don't Send" to "First Valid"?
11:25 kf so if it was set to alternate and you have your email addresses in the first email field - it wouldn't work
11:25 kf it started being used for that and is now being used for pretty much all notices
11:25 mib_45i41s Ah - cool. thanks......I will try it out
11:25 kf but will be in a later version
11:25 kf we fixed that
11:25 kf the description is wrong
11:25 kf it does
11:24 mib_45i41s kf: The description of that syspref says it is related to "emailing newly created patrons".....could that effect overdues?
11:21 kf perhaps it helps
11:21 mib_45i41s OK, thanks. I will try.
11:21 kf mib_45i41s: perhaps try setting the syspref to 'first valid'
11:20 kf mib_45i41s: what is your setting for the syspref? and yes, email addresses are stored in the patron records - but there are different fields
11:20 kf mib_45i41s: other mails like item due reminders
11:18 * paul_p head for lunch. See you later !
11:18 mib_45i41s as far as I know the email overdues are the only thing not sending. The local mail system can send external mail fine
11:18 mib_45i41s email address will be in the borrower record?
11:17 kf and the overdues are the only maisl not being sent out?
11:17 kf where do you store the email address?
11:17 mib_45i41s kf: what should that syspref be set to?
11:16 kf there can also be another reason for your problem - but it's the only idea I can provide
11:15 kf but that the program can not find a valid email address could be one
11:15 kf it can be another problem that keeps your mails from not sending out
11:14 kf would check it
11:14 kf I woule check it
11:14 mib_45i41s OK. Would that change from 3.4 to 3.6? in the upgrade?
11:14 kf it's used for mails in general
11:14 kf it's not only used for newly created patrons, the display and description are wrong here
11:14 kf AutoEmailPrimaryAddress
11:13 kf it's the first thing I would check
11:13 kf will look the name up
11:13 kf sorry
11:13 kf yes
11:12 mib_45i41s kf: "autoemailsomething" ? is that a syspref?
11:08 kf it's probably set to the wrong value and finding now emailaddress
11:08 kf check your setting for autoemailsomething
10:50 mib_45i41s Would anyone know why all email overdue notices might show "failed" for all users since upgrading to 3.6.0? Local/remote mail system is fine.
08:56 mib_45i41s Would anyone know why all email overdue notices might show "failed" for all users since upgrading to 3.6.0? Local/remote mail system is fine.
08:34 kmkale Namaste kf :)
08:32 kf hi kmkale :)
08:30 huginn kmkale: Quote #89: "<owen> We defy stereotypes: We're not afraid of commitment!" (added by jwagner at 04:32 PM, August 19, 2010)
08:30 kmkale @quote random
08:29 kmkale Namaskaar #koha
08:27 rangi http://git.catalyst.net.nz/gw?p=koha.git;a=commitdiff;h=c1f2fe6fc593ec75b590fad3daf8889111d4db62
08:24 mbalmer howdy!
08:22 sophie_m hello #koha
08:19 kf back
08:12 asaurat hi
08:03 francharb hello
08:01 mle : )
08:01 matts hi !
08:01 mle morning
07:58 julian_m hello
07:54 paul_p hello world
07:52 reiveune hello
07:43 cait bbiab
07:38 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.7�C (8:34 AM CET on January 05, 2012). Conditions: Light Rain Showers. Humidity: 86%. Dew Point: 3.0�C. Windchill: 2.0�C. Pressure: 29.76 in 1007.7 hPa (Falling).
07:38 cait @wunder Konstanz
07:30 rangi http://search.cpan.org/~scott/Template-Plugin-XSLT-1.2/XSLT.pm
05:33 AmitG heya cait and kmkale
04:57 cait but why is it worrying you? :)
04:57 cait hm might be true
04:57 bag I think I catch you as cait more often than I talk with you as kf
04:57 bag hey cait - what's happening
04:55 bag :)
04:55 bag hi there kmkale
04:48 rangi my stop bbiab
04:46 huginn rangi: The current temperature in Wellington, New Zealand is 18.0�C (5:00 PM NZDT on January 05, 2012). Conditions: Mostly Cloudy. Humidity: 68%. Dew Point: 12.0�C. Pressure: 29.89 in 1012 hPa (Steady).
04:46 rangi @wunder nzwn
04:46 cait lol
04:45 bag bummer
04:45 huginn bag: Error: No such location could be found.
04:45 bag @wunder current location
04:45 huginn bag: The current temperature in K6LCM-Westside/Mesa, Santa Barbara, California is 11.5�C (8:45 PM PST on January 04, 2012). Conditions: Clear. Humidity: 82%. Dew Point: 9.0�C. Pressure: 30.16 in 1021.2 hPa (Rising).
04:45 bag @wunder 93109
04:45 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 5.9�C (5:40 AM CET on January 05, 2012). Conditions: Overcast. Humidity: 64%. Dew Point: -0.0�C. Windchill: 3.0�C. Pressure: 29.83 in 1010.0 hPa (Falling).
04:45 cait @wunder Konstanz
04:28 bag heya AmitG
03:56 AmitG heya bag :D
02:56 Brooke o/
01:51 huginn New commit(s) needsignoff: [Bug 5786] Move AllowOnShelfHolds system preference to the Circulation Matrix <http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5786>