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 21, 2019
1:42 pm
Henk Helmantel
Admin
Forum Posts: 1084
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Thank you for the configuration and the database layout. I did a test with your database layout and the latest versions of MySQL and the ODBC driver but I was not able to replicate the error you get.

It is possible that the MariaDB ODBC driver will work better with your version of MySQL. This driver can be installed together with the MySQL ODBC driver and often works better than the official MySQL driver. It is probably worth a try.

Regards, Henk

January 20, 2019
9:32 am
Akram Bazina
Guest
Guests

Hello Henk
I have removed the 'SMSOutScheduled' parameter from the connector advanced properties and it works fine now.
but in other projects I need the Schedule feature for advertisement.

for the database structure, I use the default database on your website. only for 'messagein' I added to fields which has no effect on the default structure.

may be as you said it's a ODBC driver issue. I will try different versions and i will update you with the results.

I have sent an email to 'dms@diafaan.com' contains Configuration file and database structure.

Thanks

January 9, 2019
10:51 am
Henk Helmantel
Admin
Forum Posts: 1084
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:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 542

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 865

Posts: 2981

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1084