mysql 4.1.11 query help required

[david robert <davidforlinux@yahoo.co.uk>]

Hi,

 

I am trying to execute the following query and i am getting the error

 

# pipe messages to /var/log/mysql.pipe to be processed by mysql
destination d_mysql {
   pipe("/var/log/mysql.pipe"
   template("INSERT INTO logs
   (host, facility, priority, level, tag, datetime, program, msg)
   VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$PROGRAM', '$MSG' );\n") template-escape(yes));

   };

i am getting the following error

 

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 '' at line 1

 

i am using mysql 4.1.11 debian sarge 3.1 i am not sure how get the correct one

 

thanks for your help

---

Yahoo! Photos ? NEW, now offering a quality print service from just 8p a photo.