| Time |
S |
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 |
|
owen |
Given a list of biblio numbers, how to find out who might have any of them checked out. |
| 11:54 |
|
kados |
hmmm |
| 11:54 |
|
kados |
first need to find the itemnumbers |
| 11:54 |
|
kados |
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 |
|
owen |
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 |
|
kados |
other than maybe perl ;-) |
| 12:10 |
|
kados |
(you could actually automate the whole process by saving your searches in the script too ;-) |
| 12:17 |
|
kados |
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 |
|
owen |
I'm sure they do |
| 12:27 |
|
owen |
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 |
|
kados |
what will these librarians think of next? :-) |
| 12:49 |
|
cm |
hey, rch, are you busy? |
| 13:01 |
|
rch |
hi cm |
| 13:01 |
|
rch |
what's up? |
| 13:10 |
|
rch |
hdl: are you available? |
| 13:10 |
|
hdl |
yes |
| 13:10 |
|
hdl |
hi |
| 13:10 |
|
rch |
i have another installer question |
| 13:11 |
|
rch |
is the sql up to date in the fr dir? |
| 13:12 |
|
hdl |
Not at the moment. |
| 13:12 |
|
hdl |
Should be updated VERY soon. |
| 13:13 |
|
hdl |
(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 |
|
hdl |
In fact, we should add 4 or 5 of them. |
| 13:15 |
|
hdl |
- Subject |
| 13:15 |
|
hdl |
- Personnal names |
| 13:15 |
|
hdl |
- Places |
| 13:15 |
|
hdl |
- Editors |
| 13:15 |
|
hdl |
- 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 |
|
rch |
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 |
|
hdl |
just in case. |
| 13:21 |
|
hdl |
A too hurried user tries to make a new type and has Nothing. |
| 13:25 |
|
rch |
makes sense. |
| 13:25 |
|
rch |
hdl: i like the installer, btw :) |
| 13:26 |
|
hdl |
thx |
| 16:08 |
|
cm |
hi rch, I'm back. |
| 16:09 |
|
cm |
I ran the updatedatabase script yesterday like you suggested. |
| 16:10 |
|
cm |
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 |
|
cm |
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 |
|
cm |
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 |
|
rch |
changes to borrwers table, mostly. |
| 16:14 |
|
rch |
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 |
|
rch |
i'll look into fixing updatedatabase. |
| 16:16 |
|
cm |
okay. anything else in there i should do? |
| 16:16 |
|
cm |
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 |
|
cm |
hmm...I reverted it and added the confirmissues pref manually. I'm still getting errors on circulation.pl: |
| 16:30 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
Could it be something in the latest Circ2.pm? |
| 16:32 |
|
cm |
I've got to go to a meeting. :( |
| 17:02 |
|
rch |
cm: I think the problem is in the Date_to_Days(); |
| 17:02 |
|
rch |
I don't see such an error. |
| 17:03 |
|
rch |
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 |
|
cm |
sean68rs: add a borrower account for them, assign them a password, then modify their privileges so they can circulate books, etc. |
| 18:15 |
|
cm |
you can change the password & modify privledges from moremember.pl. |
| 18:31 |
|
hdl |
rch : |
| 18:32 |
|
hdl |
I had such errors not a valid date. |
| 18:33 |
|
hdl |
Date::Calc takes (year, month, day) arrays. |
| 18:33 |
|
hdl |
But the date must be valid. |
| 18:33 |
|
hdl |
Maybe month or day is null. |
| 18:34 |
|
hdl |
Maybe somthing has to be checked. |
| 18:37 |
|
cm |
hi hdl. I'm using dev_week. |
| 18:37 |
|
cm |
or do you mean the version of Date::Calc? |
| 18:38 |
|
hdl |
no koha version. |
| 18:39 |
|
hdl |
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 |
|
cm |
well, that produced a lot: |
| 18:42 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
[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 |
|
cm |
sorry about all that garbage. :( |
| 05:25 |
|
hdl |
cm thanks |
