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 'email@example.com' then I can make a test with your configuration and perhaps find out what causes the problem.
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
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 505
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 950