← 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/cgi-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/cgi-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/cgi-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/cgi-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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/modules/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/cgi-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