← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | I have added a branch, borrower, and book with a barcode sucessfuly | |
| 00:15 | How ever I am getting a glitch | |
| 00:16 | 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 | on admin nor the main issues page of the user | |
| 00:18 | Thanks ahead of time for helping | |
| 00:18 | kados | I've definitely seen that before |
| 00:18 | I'm trying to remember why it happens | |
| 00:18 | Mitch | cool |
| 00:18 | ok take your time I will keep reading | |
| 00:18 | and testing | |
| 00:19 | kados | any errors in the log? |
| 00:19 | it's something to do with the dates I think | |
| 00:19 | Mitch | due dates? |
| 00:19 | 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 | when Issued it | |
| 00:21 | kados | ok, think I found it |
| 00:21 | take a look at circulation.pl | |
| 00:22 | around line 227 or so | |
| 00:22 | foreach my $it (keys %$issueslist) { | |
| 00:22 | my $issuedate = $issueslist->{$it}->{'timestamp'}; | |
| 00:22 | Mitch | in intranet |
| 00:22 | kados | if ($todaysdate == $issuedate) { |
| 00:22 | push @todaysissues, $issueslist->{$it}; | |
| 00:22 | } else { | |
| 00:22 | push @previousissues, $issueslist->{$it}; | |
| 00:22 | } | |
| 00:22 | yea, in intranet/cgi-bin/circ/ | |
| 00:24 | Mitch | I have intranet/cgi-bin/koha |
| 00:24 | 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 | is that is | |
| 00:25 | it' | |
| 00:25 | kados | nope, not modules |
| 00:25 | Mitch | ah yep |
| 00:25 | intranet/cgi-bin/koha/circ | |
| 00:26 | kados | cool |
| 00:26 | so something about the way that the dates are being represented | |
| 00:26 | 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 | let me know when you find it | |
| 00:27 | Mitch | k one sec |
| 00:28 | is it the one in the BUILD HTML about 10 lines down | |
| 00:28 | kados | nope |
| 00:28 | it's on line 227 | |
| 00:28 | or around there | |
| 00:29 | do a search for 'issuedate' | |
| 00:29 | 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 | # split in 2 arrays for today & previous | |
| 00:29 | foreach my $it (keys %$issueslist) { | |
| 00:29 | my $issuedate = $issueslist->{$it}->{'timestamp'}; | |
| 00:29 | $issuedate = substr($issuedate, 0, 8); | |
| 00:29 | if ($todaysdate == $issuedate) { | |
| 00:29 | push @todaysissues, $issueslist->{$it}; | |
| 00:29 | } else { | |
| 00:29 | push @previousissues, $issueslist->{$it}; | |
| 00:29 | } | |
| 00:29 | kados | there ya go |
| 00:29 | Mitch | is that it |
| 00:30 | kados | ok, so what's happening |
| 00:30 | my $issuedate = $issueslist->{$it}->{'timestamp'}; | |
| 00:30 | that means that the value of the timestamp is being stored in the variable $issuedate | |
| 00:30 | 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 | so it's not evaluating as true | |
| 00:32 | Mitch | k I am running it on windows XP also |
| 00:32 | I know the Now() code from v | |
| 00:32 | vb | |
| 00:32 | kados | right |
| 00:33 | 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 | put in: | |
| 00:33 | warn "Issuedate:".$issuedate; | |
| 00:33 | warn "Todaysdate:".$todaysdate; | |
| 00:34 | then issue something and you should have some warnings in your apache logs | |
| 00:34 | Mitch: right, that's what I'm saying | |
| 00:34 | so first lets confirm that | |
| 00:34 | Mitch | same place |
| 00:34 | replace the issuedate line | |
| 00:34 | or just onder neith | |
| 00:34 | kados | don't replace anything |
| 00:34 | 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 | 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 | 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 | I appreciate all the help kados and chris(That guide realy help up to this point | |
| 00:40 | helped out' | |
| 00:43 | kados | hmmm |
| 00:43 | so chris, hw can Mitch look at the log? | |
| 00:43 | 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 | :-) | |
| 00:44 | I can do that | |
| 00:44 | chris | (windows isnt a good OS to run a server on) |
| 00:44 | Mitch | np |
| 00:44 | 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 | 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 | I have stoped apache where do I find the error log | |
| 00:48 | found it | |
| 00:48 | start>apache>logs>error log | |
| 00:49 | actually server logs the review error log | |
| 00:50 | is that the correct file? | |
| 00:51 | I am going to list what is in file don't mean to spam its not to long | |
| 00:51 | [Thu Apr 05 11:03:49 2007] [notice] Apache/2.0.59 (Win32) configured -- resuming normal operations | |
| 00:51 | [Thu Apr 05 11:03:49 2007] [notice] Server built: Jul 27 2006 15:55:03 | |
| 00:51 | [Thu Apr 05 11:03:49 2007] [notice] Parent: Created child process 396 | |
| 00:51 | [Thu Apr 05 11:03:51 2007] [notice] Child 396: Child process is running | |
| 00:51 | [Thu Apr 05 11:03:51 2007] [notice] Child 396: Acquired the start mutex. | |
| 00:51 | [Thu Apr 05 11:03:51 2007] [notice] Child 396: Starting 250 worker threads. | |
| 00:51 | [Thu Apr 05 11:55:19 2007] [notice] Parent: Received restart signal -- Restarting the server. | |
| 00:52 | [Thu Apr 05 11:55:20 2007] [notice] Child 396: Exit event signaled. Child process is ending. | |
| 00:52 | [Thu Apr 05 11:55:21 2007] [notice] Child 396: Released the start mutex | |
| 00:52 | [Thu Apr 05 11:55:24 2007] [notice] Apache/2.0.59 (Win32) configured -- resuming normal operations | |
| 00:52 | [Thu Apr 05 11:55:24 2007] [notice] Server built: Jul 27 2006 15:55:03 | |
| 00:52 | [Thu Apr 05 11:55:24 2007] [notice] Parent: Created child process 992 | |
| 00:52 | [Thu Apr 05 11:55:28 2007] [notice] Child 992: Child process is running | |
| 00:52 | [Thu Apr 05 11:55:28 2007] [notice] Child 992: Acquired the start mutex. | |
| 00:52 | [Thu Apr 05 11:55:28 2007] [notice] Child 992: Starting 250 worker threads. | |
| 00:52 | [Thu Apr 05 11:55:35 2007] [notice] Child 396: Waiting for 250 worker threads to exit. | |
| 00:52 | [Thu Apr 05 11:55:35 2007] [notice] Child 396: All worker threads have exited. | |
| 00:52 | Actually todays posts are | |
| 00:52 | [Sun Apr 15 19:43:24 2007] [notice] Parent: Received shutdown signal -- Shutting down the server. | |
| 00:52 | [Sun Apr 15 19:43:24 2007] [notice] Child 248: Exit event signaled. Child process is ending. | |
| 00:52 | [Sun Apr 15 19:43:25 2007] [notice] Child 248: Released the start mutex | |
| 00:52 | [Sun Apr 15 19:43:29 2007] [notice] Child 248: Waiting for 250 worker threads to exit. | |
| 00:52 | [Sun Apr 15 19:43:29 2007] [notice] Child 248: All worker threads have exited. | |
| 00:52 | [Sun Apr 15 19:43:29 2007] [notice] Child 248: Child process is exiting | |
| 00:52 | [Sun Apr 15 19:43:29 2007] [notice] Parent: Child process exited successfully. | |
| 00:52 | Thats it | |
| 00:53 | chris | you want the koha apache error log, |
| 00:53 | which on linux would be | |
| 00:53 | /usr/local/koha/log/ | |
| 00:53 | in there | |
| 00:53 | is there a cc | |
| 00:54 | sorry c:\usr\local\koha\log dir? | |
| 00:55 | Mitch | Admin dir of windows is C:\usr\koha227\intranet\cgi-bin\koha |
| 00:56 | 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 | in the Koha227 dir | |
| 00:58 | 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 | can you find the koha-httpd.conf file? | |
| 00:59 | 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 | httpd' | |
| 01:01 | chris | hmm |
| 01:01 | Mitch | # |
| 01:01 | # This is the main Apache server configuration file. It contains the | |
| 01:01 | # configuration directives that give the server its instructions. | |
| 01:01 | # See <URL:http://httpd.apache.org/docs/2.0/> for detailed information about | |
| 01:01 | # the directives. | |
| 01:01 | chris | probably not that one |
| 01:01 | Mitch | is that ir |
| 01:01 | it | |
| 01:01 | # Based upon the NCSA server configuration files originally by Rob McCool. | |
| 01:01 | # | |
| 01:01 | # Configuration and logfile names: If the filenames you specify for many | |
| 01:01 | # of the server's control files begin with "/" (or "drive:/" for Win32), the | |
| 01:01 | # server will use that explicit path. If the filenames do *not* begin | |
| 01:01 | # with "/", the value of ServerRoot is prepended -- so "logs/foo.log" | |
| 01:01 | # with ServerRoot set to "C:/Program Files/Apache Group/Apache2" will be interpreted by the | |
| 01:01 | # server as "C:/Program Files/Apache Group/Apache2/logs/foo.log". | |
| 01:01 | # NOTE: Where filenames are specified, you must use forward slashes | |
| 01:01 | # instead of backslashes (e.g., "c:/apache" instead of "c:\apache"). | |
| 01:01 | # If a drive letter is omitted, the drive on which Apache.exe is located | |
| 01:01 | # will be used by default. It is recommended that you always supply | |
| 01:01 | # an explicit drive letter in absolute paths, however, to avoid | |
| 01:01 | # confusion. | |
| 01:01 | chris | naw thats not it |
| 01:02 | Mitch | k |
| 01:02 | 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 | with files access 3rror and install | |
| 01:03 | error' | |
| 01:03 | chris | we are still looking for koha-httpd.conf file |
| 01:04 | 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 | you could try searching for koha-error_log | |
| 01:05 | Mitch | koha.conf.227 |
| 01:05 | database=sample227 | |
| 01:05 | hostname=localhost | |
| 01:05 | user=koha | |
| 01:05 | pass=koha | |
| 01:05 | intranetdir=c:\usr\koha227\intranet | |
| 01:05 | opacdir=c:\usr\koha227\opac | |
| 01:05 | kohaversion=2.2.7 | |
| 01:05 | opachtdocs=c:\usr\koha227\opac\htdocs\opac-tmpl | |
| 01:05 | intrahtdocs=c:\usr\koha227\intranet\htdocs\intranet-tmpl | |
| 01:05 | includes=c:\usr\koha227\intranet\htdocs\intranet-tmpl\default\en\includes | |
| 01:05 | has that | |
| 01:06 | the etc director is where that is located | |
| 01:07 | 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 | 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 | opac-error_log and intranet-error_log | |
| 01:14 | opac is the user | |
| 01:14 | intranet is the admin | |
| 01:14 | Opac has some info like | |
| 01:14 | [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 | [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 | [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 | [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 | [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 | sorry for the spam | |
| 01:15 | that is an error with the client not sidplaying an img not a big deal | |
| 01:15 | becasue ip is 127.0.0.1 | |
| 01:16 | these i think might be an important error | |
| 01:16 | [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 | [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 | and the one youll be looking for is in the intranet one | |
| 01:17 | 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 | that | |
| 01:17 | 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 | 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 | oh | |
| 01:19 | chris | yes, it will say Issuedate |
| 01:19 | 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 | 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 | 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 | intanet-error_log | |
| 01:26 | Mitch | was I in the right one with the error log |
| 01:26 | chris | intranet even |
| 01:26 | but yes, unless you had issued some books after you put the warn in | |
| 01:27 | 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 | you can just issue one | |
| 01:28 | Mitch | k |
| 01:29 | can I pick any due date | |
| 01:29 | after today | |
| 01:29 | chris | yep if you leave it blank |
| 01:29 | it will do it automatically | |
| 01:29 | depending on whatever rules you set up | |
| 01:29 | in issuing rules | |
| 01:30 | Mitch | see I click issue and it refreshes the page |
| 01:30 | still syas 0 out and doesn't list and issued | |
| 01:30 | 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 | and check if anything in the error log now | |
| 01:34 | Mitch | k |
| 01:36 | crap closed the directory | |
| 01:36 | one sec got to find the thing again | |
| 01:57 | 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 | I tried like this: ./installer.pl PREFIX=/home/kohaadmin/Desktop/koha228/usr/ | |
| 06:50 | but not working | |
| 06:53 | any idea ? | |
| 06:57 | well, it works if I set PERL5LIB | |
| 06:58 | but there is another issue now, I installed YAZ also locally | |
| 06:59 | I am getting a waring like this: | |
| 06:59 | ZOOM-Perl requires at least version 2.1.50 of YAZ, but is currently | |
| 06:59 | running against only version 2.0.15 (sys-string ''). | |
| 06:59 | Some things may not work. | |
| 06:59 | how to tell YAZ path ? |
← Previous day | Today | Next day → | Search | Index