Skip to content

Configuring database service with blank schema causes SQL error #489

@AdamFonagy

Description

@AdamFonagy

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions