Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
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
Go to Top
3sp_EditHistory sp_Permalink sp_Print sp_QuotePost Quote

Thank you so much, it's working.

November 30, 2017
10:41 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

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
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

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.

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
11 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 Helmantel

Administrators: Henk Helmantel: 1488