Skip to content

DbalException - Failed to create a chat session #485

@efreak-dev

Description

@efreak-dev

Which version of assistant are you using?

2.13.0

Which version of Nextcloud are you using?

32.0.6

Which browser are you using? In case you are using the phone App, specify the Android or iOS version and device please.

No response

Describe the Bug

When trying to use Assistant it throws an error: Failed to create a chat session.

The log output of nextcloud:

 DbalException An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column "attachments" of relation "oc_assistant_chat_msgs" does not exist LINE 1: ...O "oc_assistant_chat_msgs" ("session_id", "role", "attachmen... ^
Failed to create a chat session 

The log output of the database:

ERROR:  column "pool" of relation "oc_openai_quota_usage" does not exist at character 66

STATEMENT:  INSERT INTO "oc_openai_quota_usage" ("user_id", "type", "units", "pool", "timestamp") VALUES($1, $2, $3, $4, $5)

ERROR:  column "attachments" of relation "oc_assistant_chat_msgs" does not exist at character 61

STATEMENT:  INSERT INTO "oc_assistant_chat_msgs" ("session_id", "role", "attachments", "content", "timestamp", "sources") VALUES($1, $2, $3, $4, $5, $6)

Is there a way to manually update the database accordingly?

Expected Behavior

To Reproduce

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions