[Koha] Koha reports not working

[Mohamed Imran K R]

Hi all
i use the following system.

Koha version2.2.5 with fc3.

OS version ('uname -a')Linux centrallib 2.6.9-1.667 #1 Tue Nov 2 14:41:25
EST 2004 i686 i686 i386 GNU/Linux

Perl version5.008005

MySQL versionmysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)

Apache versionServer version: Apache/2.0.52 Server built: Oct 15 2004
11:39:29
i  authenticate my users thru ldap.

my problems are as follows.
when a user places a reserve on a book, that book can still be issued to
some other person with out a warning to the librarians.

Also most of the reports are not working the errors are follows
roster of errors :-
Fri Aug 18 15:03:53 2006] [error] [client 192.168.1.2] OPENOFFICE.ORG at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 177.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/inventory.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near 'from borrowers
where  is not null  order by ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 279.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 281.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near 'from borrowers
where  is not null order by ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 312.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 314.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near ' , count( * )
FROM borrowers WHERE 1  AND categorycode like 'C' group by , ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 353.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:03 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 357.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near 'from borrowers
where  is not null  order by ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 279.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 281.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near 'from borrowers
where  is not null order by ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 312.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 314.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
execute failed: You have an error in your SQL syntax near ' , count( * )
FROM borrowers WHERE 1  AND categorycode like 'C' group by , ' at line 1 at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 353.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl
[Fri Aug 18 15:04:31 2006] [error] [client 192.168.1.2] DBD::mysql::st
fetchrow failed: fetch() without execute() at
/usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 357.,
referer: http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl

-- 
Regards
Mohamed Imran K R
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20060818/5f28fea9/attachment-0001.htm