I don't think that ASSP generates a query for a [null] key - but who
knows? I'll include a small check to prevent this.
Thomas
Von: Scott MacLean <a...@hollsco.com>
An: ASSP development mailing list <assp-test@lists.sourceforge.net>
Datum: 05.03.2012 22:44
Betreff: [Assp-test] Rebuild spamdb failing
My spamdb rebuild is failing, logging the following - where it shows
"[null]" it is actually inserting null characters into the log.
Any idea where it might be picking up these null values from?
Mar-05-12 03:34:42 [Worker_10001] Error: rebuildspamdb failed -
Database select statement failed: Can't Execute Command 'select pkey
from spamdb where pkey='[null] | [null]'
'
Package : DBD::ADO::st
Filename : C:/Perl/site/lib/DBD/ADO.pm
Line : 1244
Last error : -2147217900
OLE exception from "Microsoft OLE DB Provider for ODBC
Drivers":
[Microsoft][SQL Native Client][SQL Server]Executing SQL
directly; no cursor.
Win32::OLE(0.1709) error 0x80040e14
in METHOD/PROPERTYGET "Execute"
Description : [Microsoft][SQL Native Client][SQL
Server]Executing SQL directly; no cursor.
HelpContext :
HelpFile :
NativeError : 16954
Number : -2147217900
Source : Microsoft OLE DB Provider for ODBC
Drivers
SQLState : 01000
Description : [Microsoft][SQL Native Client][SQL
Server]Unclosed quotation mark after the character string ''.
HelpContext :
HelpFile :
NativeError : 105
Number : -2147217900
Source : Microsoft OLE DB Provider for ODBC
Drivers
SQLState : 37000
Description : [Microsoft][SQL Native Client][SQL
Server]Incorrect syntax near ''.
HelpContext :
HelpFile :
NativeError : 102
Number : -2147217900
Source : Microsoft OLE DB Provider for ODBC
Drivers
SQLState : 37000
Description : [Microsoft][SQL Native Client][SQL
Server]Statement(s) could not be prepared.
HelpContext :
HelpFile :
NativeError : 8180
Number : -2147217900
Source : Microsoft OLE DB Provider for ODBC
Drivers
SQLState : 37000
at D:/ASSP/lib/rebuildspamdb.pm line 572 thread 2.
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
