IRC log for #koha, 2007-02-10

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

All times shown according to UTC.

Time Nick Message
17:39 cht hi all
17:40 chris hi chris
17:41 hows fiji?
17:45 cht hi chris
17:45 things are good here
17:46 chris excellent
17:46 cht (i am using a irc.cgi gateway that is a little sluggish)
17:46 chris ahhh right
17:46 cht you are answering my notes before i see them posted  ;)
17:46 chris heh
17:47 cht but, boy do i have a koha issue for you!
17:47 :)
17:48 chris heh
17:48 cht cook islands, koha 2.2.6, mysql5, no remote access...
17:48 (you will recall the scenario)
17:48 chris yep
17:49 cht a few likely related things all centring around issuing...
17:50 1. the rules in the * column of the issuing grid seem to trump the rules in other columns...
17:50 chris hmm thats odd
17:50 cht there's more....
17:51 2. three factor loan/fine data (i.e. "1,7,1") entered in the second part of a grid box once submitted shows as only two factors (i.e. "1.000000,7")...
17:51 and 3. fines2.pl seems to do absolutely nothing
17:52 chris weird, i havent seen any of those issues
17:52 cht could it have something to do with all of the tweaks we made to queries to support mysql 5?
17:52 chris could be
17:52 more likely some tweak we didnt make
17:53 cht possibly?
17:54 would it be in inssuingrules.pl?
17:54 chris might be
17:54 cht issuingrules.pl?
17:54 chris there sounds 2 different issues
17:54 cht i have a replica of their environment running here now
17:54 chris 2 will be causing 3
17:55 cht based on the backups that i took while there
17:55 right
17:55 chris but not sure about 1
17:55 that will be something in C4/Circulation/Circ2.pm
17:55 cht k
17:56 chris in sub getLoanLength
17:56 cht let me note that
17:57 chris you can see the way its supposed to work
17:57 it does
17:57 borrowertype, itemtyep, branch
17:57 no match for that it tries
17:58 borrowertype, itemtype
17:58 then
17:58 borrwertype, *, branch
17:58 *, itemtype, branch
17:58 borrwertype,*
17:58 *,*,branch
17:59 *,itemtype
17:59 and finally
17:59 *,*
17:59 and as a catchall, 21
17:59 cht right
17:59 chris thats the way it should be working
18:00 so you could look at getLoanlength
18:00 and try some of those queries in mysql directly
18:00 cht i understand there is some bug with 2.2.6 where the whole grid must be filled in? so i filled in the whole default grid (the one branch grid is blank)
18:00 chris yep, i remember something like that too
18:00 cht and i will try what you suggested
18:01 should i try filling in the whole branch grid to see what happens?
18:01 chris if the mysql results seem to be right
18:01 then yep could try that
18:02 cht k
18:02 as for the other one...
18:03 chris you have checked the data in the database, and its being stored incorrectly right?
18:03 for the 2nd one?
18:03 cht i had a plan to look directly at the db tables and see if the third factor is getting stored...
18:03 yup...
18:03 and to do a little audit of issuingrules.pl
18:04 chris yep
18:04 that would be my plan of attack
18:04 cht k
18:05 valuable advice, thank you
18:05 one more thing...
18:05 chris yep?
18:05 cht i noticed one other strange behavior...
18:06 when adding a new borrower, a few fields get prepopulated...
18:06 chris right
18:06 they might be coded into the template
18:06 or, if its the member number
18:07 cht last name gets somebody's name in it, the town get filled in as "Rarotonga", and the registration and expiry dates get filled in with useless dates
18:07 chris hmm thats odd, right check the database
18:07 is there a user with borrowernumber=0
18:07 cht ah, it could possibly be the automatically populated serial member number
18:08 chris yep, could try turning that off too in system preferences
18:08 cht can you give me a quick query for that, my sql sucks
18:09 rch (to interject)
18:10 chris select * from borrowers where borrowernumber=0l
18:10 sorry
18:10 select * from borrowers where borrowernumber=0;
18:10 even
18:10 rch (btw, thx for the help on acqui, chris)
18:10 chris yeah it should just use the default one
18:11 rch: did it work? i wrote it in an email, so id expect i made a couple of syntax errors :)
18:11 cht rch: thanks
18:11 rch chris: yep, it's working reasonably well
18:11 chris cht: it should be amount,first fine date, recurring period
18:12 cool
18:12 cht sorry, i got booted
18:12 i missed the last couple of comments
18:13 how do i talk to logbot?
18:13 chris http://irc.koha.org
18:14 http://koha.org/cgi-bin/logs.p[…]saveas=&save=save
18:14 thats the last 5 minutes :)
18:15 cht cool
18:17 well, i'll go try these things and see what happens
18:18 chris cool
18:31 mason hiya paul
19:36 thd chris: you seemed to know something about tumer's problems for committing to Koha.
19:37 chris: Is the reason tumer needs a separate branch exclusively related to his problems committing to the CVS server?
19:37 chris i did??
19:37 no idea
19:37 thd chris: read the last to messages on the koha-devel list.
19:38 chris yeah i have no idea about what tumers problems are
19:39 thd chris: I was about to give a lengthy reply but I wanted to know if I missed something important before posting my possible misunderstanding of the issue.
19:39 chris i dont know what the issue is, so couldnt possibly say
19:39 thd tanks chris
19:40 s/tanks/thanks/
21:53 cht yo, chris
21:54 are your eyes glued to the irc window?
21:58 chris hi
09:13 toins hi all

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

koha1