Time  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\intranet\htdocs\intranet-tmpl
01:05 Mitch       includes=c:\usr\koha227\intranet\htdocs\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/opac-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/koha/opac-reserve.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/koha/opac-reserve.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 ?