CanbiZ (MickLesk) 3ac2ceda3d fix(pangolin): create migration tables before data transfer to prevent role loss (#13874) ...

The previous migration fix attempted to INSERT INTO 'userOrgRoles' before
that table existed (it is new in 1.17.1). The error was silently ignored,
so no role data was migrated. When drizzle-kit then dropped roleId from
userOrgs, all user-role associations were permanently lost.

- CREATE TABLE IF NOT EXISTS for userOrgRoles before migrating data
- Same treatment for userInviteRoles (also new in 1.17.1)

Fixes community-scripts/ProxmoxVE#13857

2026-04-20 13:23:32 +02:00

4.6 KiB

Raw Permalink Blame History

View Raw