SQL error when extending default SQL queries

[motor-admin]

SQL error when extending default SQL queries

[arnaud]

A server restart did the trick! Thank you so much! Support is very appreciated 🙏

[omohokcoj]

@arnaud this issue was caused by your custom schema name (which is not a "public" schema).
The newest version contains a way to specify pg schemas via DB configurations - so you need to specify your schema name there and restart the app to fix the issue:

[arnaud]

I see. Sadly, the latest current version for the Docker image is still stuck to 0.2.26 :(

[omohokcoj]

@arnaud new docker images have been uploaded to docker hub - please give it another try 😄

[arnaud]

Thanks for the push.

Actually, the issue still persists with the latest version (0.2.31).

ERROR:  syntax error at or near "."
LINE 1: ...omments) hashtags FROM "mytable") AS schema.mytable LIM...
                                                      ^

[omohokcoj]

Did you put your custom schema name into the schemas field on the DB configs page from the screenshot above?
Also you need to restart the server in order to apply this change.
@arnaud