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