Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

problem with Change field
sp_NewPost Add Reply sp_NewTopic Add Topic
February 26, 2018
9:35 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello 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

February 24, 2018
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)


Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502