Check your NULL/NOT NULL values as well as your DEFAULT values according to the docs here: http://smslib.org/doc/smsserver/interfaces/database/#Outbound_SMS_Table
I see too many NULLs in your SQL statement... On Jul 17, 8:07 am, Vivek <[email protected]> wrote: > Hi Thanasis, > > I guess , > Some thing wrong with out table data . > I am sending a row . > Can you plz go through it . > ----------------------------------------------------------------------------- > Insert into SMSSERVER_OUT > (ID, TYPE, RECIPIENT, TEXT, WAP_URL, > WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR, ENCODING, > STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE, > REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID) > Values > (92, 'O', '+919811488535', 'HI7', NULL, > NULL, NULL, NULL, NULL, '7', > 1, NULL, NULL, NULL, TO_TIMESTAMP('4/16/2009 3:39:18.671000 > PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), > '208', 1, 'U', NULL, 'modem1'); > -------------------------------------------------------------------------------------------- > > urs, > Vivek > > On Fri, Jul 17, 2009 at 9:49 AM, Vivek <[email protected]> wrote: > > Hi Thanasis , > > > In errors field is having > 0 value. > > What does it mean ? > > Is there any problem in configurations. > > > urs, > > Vivek > > > On Thu, Jul 16, 2009 at 10:36 PM, Thanasis <[email protected]> wrote: > > >> Sorry, I cannot reproduce this. > > >> I work with MS Sql Server, and "*" as the gateway in the database - > >> but I don't think it makes any difference. > >> Check your database for correct structure. Also check to see if the > >> "errors" field has any >0 value - this would indicate failed attempts > >> to send the messages. > > >> On Jul 16, 1:05 pm, Vivek <[email protected]> wrote: > >> > I done out table data as u mentioned . > >> > Still not yet solved that problem > > >> > urs, > >> > nandu > > >> > On Thu, Jul 16, 2009 at 2:42 PM, Vivek <[email protected]> wrote: > >> > > Hi > > >> > > I am sending in table record. > > >> --------------------------------------------------------------------------- > >> --------------- > >> > > Insert into SMSSERVER_IN > >> > > (ID, PROCESS, ORIGINATOR, TYPE, ENCODING, > >> > > MESSAGE_DATE, RECEIVE_DATE, TEXT, ORIGINAL_REF_NO, > >> > > ORIGINAL_RECEIVE_DATE, > >> > > GATEWAY_ID) > >> > > Values > >> > > (93, 0, '919811488535', 'I', '7', > >> > > TO_TIMESTAMP('7/16/2009 12:36:45.750000 PM','fmMMfm/fmDDfm/YYYY > >> > > fmHH12fm:MI:SS.FF AM'), TO_TIMESTAMP('4/16/2009 2:34:10.968000 > >> > > PM','fmMMfm/fmDDfm/YYYY fmHH12fm:MI:SS.FF AM'), '1', NULL, NULL, > >> > > 'modem1'); > > >> --------------------------------------------------------------------------- > >> ----------------- > >> > > In this table gateway_id stored as modem1. > > >> > > I changed modem1 to SerialModem in out table. > >> > > then also i am having same problem > >> > > urs, > >> > > nandu > > >> > > On Thu, Jul 16, 2009 at 2:22 PM, Thanasis <[email protected]> > >> wrote: > > >> > >> There is a discrepancy here: > > >> > >> In your config file, you name your modem gateway as "SerialModem". > > >> > >> But the row you've created sets the gateway_id field to "modem1". > >> This > >> > >> message will never leave! Set the gateway_id field to "*" or at least > >> > >> to "SerialModem" (in order to match with your gateway). > > >> > >> On Jul 16, 11:45 am, Vivek <[email protected]> wrote: > >> > >> > One row from out table > >> > >> > Insert into SMSSERVER_OUT > >> > >> > (ID, TYPE, RECIPIENT, TEXT, WAP_URL, > >> > >> > WAP_EXPIRY_DATE, WAP_SIGNAL, CREATE_DATE, ORIGINATOR, ENCODING, > >> > >> > STATUS_REPORT, FLASH_SMS, SRC_PORT, DST_PORT, SENT_DATE, > >> > >> > REF_NO, PRIORITY, STATUS, ERRORS, GATEWAY_ID) > >> > >> > Values > >> > >> > (68, 'O', '+919871515064', 'HI', NULL, > >> > >> > NULL, NULL, NULL, NULL, '7', > >> > >> > 1, NULL, NULL, NULL, NULL, > >> > >> > NULL, 1, 'U', 1, 'modem1'); > > >> > >> > urs, > >> > >> > Vivek --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SMSLib User Group" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/SMSLib?hl=en -~----------~----~----~----~------~----~------~--~---
