ynput / ayon-backend

Server codebase with API access to AYON
Apache License 2.0
22 stars 15 forks source link

AY-5649_Cannot-change-name-of-users-assigned-to-bundles #219

Closed Innders closed 3 months ago

Innders commented 4 months ago

To reproduce

Steps to reproduce the behavior:

An error is thrown when trying to change the name of a user that is also assigned to a bundle.

Additional context

ayon_dev_postgres  | 2024-05-31 14:35:50.126 CEST [588835] ERROR:  update or delete on table "users" violates foreign key constraint "bundles_active_user_fkey" on table "bundles"
ayon_dev_postgres  | 2024-05-31 14:35:50.126 CEST [588835] DETAIL:  Key (name)=(Steeve) is still referenced from table "bundles".
ayon_dev_postgres  | 2024-05-31 14:35:50.126 CEST [588835] STATEMENT:  UPDATE users SET name = $1 WHERE name = $2
mkolar commented 3 months ago

fixed by @martastain