Can't complete registration process

[specked]

During the initial registration, when I click the "next" button this error is seen in the logs:

@calcom/web:start: 15:47:19:573 [ERROR] [redactError] Error: {"name":"PrismaClientKnownRequestError","code":"P2022","clientVersion":"5.4.2","meta":{"column":"isPlatformManaged"}}

Thank you

[dosubot[bot]]

Hey @specked! 👋 I'm here to help you with any bugs, questions, or if you want to become a contributor. Just ask!

The error you're encountering, PrismaClientKnownRequestError with code P2022, indicates a problem related to the isPlatformManaged column. This error typically occurs when a column is missing or not found in the database schema.

In the context of cal.com, there was a recent migration that added the isPlatformManaged column to the users table. This column is defined as a BOOLEAN type with a NOT NULL constraint and a default value of false ^[1].

To resolve this issue, ensure that your database schema is up-to-date with the latest migrations. You might need to run the Prisma migration command to apply any pending migrations to your database. This should add the isPlatformManaged column if it's missing.

If the problem persists, double-check that the migration was applied successfully and that the column exists in your database schema.

To continue talking to Dosu, mention @dosu.

[specked]

That was a great answer from a bot! This is a fresh install from calcom/cal.com:latest does the latest build not have these changes?

[specked]

root@f78b509a4c35:/calcom/prisma# npx prisma migrate dev
Prisma schema loaded from ../packages/prisma/schema.prisma
Datasource "db": PostgreSQL database "cal_com", schema "public" at "192.168.1.229:5432"

Error: P3006

Migration `20240321143215_move_avatars_cols_to_avatar_table` failed to apply cleanly to the shadow database.
Error:
ERROR: function gen_random_uuid() does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine/connectors/sql-schema-connector/src/lib.rs:324
   1: schema_core::state::DevDiagnostic
             at schema-engine/core/src/state.rs:270

root@f78b509a4c35:/calcom/prisma#

but it exists:

dsmrdb=# \du cal_com
           List of roles
 Role name | Attributes | Member of
-----------+------------+-----------
 cal_com   | Create DB  | {}

dsmrdb=# SELECT gen_random_uuid();
           gen_random_uuid
--------------------------------------
 b1d5be11-56f3-46de-8fd5-d70c1f22db7f
(1 row)

[specked]

got it working with a lot of tweaking. seems pretty weird it didn't work without my intervention.