Hi Nandu, Leave the REF_NO and SENT_DATE fields empty (i.e. zero and null respectively) and give it another try.
On Jul 17, 10:55 am, Vivek <[email protected]> wrote: > I filled all NOT NULL values,Then also im unable to send messages > urs, > nandu > > > > On Fri, Jul 17, 2009 at 11:25 AM, Thanasis <[email protected]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
