Hi, Have you tried running that query in mysql directly:
mysql -u root -p Type in your root password then paste in: insert into `2013_01_15_LOG` set ID=3,COUNT=3,TYPE=1, SOURCE=3,START_TIME=7000,GRACE_TIME=-1, CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N", TRANS_TYPE=1,COMMENT="End\ song" MySQL will give you an error and hopefully say something like invalid sql after whatever part its struggling with. Or even duplicate key etc. It may well be that during testing the logs messed up and caused the fault. You could drop the table 2013_01_15_LOG and try again. DROP TABLE 2013_01_15_LOG; Regards, Wayne Merricks The Voice Asia On 14/01/13 10:05, Andy Brown wrote: > insert into `2013_01_15_LOG` set > ID=3,COUNT=3,TYPE=1, > SOURCE=3,START_TIME=7000,GRACE_TIME=-1, > CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N", > TRANS_TYPE=1,COMMENT="End\ song" ####################### Scanned by MailMarshal ####################### ############ Attention: The information contained in this message is confidential and intended for the addressee(s) only. If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. Christian Vision or any of its subsidiaries will not be liable for direct, special, indirect or consequential damages arising from alteration of the contents of this message by a third party or as a result of any virus being passed on. Please note that we reserve the right to monitor and read any e-mails sent or received by the company under the Telecommunications (Lawful Business Practice) (Interception of Communications) Regulation 2000. Christian Vision is registered in England as a limited company 2842414 and as a charity 1031031 ############ _______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
