Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

UserId and UserInfo not carried to MessageLog table
sp_NewPost Add Reply sp_NewTopic Add Topic
June 16, 2018
11:12 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Paul,

If the content of the UserId an UserInfo fields in the MessageOut table is not transferred to the MessageLog table you should first check if the field names of these database fields are filled in for the 'SMSOutUserId', 'SMSOutUserInfo', 'SMSLogUserId' and 'SMSLogUserInfo' properties in the advanced settings of the SQL Connector. If these properties are not filled in, Diafaan SMS Server will not use them in the SQL queries to the database.

If you set up the SQL Connector with a Microsoft SQL Server (Express) database and let Diafaan SMS Server create the database for you then these properties are automatically filled in. For other databases, or if you did not let Diafaan SMS Server create the database, these properties must be filled in manually.

Regards, Henk

June 15, 2018
4:44 pm
Paul Bordon

UserId and UserInfo fields , aren`t traslated from MessageOut table to MessageLog table, using SQLConnector.
I check my SQL Log and found that this fields are not copied when a message is sent.

Per example, in my SQL log , i can see:

exec sp_executesql N'INSERT INTO MessageLog (SendTime,MessageTo,MessageText,MessageId,StatusCode) VALUES (@SENDTIME,@MESSAGETO,@MESSAGETEXT,@MESSAGEID,@STATUSCODE)',N'@SENDTIME datetime,@MESSAGETO nvarchar(80),@MESSAGETEXT nvarchar(73),@MESSAGEID nvarchar(80),@STATUSCODE int',@SENDTIME='2018-06-15 11:23:51.873',@MESSAGETO=N'08424444447',@MESSAGETEXT=N'blablablablabla',@MESSAGEID=N'1:08424444447:153',@STATUSCODE=200

UserId and UserInfo fields value is null. Why????

I have seen in your forums answers such as: "If you use Microsoft SQL Server and let the SQL Connector create the database, these two fields are automatically added to the database and to the SQL Connector settings. in the Advanced settings of the SQL Connector. "
and it is totally false !!!

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

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