Skip to content

Data Persistence Table definitions don't match documentation #192

Description

@ainamdar-ag

I received the following error with SQLAlchemy data layer with postgresql DB.

 - An error occurred: (sqlalchemy.dialects.postgresql.asyncpg.ProgrammingError) <class 'asyncpg.exceptions.UndefinedColumnError'>: column "defaultOpen" of relation "steps" does not exist
[SQL: 
            INSERT INTO steps ("name", "type", "id", "threadId", "parentId", "streaming", "input", "isError", "output", "createdAt", "start", "end", "defaultOpen", "showInput", "metadata", "generation")
            VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16)
            ON CONFLICT (id) DO UPDATE
            SET "name" = $1, "type" = $2, "threadId" = $4, "parentId" = $5, "streaming" = $6, "input" = $7, "isError" = $8, "output" = $9, "createdAt" = $10, "start" = $11, "end" = $12, "defaultOpen" = $13, "showInput" = $14, "metadata" = $15, "generation" = $16;
        ]
[parameters: ('on_message', 'run', '587a3e7e-ed5c-4f3a-8fda-4b7cc8cf4b86', 'b8002392-a4ca-41ad-b038-4c78445d1cb0', 'db1cfa7d-a652-43ed-b5c4-0685f2b2b8b6', False, 'hi', False, '', '2025-04-24T14:59:03.165014Z', '2025-04-24T14:59:03.165041Z', '2025-04-24T14:59:05.726986Z', False, 'json', '{}', 'null')]

docs: https://docs.chainlit.io/data-layers/sqlalchemy
These docs don't specify a defaultOpen column. please add this to docs

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions