Hi there, Looks like the problem is with the dash "-". Don't think that is a valid character in Table Name. At least when I try to do that in RDLOGEDIT it doesn't let me use a dash in the name...
Also wont let me do it in mysql. If I change the dash to underscore then it only complains that the table doesn't exist (which is true). White space doesn't matter in Mysql statements usually.... Hope this helps. Todd Baker ----- Original Message ----- From: "Rick" <[email protected]> To: "Alban Peignier" <[email protected]>, "User discussion about the Rivendell Radio Automation System" <[email protected]> Sent: Wednesday, October 9, 2013 9:59:21 AM Subject: Re: [RDD] wheezy RD 2.5.1 (repository) rdlogmanager: invalid SQL or failed DB connection although there seems to be only one space in the output here it look likes two or three tabs are generated by rdlogedit inbetween TYPE=0, and SOURCE=2 also between POST_POINT="N", and TRANS_TYPE=1 both in the log which might cause the error Rick schreef op 9-10-2013 15:46: > 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 > _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
