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 ?