hi,
Sorry for the previous empty email.
Looks like the query is incomplete.A Few years ago I had similar problem with
DLRs from Mblox. For some reason there was 0x00 chat in the message body which
was breaking the query string inside the sqlbox. I've fixed this by converting
msgbody to hexstring. (that was only quick and dirty fix)
Could you also paste smsc logs?
Regards,
Cezary
INSERT INTO sent_sms (sql_id, momt, sender, receiver, udhdata, msgdata,
time, smsc_id, service, account, sms_type, mclass, mwi, coding, compress,
validity, deferred, dlr_mask, dlr_url, pid, alt_dcs, rpi, charset, boxc_id,
binfo ) VALUES ( NULL, 'DLR', 'IMOBI', '+27820000000', NULL, 'id:1244518347
sub:001 dlvrd:001 submit date:1207091236 done date:1207091236 stat:DELIVRD
err:000 Text:DLVRD TO MOBILE
