On Sun, Jul 12, 2009 at 1:14 AM, Samir Franciscus<[email protected]> wrote: > Not sure if this helps but the following error gets logged to the > kannel-sqlbox.log > 2009-07-12 00:39:47 [28684] [2] ERROR: MYSQL: 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 ''id:1241145349 sub:001 dlvrd:001 submit > date:1207090049 done date:1207090049 sta' at line 1
It seems that the sqlbox complains about some data when it reads the record from the send_sms table. Can you send the sql statement with which you are inserting the messages in the send_sms table, and the structure of the send_sms table? At first check to see if the your table structure is correct: http://www.blogalex.com/wp-content/uploads/2008/11/userguide.html#AEN473 I think that you might set wrong data type for some field(s). BR, Jovan
