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/
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
On Fri, Oct 25, 2002 at 06:08:47AM -0400, Ville Huhtala wrote:
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 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.
I'm not certain, but I'm pretty sure that both of these are caused by insufficient error-checking, e.g. select * from biblio where biblionumber=$biblionumber where $biblionumber is undefined. I think I've also run into a few cases similar to if ($title ne "") { $query = "select * from biblio where title like '$title'; } # else if other cases... $query .= " and author='$author'"; In this case, if $title isn't specified for whatever reason, the SQL query begins with " and author", which causes an error. The only real fix, I'm afraid, is better error-checking throughout. In particular, at the beginning of every script, make sure that all required fields were set. -- Andrew Arensburger This message *does* represent the arensb@ooblick.com views of ooblick.com Jesus loves me, this I know / For the Voices tell me so.
On Fri, 25 Oct 2002, Andrew Arensburger wrote:
The only real fix, I'm afraid, is better error-checking throughout. In particular, at the beginning of every script, make sure that all required fields were set.
The real fix is a rewrite of the search routine. Most likely this will not happen until 1.3 settles down, as the search routines will have to be redone for the new marc backend data in any case. Until then, we'll have to live with the search routines in 1.2, and fix bugs as we find them. Steve.
participants (3)
-
Andrew Arensburger -
Tonnesen Steve -
vthuhtala＠netscape.net