ERROR 1064 (42000): 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 '-1010_LOG set ID=0,COUNT=0,TYPE=0,
Server version: 5.5.31-0+wheezy1 (Debian)
full statement produced out out of syslog
insert into Production-1010_LOG set ID=0,COUNT=0,TYPE=0,
SOURCE=2,START_TIME=82800000,GRACE_TIME=0,
CART_NUMBER=60101,TIME_TYPE=0,POST_POINT="N",
TRANS_TYPE=1,EXT_START_TIME=82800000;
Alban Peignier schreef op 9-10-2013 15:17:
On 10/09/2013 03:10 PM, Rick wrote:
Rdlogmanager: invalid SQL or failed DB connection , Database connection
failed: insert into <logname>
Most of the time, it's a invalid SQL error. But in this case, Rivendell
masks the error returned by the mysql server. You can obtain the error
by executing the query in a mysql client :
$ mysql -u rduser -p Rivendell
[...]
mysql> insert into `2013_01_15_LOG` set [...];
ERROR XXX (XXXXXX): ...
Regards,
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
