Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Configuring database service with blank schema causes SQL error #489

Open
AdamFonagy opened this issue Jul 12, 2023 · 0 comments
Open

Configuring database service with blank schema causes SQL error #489

AdamFonagy opened this issue Jul 12, 2023 · 0 comments

Comments

@AdamFonagy
Copy link

Hi there,

I faced the issue that database service with blank schema cause database query error:
SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """" LINE 1: set search_path to "" ^ (SQL: SELECT schema_name FROM information_schema.schemata WHERE schema_name NOT IN ('information_schema','pg_catalog'))

In the setup page of the service on the config tab the schema is left blank. When I save the config, I get: Test connection failed, could just be a typo. Please check config credentials for Service Name: ...

I've left the schema blank based on the hint of the input:

Schema
Leave blank to work with all available schemas, type "default" to only work with the default schema for the given credentials, or type in a specific schema to use for this service.

I use DreamFactory Version 5.0.1 deployed in Docker

@AdamFonagy AdamFonagy changed the title Configuring database service with blank schema cause Configuring database service with blank schema cause SQL error Jul 13, 2023
@AdamFonagy AdamFonagy changed the title Configuring database service with blank schema cause SQL error Configuring database service with blank schema causes SQL error Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant