Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

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

Thank you so much, it's working.

November 30, 2017
10:41 am
Henk Helmantel
Admin
Forum Posts: 740
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
danhbnt
Guest
Guests

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: 494

Currently Online:
7 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 439

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 656

Posts: 2250

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 740