prisma: Invalid `….findMany()` invocation: The column `j1.id` does not exist in the current database.

We are working on a fix now and hope to release it as a patch soon.

Hey @marvinruder @Eldemarkki @chrishoermann, although we are pretty confident we fixed the problem, we would love if you could try out 5.4.1 and report back if this indeed fixed the problem for you. Thank you.

Yes, everything works fine after upgrading to 5.4.1 in my project. Thanks for the quick patch!

Works on my end too! Thanks!

Hey everyone 👋 and thanks for your reports. The fix is now available in our latest patch release. https://github.com/prisma/prisma/releases/tag/5.4.1

Thanks, we have a confirmed reproduction internally as well.

Works for me also, thanks!

A minimal reproduction repository is now provided at https://github.com/marvinruder/prisma21352.

part of my schema

generator client {
    provider        = "prisma-client-js"
}

generator zod {
    provider                         = "zod-prisma-types"
    useMultipleFiles                 = true
    createOptionalDefaultValuesTypes = true
    createRelationValuesTypes        = true
    writeNullishInModelTypes         = true
    addSelectType                    = false
    addIncludeType                   = false
}

datasource db {
    provider  = "postgresql"
    url       = env("POSTGRES_PRISMA_URL") // uses connection pooling
    directUrl = env("POSTGRES_URL_NON_POOLING") // uses a direct connection
}


// CITY
//------------------------------------------------------

/// City => "Ort/Stadt"
model City {
    cityRefNumber      String    @id /// Gemeindekennziffer 
    city               String
    zipCode            String
    additionalZipCodes String[]
    districtRefNumber  String /// foreignKey
    villages           Village[] // villages connected to this city
    district           District  @relation(fields: [districtRefNumber], references: [districtRefNumber])

    companies          Company[] // companies that have a license for this city
    applicantAddresses ApplicantAddress[]

    @@unique([cityRefNumber, districtRefNumber])
}

// DISTRICT
//------------------------------------------------------

/// District => "Bezirk"
model District {
    districtRefNumber String @id /// "Bezirkskennzahl" 
    district          String @unique
    stateRefNumber    String /// foreignKey
    cities            City[]
    state             State  @relation(fields: [stateRefNumber], references: [stateRefNumber])

    companies Company[] // companies that have a license for this district

    @@unique([districtRefNumber, stateRefNumber])
}

// STATE
//------------------------------------------------------

/// State => "Bundesland"
model State {
    stateRefNumber String     @id /// "Bundeslandkennzahl"
    state          String     @unique
    countryCode    String /// foreignKey
    districts      District[]
    country        Country    @relation(fields: [countryCode], references: [countryCode])
    Company        Company[]

    @@unique([stateRefNumber, countryCode])
}

// COUNTRY
//------------------------------------------------------

/// Country => "Staat"
model Country {
    countryCode String  @id
    country     String  @unique
    states      State[]
}

/////////////////////////////////////////
// COMPANY DATA
/////////////////////////////////////////

// @zod.import(["import validator from "validator";"])
model Company {
    id String @id @default(cuid())

    companyName           String?
    registeredCompanyName String?
    lastName              String?
    firstName             String?
    postGraduateTitle     String?
    title                 String?
    email                 String? /// @zod.string.email()
    homepage              String?
    phoneNumber           String?
    mobilePhone           String?
    faxNumber             String?
    street                String
    houseNumber           String
    houseNumberAddition   String?
    zipCode               String
    city                  String
    cityRefNumber         String?
    villageRefNumber      String?
    stateRefNumber        String?
    latitude              Float?
    longitude             Float?
    vacantJobs            Int? /// @zod.custom.use(z.union([z.number(), z.nan()]).transform((v) => (Number.isNaN(v) ? null : v)).optional()) 

    userId        String?
    user          User?              @relation(fields: [userId], references: [id])
    isInCity      City?              @relation(fields: [cityRefNumber], references: [cityRefNumber])
    isInVillage   Village?           @relation(fields: [villageRefNumber], references: [villageRefNumber])
    isInDistricts District[]
    isInStates    State?             @relation(fields: [stateRefNumber], references: [stateRefNumber])
    applicants    CompetitionEntry[]
}

I think this is it

prisma:query SELECT "public"."RecipesOnCollections"."recipeId", "public"."RecipesOnCollections"."recipeCollectionId", "public"."RecipesOnCollections"."createdAt" FROM "public"."RecipesOnCollections" LEFT JOIN "public"."RecipeCollection" AS "j1" ON ("j1"."id") = ("public"."RecipesOnCollections"."recipeCollectionId") WHERE ("public"."RecipesOnCollections"."recipeId" = $1 AND ("j1"."userId" = $2 AND ("j1"."recipeId" IS NOT NULL AND "j1"."recipeCollectionId" IS NOT NULL))) OFFSET $3