Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

Can not write gateway field to MySQL database
sp_NewPost Add Reply sp_NewTopic Add Topic
December 5, 2017
9:58 am

Thank you so much, it's working.

November 30, 2017
10:41 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

When Diafaan SMS Server creates a new SQL Connector with ODBC or OLEDB as the driver, it only uses a few of all the possible database fields. Initially, the 'Gateway' field is one of the fields that is not used in the database query.

You can add the missing database field names in the advanced settings of the SQL Connector. The 'Gateway' field of the MessageLog table can be added to the 'SMSLogGateway' property. There are a number of other parameters that you can add to the database query, like the error code and error text or the number of message parts for the message.

Regards, Henk

November 30, 2017
4:37 am

Hi Support Team,
I am using Diafaan Server version 4.0. The sms log is saved to the MySQL database, but the Gateway field is empty( table messagelog). Please help me. Thank you.

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
2 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