Skip to content

Data Persistence Table definitions don't match documentation #32

Description

@nagarciah

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", "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)
             ON CONFLICT (id) DO UPDATE
             SET "name" = $1, "type" = $2, "threadId" = $4, "streaming" = $5, "input" = $6, "isError" = $7, "output" = $8, "createdAt" = $9, "start" = $10, "end" = $11, "defaultOpen" = $12, "showInput" = $13, "metadata" = $14, "generation" = $15;
]

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