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.
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 'email@example.com' contains Configuration file and database structure.
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 'firstname.lastname@example.org' 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: 605
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 1287