Support forum
Add Reply
Add Topic9:35 am
May 28, 2013
Offline
QuoteHello Klorane,
This is the way the SQL Connector is designed to work. Normally, when if retrieves the messages from the SQL database it removes these messages from the MessageOut table. As an alternative you can choose to keep the messages in the MessageOut table and let the SQL Connector change one of the database fields to indicate that the message has been read from the database. The default name of this database field is 'IsSent' but it is not an indication that the message was sent, just that it was read from the database.
The status of the message is stored in the MessageLog table of the database, there you can see if the message was actually sent and delivered to the mobile phone.
If the status of the message is 'Sent', it means that Diafaan SMS Server has sent the message and that it is accepted by the SMS gateway. If the status is 'Delivered' it means that Diafaan SMS Server has received a status update from the network for the message.
Regards, Henk
5:59 pm
Hello Henk,
I think there is a problem with : change field (in connector : Send SMS).
If i select Remove the record : i receive message on my phone (no problem it work)
but if i select change field and Statut to 1
I add in mysql message with statut = 0
statut change 0 -> 1 (this : ok) but message isn't sent. I don't receive it on my phone
I think "statut" change before sending.
(Other problem (less important) i see in sendlog : somtimes "Delivered" and somtimes just : "sent" .
Ex : same number (my phone number) i send 30 messages identical.
Result: 17 delivered and 12 Sent
Is it a problem of diafaan or my operator?... i don't know)
Klorane
Most Users Ever Online: 529
Currently Online:
2 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 672
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1141
Posts: 3899
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1488