Error in MySQL syntax when accessing API

Connecting to SQL
1

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 version for the right syntax to use near ‘.app’ at line 1 (SQL: SHOW FULL TABLES FROM my_db_name.app)”,

The syntax is indeed invalid, why does the generated code contain .app?
Please note that /my_db_name endpoint is working fine, but all other endpoints are giving the same error.

2

what is your service configuration?

3

Screenshot from 2016-09-12 17-50-45.png816×510 21.2 KB

Screenshot from 2016-09-12 17-50-22.png521×556 16.4 KB

4

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.

1 Like
5

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

1 Like
6

It eventually solved mine, but i had to recreate a Service. There seems to be some caching going on that prevents changes to a created service from flowing through.