I think this is harmless (other than filling logfiles with junk). It's trying to look up the dewey number of the items (which aren't really items in this case, but just subjects. I'll fix this later today. Steve. On Fri, 25 Oct 2002, Ville Huhtala wrote:
kohaerror_log:
sujectsearch DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 1075, <KC> line 44. DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 1079, <KC> line 44. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 1075, <KC> line 44. DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 1079, <KC> line 44. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 1075, <KC> line 44. DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 1079, <KC> line 44. DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 1075, <KC> line 44. DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 1079, <KC> line 44. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and datecancellationprinted is NULL and quantity > quantityreceived' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 2188, <KC> line 55. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 2189, <KC> line 55. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and datecancellationprinted is NULL and quantity > quantityreceived' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 2188, <KC> line 66. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 2189, <KC> line 66. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and datecancellationprinted is NULL and quantity > quantityreceived' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 2188, <KC> line 77. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 2189, <KC> line 77. DBD::mysql::st execute failed: You have an error in your SQL syntax near 'and datecancellationprinted is NULL and quantity > quantityreceived' at line 1 at /var/www/html/koha/intranet/modules/C4/Search.pm line 2188, <KC> line 88. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /var/www/html/koha/intranet/modules/C4/Search.pm line 2189, <KC> line 88.
--- Ville
__________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
------------------------------------------------------- This sf.net email is sponsored by: Influence the future of Java(TM) technology. Join the Java Community Process(SM) (JCP(SM)) program now. http://ads.sourceforge.net/cgi-bin/redirect.pl?sunm0004en _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel