Migrations failing on new database

[the-dream-machine]

Hey, I need some help setting up the repository. This prisma migration fails to run on a new database:
https://github.com/civitai/civitai/blob/main/prisma/migrations/20241002212355_resupport_stripe_connect_on_payment_configuration/migration.sql

The initial error was due to the missing comma on this line:

civitai/prisma/migrations/20241002212355_resupport_stripe_connect_on_payment_configuration/migration.sql

Line 14 in 85b1a2d

ADD COLUMN "stripePaymentsEnabled" BOOLEAN NOT NULL DEFAULT false

Once you fix that, you get a new error:

Migration `20241002212355_resupport_stripe_connect_on_payment_configuration` failed to apply cleanly to the shadow database.
Error:
column "id" does not exist
...

Coming from this line:

civitai/prisma/migrations/20241002212355_resupport_stripe_connect_on_payment_configuration/migration.sql

Line 18 in 85b1a2d

SELECT "userId", "id", "status", "payoutsEnabled"

I tried changing the id column to stripeAccountId and I get a new error saying that the stripeAccountId column does not exist even though it's added a few lines before:

civitai/prisma/migrations/20241002212355_resupport_stripe_connect_on_payment_configuration/migration.sql

Line 12 in 85b1a2d

ADD COLUMN "stripeAccountId" TEXT,

How can I resolve this?

[Ryani-X]

Replace it with
SELECT "userId", "connectedAccountId", "status", "payoutsEnabled"
Because you need to find the corresponding UserStripeConnect table in prisma/migrations/20240125153716_dadd_user_stipe_comnect_datus/migrations. sql
CREATE TABLE "UserStripeConnect" (
"userId" INTEGER NOT NULL,
"connectedAccountId" TEXT NOT NULL,
"status" "StripeConnectStatus" NOT NULL DEFAULT 'PendingOnboarding',
"payoutsEnabled" BOOLEAN NOT NULL DEFAULT false,
"chargesEnabled" BOOLEAN NOT NULL DEFAULT false
);

[Ryani-X]

id => connectedAccountId

[the-dream-machine]

This worked! thanks