IRC log for #koha, 2007-02-23

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
11:52 owen Anyone around?
11:54 kados back
11:54 owen Hey. I'm wondering what the best way is to accomplish something:
11:54 Given a list of biblio numbers, how to find out who might have any of them checked out.
11:54 kados hmmm
11:54 first need to find the itemnumbers
11:54 then find current issues in items table
12:01 owen I can think of convoluted scripted ways of doing it, but I'm wondering if I'm missing a simple method. Maybe not :)
12:06 kados owen: where's the list of biblios coming from?
12:07 owen I'm trying to get a list of MORE items that are in circulation. I did a few queries of the biblio table based on the various MORE naming schemes in use at various times and came up with a list that I saved
12:08 Now I'm looping over that list in a php script and pulling out results for each biblionumber one at a time. Seems to be working okay.
12:09 kados gotcha ... yea, I can't think of an easier way
12:09 other than maybe perl ;-)
12:10 (you could actually automate the whole process by saving your searches in the script too ;-)
12:17 owen: why don't we have an itemtype for MORE items?
12:18 owen Two reasons: 1. To keep the MORE itemtype out of the public search interface. 2. To keep item type statistics accurate (i.e. get a real count of which MORE items are books and which are DVDs etc.)
12:27 I'm sure they do
12:27 We count the circs for the items we lend
12:28 kados so MORE is really just a way to increase state-wide statistics then :-)
12:28 what will these librarians think of next? :-)
12:49 cm hey, rch, are you busy?
13:01 rch hi cm
13:01 what's up?
13:10 hdl: are you available?
13:10 hdl yes
13:10 hi
13:10 rch i have another installer question
13:11 is the sql up to date in the fr dir?
13:12 hdl Not at the moment.
13:12 Should be updated VERY soon.
13:13 (the frameworks here are outdated.)
13:13 rch will you define an auth_type with authtypecode = '' ?
13:14 hdl You need one.
13:14 rch right.
13:14 hdl if not you cannot easily create new authtypes.
13:14 In fact, we should add 4 or 5 of them.
13:15 - Subject
13:15 - Personnal names
13:15 - Places
13:15 - Editors
13:15 - Collective names
13:15 rch right, we hope to get a set defined sometime soon.
13:16 hdl + titles
13:16 rch i guess the issue is that the insert into auth_types must be in same file, before any inserts into auth_tag/subfields.
13:18 but there should not be any problems with insert into auth_types authtypecode='' tagtoreport='' ?
13:18 hdl No. I would make One file for each authtype.
13:19 rch because the auth_type must be defined first to fulfill the foreign key constraints.
13:19 hdl IMHO, i think that tagtoreport could be defaulted to 250 (Subjects)
13:20 rch would an undefined tagtoreport cause a problem?
13:20 hdl I don't think so. But I prefer adding one :D
13:20 just in case.
13:21 A too hurried user tries to make a new type and has Nothing.
13:25 rch makes sense.
13:25 hdl: i like the installer, btw :)
13:26 hdl thx
16:08 cm hi rch, I'm back.
16:09 I ran the updatedatabase script yesterday like you suggested.
16:10 Is it supposed to rename a bunch of the fields in borrowers?  Now it seems like a few things are broken, like issuing.
16:10 rch hmm.
16:10 cm horray for backups, at least.  ;)
16:10 I can send you the output if you want to see it.
16:11 rch okay, so i'm relieved at lease that you have a backup...
16:11 cm i've learned the hard way!
16:11 i can revert everything if need be, but it looks like the updater does some useful stuff, so I didn't want to undo it all.
16:11 rch let me take a look at the script...
16:12 cm ok.  I'll email you the output so you can see what it did.
16:12 rch ok
16:13 cm it's sent.
16:14 rch yeah, it looks like some of the rel_3 stuff is in there.
16:14 changes to borrwers table, mostly.
16:14 not sure how/why
16:15 cm yeah, I thought so.
16:15 rch short term fix, revert, and add 'confirmissuescharge' systempref manually.
16:16 i'll look into fixing updatedatabase.
16:16 cm okay.  anything else in there i should do?
16:16 s/do/add
16:16 rch i don't think so.
16:16 cm okay, thanks!
16:17 rch sorry about that ...
16:17 cm s'okay.
16:17 rch i'll let you know when updatedatabase is safe.
16:17 cm alright.  :)
16:30 hmm...I reverted it and added the confirmissues pref manually.  I'm still getting errors on circulation.pl:
16:30 [Wed Feb 21 14:28:09 2007] [error] [client 192.168.1.210] "my" variable $issued_itemtypes_loop masks earlier declaration in same scope at /usr/local/koha/intranet/c​gi-bin/circ/circulation.pl line 334., referer: http://circ.ccfls.org/cgi-bin/[…]l?tab=Circulation
16:30 [Wed Feb 21 14:28:12 2007] [error] [client 192.168.1.210] "my" variable $issued_itemtypes_loop masks earlier declaration in same scope at /usr/local/koha/intranet/c​gi-bin/circ/circulation.pl line 334., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
16:30 [Wed Feb 21 14:28:12 2007] [error] [client 192.168.1.210] Date::Calc::Date_to_Days(): not a valid date at /usr/local/koha/intranet/c​gi-bin/circ/circulation.pl line 142., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
16:30 [Wed Feb 21 14:28:12 2007] [error] [client 192.168.1.210] Premature end of script headers: circulation.pl, referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
16:31 Could it be something in the latest Circ2.pm?
16:32 I've got to go to a meeting.  :(
17:02 rch cm: I think the problem is in the Date_to_Days();
17:02 I don't see such an error.
17:03 is circulation.pl up to date?
17:05 sean68rs hi all...what's the quickest way to add an intranet user (staff) to 2.2.7?  I don't want our testers using the kohaadmin creds
18:12 cm rch: it's the one from jan. 25.
18:13 sean68rs:  add a borrower account for them, assign them a password, then modify their privileges so they can circulate books, etc.
18:15 you can change the password & modify privledges from moremember.pl.
18:31 hdl rch :
18:32 I had such errors not a valid date.
18:33 Date::Calc takes (year, month, day) arrays.
18:33 But the date must be valid.
18:33 Maybe month or day is null.
18:34 Maybe somthing has to be checked.
18:37 cm hi hdl.  I'm using dev_week.
18:37 or do you mean the version of Date::Calc?
18:38 hdl no koha version.
18:39 try and display your date before using Date_to_days. (add a warn in Circ2)  And you may find what is guilty.
18:39 cm good idea.  and goodnight, hdl.  :)
18:42 well, that produced a lot:
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] "my" variable $issued_itemtypes_loop masks earlier declaration in same scope at /usr/local/koha/intranet/c​gi-bin/circ/circulation.pl line 334., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in numeric gt (>) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 1287., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in numeric lt (<) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 1287., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Use of uninitialized value in bitwise and (&) at /usr/local/koha/intranet/mod​ules/C4/Circulation/Circ2.pm line 240., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Date::Calc::Date_to_Days(): not a valid date at /usr/local/koha/intranet/c​gi-bin/circ/circulation.pl line 142., referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:42 [Wed Feb 21 16:40:34 2007] [error] [client 192.168.1.210] Premature end of script headers: circulation.pl, referer: http://circ.ccfls.org/cgi-bin/[…]rc/circulation.pl
18:43 sorry about all that garbage.  :(
05:25 hdl cm thanks

← Previous day | Today | Next day → | Search | Index

koha1