T
Twenty•4mo ago
Ruslan

Checking out v1 getting error "ERROR Failed to load config variables from database"

Hi, Congrats on launching!!! I am trying to create a new instance of v1 and getting error on first run of server container 
Running database setup and migrations...
query failed: SELECT "KeyValuePair"."id" AS "KeyValuePair_id", "KeyValuePair"."userId" AS "KeyValuePair_userId", "KeyValuePair"."workspaceId" AS "KeyValuePair_workspaceId", "KeyValuePair"."key" AS "KeyValuePair_key", "KeyValuePair"."value" AS "KeyValuePair_value", "KeyValuePair"."textValueDeprecated" AS "KeyValuePair_textValueDeprecated", "KeyValuePair"."type" AS "KeyValuePair_type", "KeyValuePair"."createdAt" AS "KeyValuePair_createdAt", "KeyValuePair"."updatedAt" AS "KeyValuePair_updatedAt", "KeyValuePair"."deletedAt" AS "KeyValuePair_deletedAt" FROM "core"."keyValuePair" "KeyValuePair" WHERE (("KeyValuePair"."type" = $1) AND ("KeyValuePair"."userId" IS NULL) AND ("KeyValuePair"."workspaceId" IS NULL)) -- PARAMETERS: ["CONFIG_VARIABLE"]
error: error: relation "core.keyValuePair" does not exist
Running database setup and migrations...
query failed: SELECT "KeyValuePair"."id" AS "KeyValuePair_id", "KeyValuePair"."userId" AS "KeyValuePair_userId", "KeyValuePair"."workspaceId" AS "KeyValuePair_workspaceId", "KeyValuePair"."key" AS "KeyValuePair_key", "KeyValuePair"."value" AS "KeyValuePair_value", "KeyValuePair"."textValueDeprecated" AS "KeyValuePair_textValueDeprecated", "KeyValuePair"."type" AS "KeyValuePair_type", "KeyValuePair"."createdAt" AS "KeyValuePair_createdAt", "KeyValuePair"."updatedAt" AS "KeyValuePair_updatedAt", "KeyValuePair"."deletedAt" AS "KeyValuePair_deletedAt" FROM "core"."keyValuePair" "KeyValuePair" WHERE (("KeyValuePair"."type" = $1) AND ("KeyValuePair"."userId" IS NULL) AND ("KeyValuePair"."workspaceId" IS NULL)) -- PARAMETERS: ["CONFIG_VARIABLE"]
error: error: relation "core.keyValuePair" does not exist
2 Replies
Prastoin
Prastoin•4mo ago
Hello @Ruslan is it the first time installing twenty on your machine ? Have you correctly removed old containers and volumes ?
Ruslan
RuslanOP•4mo ago
I think now I understand the problem, I was running using database name "postgres", which is automatically created by postgres container. And twentycrm wants to have their own db, which is in updated docker compose setup called "default", and only if it creates itself, it runs migration scripts for core schema.

Did you find this page helpful?