Hi all<br>i use the following system.<br clear="all"><p><label class="label100">Koha version</label>2.2.5 with fc3. <br></p>
<p><label class="label100">OS version ('uname -a')</label>Linux centrallib 2.6.9-1.667 #1 Tue Nov 2 14:41:25 EST 2004 i686 i686 i386 GNU/Linux
</p>
<p><label class="label100">Perl version</label>5.008005</p>
<p><label class="label100">MySQL version</label>mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386)
</p>
<p><label class="label100">Apache version</label>Server version: Apache/2.0.52
Server built: Oct 15 2004 11:39:29
</p>i authenticate my users thru ldap.<br><br>my problems are as follows.<br>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.<br><br>Also most of the reports are not working the errors are follows
<br>roster of errors :-<br>Fri Aug 18 15:03:53 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] <a href="http://OPENOFFICE.ORG">OPENOFFICE.ORG</a> at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 177., referer:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/inventory.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/inventory.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 281., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 314., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:03 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 357., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 281., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 314., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2</a>] 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:
<a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br>[Fri Aug 18 15:04:31 2006] [error] [client <a href="http://192.168.1.2">192.168.1.2
</a>] DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/cgi-bin/reports/borrowers_stats.pl line 357., referer: <a href="http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl">
http://192.168.1.7:8001/cgi-bin/koha/reports/borrowers_stats.pl</a><br> <br>-- <br>Regards<br>Mohamed Imran K R