I upgraded to 2.9.7 and reset everything. Logging is fine but at 6:00 am
this morning (same time as the last time) the Cache reload stopped
working. My guess is there is a bad message that is being sent. Here is
part of the message from the log file.
Do I need to go into the sql and find the offending message?
Starting to reload cache
2008-04-29 06:05:01
Loading the cache with data from: all_logs
Error in "function perform_query()" <br>Mysql_error: You have an error
in your S
QL syntax; check the manual that corresponds to your MySQL server
version for th
e right syntax to use near 'YYYYMMDD')', '2008-04-29
06:05:02'),('all_logs', 'HO
ST', 'TO_CHAR(new_prdt_end_d' at line 1<br>Query was: INSERT INTO
search_cache (
tablename, type, value, updatetime) VALUES ('all_logs', 'HOST',
'008-04-29 06:05:02'),('all_logs', 'HOST', 'll_logs', 'HOST', 'rom',
'2008-04-29 06:05:02'),('al 'HOST', 'nm', '2008-04-29
06:05:02'),('all_logs', 'HOST', '5:02'),('all_logs', 'HOST', '1Error',
'2008-04-29 06:05:02'),('all_logs', 'HOST', ':02'),('all_logs', 'HOST',
'T', '-04-29 06:05:02'),('all_logs', 'HOST', 'gs', 'HOST', ''2008-04-29
06:05:02'),('all_logs', 'HOST', 'cc01-1000.landsend.com', '2008-04-2
Thank you,
Tom
________________________________
From: Clayton Dukes [mailto:[EMAIL PROTECTED]
Sent: Monday, April 28, 2008 2:16 PM
To: Stewart, Tom L.
Cc: [email protected]
Subject: Re: [Php-syslog-ng-support] (no subject)
Looks like the actual message contains a "("
can you try quoting that string or removing the (?
On Mon, Apr 28, 2008 at 11:34 AM, Stewart, Tom L.
<[EMAIL PROTECTED]> wrote:
ALL,
I am getting the following error on the cache reload:
Query failed: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'YYYYMMDD')', '2008-04-28 10:30:23'),('all_logs', 'HOST',
'TO_CHAR(new_prdt_end_d' at line 1
The above looks like it is missing a ")" ?
I am using 2.9.5d on Redhat ES 5.1.
Any information would be appreciated.
Thank you,
Tom
------------------------------------------------------------------------
-
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/j
avaone
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
--
______________________________________________________________
Clayton Dukes
______________________________________________________________
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
