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
Send SMS using MySQL query
sp_NewPost Add Reply sp_NewTopic Add Topic
January 9, 2019
10:51 am
Henk Helmantel
Admin
Forum Posts: 950
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Akram,

If you do not need scheduling then you can try to remove the 'SMSOutScheduled' parameter in the advanced settings of the SQL Connector. That might get rid of the error.

There does not seem to be anything wrong with the SQL query but it is possible that your database does not have all the exact fields that you use in the settings of the SQL Connector. It is also possible that the error is caused by a problem in the specific version of the ODBC driver that you are using. If you send the configuration file of Diafaan SMS Server (menu options 'File-Export-Configuration') and your database layout to email address 'dms@diafaan.com' then I can make a test with your configuration and perhaps find out what causes the problem.

Regards, Henk

January 8, 2019
2:36 pm
Akram Bazina
Guest
Guests

Hello Support

I have an issue with sending sms by MySQL connector using a simple query. which get stuck in the messageout table. I have turn on the Log from the connector properties and I found the query which diafaan server uses to read fields in messageout table "SELECT Id,Gateway,MessageTo,MessageText,MessageFrom,MessageType,UserId,UserInfo,Priority,ValidityPeriod FROM messageout WHERE (Scheduled IS NULL OR Scheduled<?) ORDER BY Priority DESC,Id LIMIT 500"
I took this query and I tested it using mysql workbench and it gives me an SQL syntax error "Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? ORDER BY Priority DESC,Id LIMIT 500' at line 1"
the installed version of MySQL is 5.7.24 in windows server 2012 Standard R2.
could you please verify this issue.
Thanks in advance

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 505

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 783

Posts: 2695

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 950