I created connection to existing MySQL database and headed out to API Docs tab to test it. Apparently, requests fail with the following message: “SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server v…

best guess is that because this is the root user it has access to some items that DF doesn’t understand. Did you check the “default schema only” box? I’d definitely recommend that.

Error in MySQL syntax when accessing API

Connecting to SQL

stefkin October 4, 2016, 1:26pm 5

Thank you, enabling “default schema only” box resolved the issue.

1 Like

Topic		Replies	Views
Lots of issues/critical errors with the Scheme editor Schema & Data	3	2334	September 1, 2014
Rest api > mysql proc (two params) > json post data REST API	2	2440	January 20, 2018
Mysql View doesn't work - DF on windows REST API	2	1353	May 10, 2019
mySQL API call stored procedure sometimes return error: incorrect number of arguments REST API rest	0	4694	December 1, 2017
POST to mysql error: user_id_on_create always 3 Schema & Data	1	1790	August 1, 2017

Error in MySQL syntax when accessing API

Related Topics