[Bug]: Undefined column: 7 ERROR: column "uuid" of relation "environment_variables" does not exist

[insaneadinesia]

Error Message and Logs

I got this error when try to add new env after upgrade the coolify from beta 306 to beta 380

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "uuid" of relation "environment_variables" does not exist
LINE 1: ...ne", "is_preview", "application_id", "is_shared", "uuid", "u...
                                                             ^ (Connection: pgsql, SQL: insert into "environment_variables" ("key", "value", "is_build_time", "is_multiline", "is_preview", "application_id", "is_shared", "uuid", "updated_at", "created_at") values (TEST, eyJpdiI6Imx1YzhmTDVJeHZCYThScDlEbEczZlE9PSIsInZhbHVlIjoiWVYvSGZheVFYQStCV1ppbVEvVEQ3dz09IiwibWFjIjoiN2U2YTcxYjg3M2RhMGE5MGFkNTU4MTRjYjNiMDBhOWEwNzQ3N2M2MzIzZmEyNWJkNGMwNzQxNTRmMmVhMmVhYiIsInRhZyI6IiJ9, 0, 0, 0, 17, 0, rowo80gg8k8so8kkgso8k0gk, 2025-01-01 16:00:03, 2025-01-01 16:00:03) returning "id")

The issue just appear when i try to add new env, it runs normally when i just update the current value

Steps to Reproduce

1. upgrade from v4.0.0-beta.306 to v4.0.0-beta.380
2. just add new env to current resources
3. then the error happen

Example Repository URL

No response

Coolify Version

v4.0.0-beta.380

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Ubuntu 22.04.2 LTS

Additional Information

No response

[Cinzya]

Have you tried adding the missing column manually to the db as outlined here? This usually fixed it for most people.
#4574 (comment)

[insaneadinesia]

Have you tried adding the missing column manually to the db as outlined here? This usually fixed it for most people. #4574 (comment)

how can i run query manually? can you give me the steps?

[Cinzya]

You can access the coolify-db terminal in Coolify when you go to Terminal on the left menu. There you select localhost -> coolify-db and run:

psql -U coolify -d coolify -c "ALTER TABLE environment_variables ADD COLUMN uuid VARCHAR(255);"

If you need more help with that, then it would be good if you join the coolLabs Discord Server and we continue the conversation there.

[insaneadinesia]

wow, it works, thankyou @Cinzya