This was exactly the case ! A little typo in one field on the SQL conector DB tables.
Thank you. Hope this will help troubleshoot any further same pbl.
My very best
The most likely reason for this error is that there is a mismatch between the layout of your database tables and the settings in the SQL Connector of Diafaan SMS Server. When the field names in the SQL Connector do not correspond with the field names in your database, Diafaan SMS Sever will generate an invalid SQL query for your database.
First of all, very good work on the SMS Server.
We are in the trial period to test your product. We are trying to connect to our MySql DB (see topic for the versions) thru MySQL ODBC 5.3 Unicode Driver : the SQL connector connects well but few seconds after connecting OK it returns to KO with the following message :
"ERROR  [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.43-37.2-log]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 'FROM ORDER BY' at line 1"
Seems that the SMS Server is chating using old language here , no ?
Thank you for your help and keep going with your good work.
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 497
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 933