IRC log for #koha, 2007-04-16

All times shown according to UTC.

Time S Nick Message
00:14 Mitch Is anyone around that might possibly help out with a question?
00:14 kados hi Mitch
00:14 Mitch I am using Koha 2.2.7
00:15 Mitch I have added a branch, borrower, and book with a barcode sucessfuly
00:15 Mitch How ever I am getting a glitch
00:16 Mitch when I issue a book to a patron it neither shows up in there main issed screen nor  on my screen with the issues list
00:16 kados hmmm, that sounds familiar
00:17 Mitch How ever I can see all reserve and issued books info on the patrons page
00:17 kados yea
00:17 Mitch I just can see it in the circulation:issues page
00:17 Mitch on admin nor the main issues page of the user
00:18 Mitch Thanks ahead of time for helping
00:18 kados I've definitely seen that before
00:18 kados I'm trying to remember why it happens
00:18 Mitch cool
00:18 Mitch ok take your time I will keep reading
00:18 Mitch and testing
00:19 kados any errors in the log?
00:19 kados it's something to do with the dates I think
00:19 Mitch due dates?
00:19 Mitch or user dates
00:19 kados dates that things were checked out
00:20 Mitch k one sec I will try a few changes
00:20 kados it's gonna be in how the 'todayissues' vs 'previousissues' is calculated
00:20 Mitch I made the due date 06/05/2007
00:21 Mitch when Issued it
00:21 kados ok, think I found it
00:21 kados take a look at circulation.pl
00:22 kados around line 227 or so
00:22 kados    foreach my $it (keys %$issueslist) {
00:22 kados        my $issuedate = $issueslist->{$it}->{'timestamp'};
00:22 Mitch in intranet
00:22 kados        if ($todaysdate == $issuedate) {
00:22 kados            push @todaysissues, $issueslist->{$it};
00:22 kados        } else {
00:22 kados            push @previousissues, $issueslist->{$it};
00:22 kados        }
00:22 kados yea, in intranet/cgi-bin/circ/
00:24 Mitch I have intranet/cgi-bin/koha
00:24 Mitch no circ
00:24 kados well how about intranet/cgi-bin/koha/circ ?
00:25 Mitch C:\usr\koha227\intranet\modules\C4\Circulation
00:25 Mitch is that is
00:25 Mitch it'
00:25 kados nope, not modules
00:25 Mitch ah yep
00:25 Mitch intranet/cgi-bin/koha/circ
00:26 kados cool
00:26 kados so something about the way that the dates are being represented
00:26 kados check around line 227
00:26 Mitch k I have it opened in word pad I am not very proficent at perl what do I neet to do with the code
00:26 kados you should see that foreach loop I pasted above
00:27 kados let me know when you find it
00:27 Mitch k one sec
00:28 Mitch is it the one in the BUILD HTML about 10 lines down
00:28 kados nope
00:28 kados it's on line 227
00:28 kados or around there
00:29 kados do a search for 'issuedate'
00:29 kados I think notepad has a find, right?
00:29 Mitch I am using word pad and Ctrl-F is to search for it
00:29 Mitch # split in 2 arrays for today & previous
00:29 Mitch foreach my $it (keys %$issueslist) {
00:29 Mitch my $issuedate = $issueslist->{$it}->{'timestamp'};
00:29 Mitch $issuedate = substr($issuedate, 0, 8);
00:29 Mitch if ($todaysdate == $issuedate) {
00:29 Mitch push @todaysissues, $issueslist->{$it};
00:29 Mitch } else {
00:29 Mitch push @previousissues, $issueslist->{$it};
00:29 Mitch }
00:29 kados there ya go
00:29 Mitch is that it
00:30 kados ok, so what's happening
00:30 kados my $issuedate = $issueslist->{$it}->{'timestamp'};
00:30 kados that means that the value of the timestamp is being stored in the variable $issuedate
00:30 kados if ($todaysdate == $issuedate) {
00:30 Mitch yep I understand moderate vb so I know terms
00:31 kados that means 'if the variable $todaysdate equals the variable $issuedate, execute the follwoing block'
00:31 Mitch k
00:31 kados so my guess is that the timestamp isn't in the same date format as the $todaysdate
00:31 kados so it's not evaluating as true
00:32 Mitch k I am running it on windows XP also
00:32 Mitch I know the Now() code from v
00:32 Mitch vb
00:32 kados right
00:33 kados so what we're gonna do is add two lines right after:
00:33 Mitch basicly your saying its not listing because of the fact that the dates arenot equaling
00:33 kados my $issuedate = $issueslist->{$it}->{'timestamp'};
00:33 kados put in:
00:33 kados warn "Issuedate:".$issuedate;
00:33 kados warn "Todaysdate:".$todaysdate;
00:34 kados then issue something and you should have some warnings in your apache logs
00:34 kados Mitch: right, that's what I'm saying
00:34 kados so first lets confirm that
00:34 Mitch same place
00:34 Mitch replace the issuedate line
00:34 Mitch or just onder neith
00:34 kados don't replace anything
00:34 kados just add two more lines
00:35 Mitch ok just add ok just under the issuedate
00:35 kados yep
00:37 Mitch k added I will attempt to issue a book again
00:37 Mitch then I will see if I can find the error log for appache and tell you what it says
00:37 kados cool
00:37 chris the annoying thing with windows
00:37 chris you cant open the error log cos it will say its in use
00:39 Mitch oh ok hmm well I have placed those 2 code in awaiting further instructions
00:40 Mitch I appreciate all the help kados and chris(That guide realy help up to this point
00:40 Mitch helped out'
00:43 kados hmmm
00:43 kados so chris, hw can Mitch look at the log?
00:43 kados does he have to stop apache?
00:43 Mitch I am using this to help out a non forprofit library its the project os for my senior project I am to develop a screen shot user guide.
00:43 kados Mitch: cool
00:44 Mitch I am willing to send the basic user guide once completed to be used for koha users.
00:44 chris yeah usually on windows you ahve to stop apache
00:44 Mitch its these tiny glitches that get me scraching my head
00:44 Mitch :-)
00:44 Mitch I can do that
00:44 chris (windows isnt a good OS to run a server on)
00:44 Mitch np
00:44 Mitch yeah I know but thats all they ahve
00:44 chris yep
00:44 Mitch so I am making due
00:45 chris the main thing is it doesnt really support multiple users ie only one thing can have a file open at once .. im sure in the really expensive server versions they fixed it
00:46 chris but you can get round it, by stopping apache, readin the log, starting it again
00:46 Mitch I will note all of this in the user manual that I am making
00:47 Mitch I have stoped apache where do I find the error log
00:48 Mitch found it
00:48 Mitch start>apache>logs>error log
00:49 Mitch actually server logs the review error log
00:50 Mitch is that the correct file?
00:51 Mitch I am going to list what is in file don't mean to spam its not to long
00:51 Mitch [Thu Apr 05 11:03:49 2007] [notice] Apache/2.0.59 (Win32) configured -- resuming normal operations
00:51 Mitch [Thu Apr 05 11:03:49 2007] [notice] Server built: Jul 27 2006 15:55:03
00:51 Mitch [Thu Apr 05 11:03:49 2007] [notice] Parent: Created child process 396
00:51 Mitch [Thu Apr 05 11:03:51 2007] [notice] Child 396: Child process is running
00:51 Mitch [Thu Apr 05 11:03:51 2007] [notice] Child 396: Acquired the start mutex.
00:51 Mitch [Thu Apr 05 11:03:51 2007] [notice] Child 396: Starting 250 worker threads.
00:51 Mitch [Thu Apr 05 11:55:19 2007] [notice] Parent: Received restart signal -- Restarting the server.
00:52 Mitch [Thu Apr 05 11:55:20 2007] [notice] Child 396: Exit event signaled. Child process is ending.
00:52 Mitch [Thu Apr 05 11:55:21 2007] [notice] Child 396: Released the start mutex
00:52 Mitch [Thu Apr 05 11:55:24 2007] [notice] Apache/2.0.59 (Win32) configured -- resuming normal operations
00:52 Mitch [Thu Apr 05 11:55:24 2007] [notice] Server built: Jul 27 2006 15:55:03
00:52 Mitch [Thu Apr 05 11:55:24 2007] [notice] Parent: Created child process 992
00:52 Mitch [Thu Apr 05 11:55:28 2007] [notice] Child 992: Child process is running
00:52 Mitch [Thu Apr 05 11:55:28 2007] [notice] Child 992: Acquired the start mutex.
00:52 Mitch [Thu Apr 05 11:55:28 2007] [notice] Child 992: Starting 250 worker threads.
00:52 Mitch [Thu Apr 05 11:55:35 2007] [notice] Child 396: Waiting for 250 worker threads to exit.
00:52 Mitch [Thu Apr 05 11:55:35 2007] [notice] Child 396: All worker threads have exited.
00:52 Mitch Actually todays posts are
00:52 Mitch [Sun Apr 15 19:43:24 2007] [notice] Parent: Received shutdown signal -- Shutting down the server.
00:52 Mitch [Sun Apr 15 19:43:24 2007] [notice] Child 248: Exit event signaled. Child process is ending.
00:52 Mitch [Sun Apr 15 19:43:25 2007] [notice] Child 248: Released the start mutex
00:52 Mitch [Sun Apr 15 19:43:29 2007] [notice] Child 248: Waiting for 250 worker threads to exit.
00:52 Mitch [Sun Apr 15 19:43:29 2007] [notice] Child 248: All worker threads have exited.
00:52 Mitch [Sun Apr 15 19:43:29 2007] [notice] Child 248: Child process is exiting
00:52 Mitch [Sun Apr 15 19:43:29 2007] [notice] Parent: Child process exited successfully.
00:52 Mitch Thats it
00:53 chris you want the koha apache error log,
00:53 chris which on linux would be
00:53 chris /usr/local/koha/log/
00:53 chris in there
00:53 chris is there a cc
00:54 chris sorry c:\usr\local\koha\log dir?
00:55 Mitch Admin dir of windows is C:\usr\koha227\intranet\cgi-bin\koha
00:56 Mitch User dir C:\usr\koha227\opac\cgi-bin\koha
00:56 chris is there a usr\koha227\log ?
00:57 Mitch there is a backup, intranet, opac, misc, scripts
00:57 Mitch in the Koha227 dir
00:58 Mitch is there a specific file name
00:58 chris i wonder where it logs to on windows
00:58 Mitch I could just search fo rit
00:58 chris who knows on windows
00:59 chris can you find the koha-httpd.conf file?
00:59 chris and look at that, and hopefully that should tell you where its loggin to
01:00 Mitch in C:\usr\koha227\backup there is a gttpd file
01:00 Mitch httpd'
01:01 chris hmm
01:01 Mitch #
01:01 Mitch # This is the main Apache server configuration file.  It contains the
01:01 Mitch # configuration directives that give the server its instructions.
01:01 Mitch # See <URL:http://httpd.apache.org/docs/2.0/> for detailed information about
01:01 Mitch # the directives.
01:01 chris probably not that one
01:01 Mitch is that ir
01:01 Mitch it
01:01 Mitch # Based upon the NCSA server configuration files originally by Rob McCool.
01:01 Mitch #
01:01 Mitch # Configuration and logfile names: If the filenames you specify for many
01:01 Mitch # of the server's control files begin with "/" (or "drive:/" for Win32), the
01:01 Mitch # server will use that explicit path.  If the filenames do *not* begin
01:01 Mitch # with "/", the value of ServerRoot is prepended -- so "logs/foo.log"
01:01 Mitch # with ServerRoot set to "C:/Program Files/Apache Group/Apache2" will be interpreted by the
01:01 Mitch # server as "C:/Program Files/Apache Group/Apache2/logs/foo.log".
01:01 Mitch # NOTE: Where filenames are specified, you must use forward slashes
01:01 Mitch # instead of backslashes (e.g., "c:/apache" instead of "c:\apache").
01:01 Mitch # If a drive letter is omitted, the drive on which Apache.exe is located
01:01 Mitch # will be used by default.  It is recommended that you always supply
01:01 Mitch # an explicit drive letter in absolute paths, however, to avoid
01:01 Mitch # confusion.
01:01 chris naw thats not it
01:02 Mitch k
01:02 Mitch darn thought I found it
01:02 chris its probably in the Apache2 dir
01:03 Mitch yep ther is logs in that dir
01:03 Mitch with files access 3rror and install
01:03 Mitch error'
01:03 chris we are still looking for koha-httpd.conf file
01:04 chris which will tell apache where to log
01:04 Mitch k
01:04 chris im afraid i have no idea where it is on windows or how its set up
01:04 chris you could try searching for koha-error_log
01:05 Mitch koha.conf.227
01:05 Mitch database=sample227
01:05 Mitch hostname=localhost
01:05 Mitch user=koha
01:05 Mitch pass=koha
01:05 Mitch intranetdir=c:\usr\koha227\intranet
01:05 Mitch opacdir=c:\usr\koha227\opac
01:05 Mitch kohaversion=2.2.7
01:05 Mitch opachtdocs=c:\usr\koha227\opac\htdocs\opac-tmpl
01:05 Mitch intrahtdocs=c:\usr\koha227\i​ntranet\htdocs\intranet-tmpl
01:05 Mitch includes=c:\usr\koha227\intranet\htdo​cs\intranet-tmpl\default\en\includes
01:05 Mitch has that
01:06 Mitch the etc director is where that is located
01:07 Mitch it has a file called timezone and it has TZ=UTC not sure if that has anything to do with anything
01:09 chris im afraid im out of suggestions of where to look
01:09 Mitch I am still looking for the koha config file for ya
01:09 Mitch and also the appache log
01:10 mason can i get an invite please limers :)
01:12 Mitch I think I found it chris
01:14 Mitch opac-error_log and intranet-error_log
01:14 Mitch opac is the user
01:14 Mitch intranet is the admin
01:14 Mitch Opac has some info like
01:14 Mitch [Sun Apr 15 18:17:06 2007] [error] [client 127.0.0.1] Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio, where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and  order by biblio.title ASC at c:/usr/koha227/intranet/modules/C4/SearchMarc.pm line 277., referer: http://opac/cgi-bin/koha/opac-search.pl
01:14 Mitch [Sun Apr 15 18:17:06 2007] [error] [client 127.0.0.1] DBD::mysql::st execute failed: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'where biblio.biblionumber=marc_biblio.biblionumber and biblio.b at c:/usr/koha227/intranet/modules/C4/SearchMarc.pm line 279., referer: http://opac/cgi-bin/koha/opac-search.pl
01:14 Mitch [Sun Apr 15 18:17:06 2007] [error] [client 127.0.0.1] DBD::mysql::st fetchrow failed: fetch() without execute() at c:/usr/koha227/intranet/modules/C4/SearchMarc.pm line 323., referer: http://opac/cgi-bin/koha/opac-search.pl
01:14 Mitch [Sun Apr 15 18:17:18 2007] [error] [client 127.0.0.1] Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word  like 'safety' and m1.tagsubfield in ('245a')) order by biblio.title ASC at c:/usr/koha227/intranet/modules/C4/SearchMarc.pm line 277., referer: http://opac/cgi-bin/koha/opac-search.pl
01:14 Mitch [Sun Apr 15 18:17:22 2007] [error] [client 127.0.0.1] File does not exist: C:/usr/koha227/opac/htdocs/o​pac-tmpl/npl/en/images/.gif, referer: http://opac/cgi-bin/koha/opac-detail.pl?bib=114
01:14 Mitch sorry for the spam
01:15 Mitch that is an error with the client not sidplaying an img not a big deal
01:15 Mitch becasue ip is 127.0.0.1
01:16 Mitch these i think might be an important error
01:16 Mitch [Sun Apr 15 18:41:39 2007] [error] [client 192.168.1.41] Branch is ==DNC== at C:/usr/koha227/opac/cgi-bin/koha/opac-reserve.pl line 216., referer: http://192.168.1.32/cgi-bin/ko[…]eserve.pl?bib=114
01:16 Mitch [Sun Apr 15 18:42:09 2007] [error] [client 192.168.1.41] Branch is ==DNC== at C:/usr/koha227/opac/cgi-bin/koha/opac-reserve.pl line 210., referer: http://192.168.1.32/cgi-bin/ko[…]eserve.pl?bib=114
01:17 chris no thats not
01:17 chris and the one youll be looking for is in the intranet one
01:17 chris to do with circulation
01:17 Mitch [Sun Apr 15 18:43:39 2007] [error] [client 127.0.0.1] select reservedate,reserves.borrowernumber as bornum, concat(firstname,' ',surname) as borrower, borrowers.phone, borrowers.emailaddress,reserves.biblionumber, reserves.branchcode as branch, items.holdingbranch, items.itemcallnumber, items.itemnumber, notes, notificationdate, reminderdate, priority, reserves.found, biblio.title, biblio.author from reserves left join items on items.itemnumber=reserves.itemnumb
01:17 Mitch that
01:17 Mitch I think
01:17 chris nope
01:18 Mitch there is like six of those errors in the intranet server log
01:18 chris those arent errors, those are warn statements
01:18 Mitch kados was mentioning the problem had to do with the date
01:18 chris but if you put in those warns kados said
01:18 chris and issued some books
01:18 Mitch kados had me put warn statements in
01:18 chris then you should see those lines in the error log
01:18 Mitch so theysidplay
01:19 Mitch oh
01:19 chris yes, it will say Issuedate
01:19 chris and the date
01:19 dewey hmmm... the date is in issues, not in items
01:19 chris etc
01:25 Mitch 127.0.0.1 - - [15/Apr/2007:20:19:50 -0500] "POST /cgi-bin/koha/circ/circulation.pl HTTP/1.1" 200 11537
01:25 Mitch 127.0.0.1 - - [15/Apr/2007:20:20:14 -0500] "POST /cgi-bin/koha/circ/circulation.pl HTTP/1.1" 200 8064
01:25 Mitch 127.0.0.1 - - [15/Apr/2007:20:20:15 -0500] "POST /cgi-bin/koha/circ/circulation.pl HTTP/1.1" 200 10629
01:26 chris thats the access log
01:26 Mitch yep
01:26 chris its the error log you want
01:26 chris intanet-error_log
01:26 Mitch was I in the right one with the error log
01:26 chris intranet even
01:26 chris but yes, unless you had issued some books after you put the warn in
01:27 chris they wont have put anything into the error log
01:28 Mitch I will reserve and issue another book to see if it makes any new entries
01:28 chris you dont have to reserve one
01:28 chris you can just issue one
01:28 Mitch k
01:29 Mitch can I pick any due date
01:29 Mitch after today
01:29 chris yep if you leave it blank
01:29 chris it will do it automatically
01:29 chris depending on whatever rules you set up
01:29 chris in issuing rules
01:30 Mitch see I click issue and it refreshes the page
01:30 Mitch still syas 0 out and doesn't list and issued
01:30 Mitch but if I manualy leave the page it will say 1 out but still not list current items issued
01:31 chris right stop apache again
01:31 chris and check if anything in the error log now
01:34 Mitch k
01:36 Mitch crap closed the directory
01:36 Mitch one sec got to find the thing again
01:57 Mitch I am going to have to leave soon chriss willl you be on at all tomarrow
02:02 chris probably
02:08 Mitch k thx for all the help
06:47 vazhipokkan hi
06:47 dewey que tal, vazhipokkan
06:49 vazhipokkan I installed some perl modules locally. but installer.pl cannot find that modules, how to add that to search path ?
06:50 vazhipokkan I tried like this: ./installer.pl PREFIX=/home/kohaadmin/Desktop/koha228/usr/
06:50 vazhipokkan but not working
06:53 vazhipokkan any idea ?
06:57 vazhipokkan well, it works if I set PERL5LIB
06:58 vazhipokkan but there is another issue now, I installed YAZ also locally
06:59 vazhipokkan I am getting a waring like this:
06:59 vazhipokkan ZOOM-Perl requires at least version 2.1.50 of YAZ, but is currently
06:59 vazhipokkan running against only version 2.0.15 (sys-string '').
06:59 vazhipokkan Some things may not work.
06:59 vazhipokkan how to tell YAZ path ?

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary