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
-~----------~----~----~----~------~----~------~--~---
