An operation failed because it depends on one or more records that were required but not found. Record to update not found.

[OwaliShawon]

I am trying to update a field that shows this error. How can I solve it?

Here is my Code:

`// delete a product 
    deleteProduct = async (req: any, res: any) => {
        console.log('deleteProduct ', req.params);
        // let authData: any = await getAuthorizedUser(req);
        // console.log('auth data', authData);

        const prisma: any = await originRedirect(req)

        let productId: any = +req.params.productId
        let typeId: any = +req.params.typeId

        console.log('deleteProduct ', productId, typeId);

        try {
            if (typeId === 1) {
                // aca_book_list
                const deleteBook = await prisma.aca_book_list.update({
                    where: {
                        id: productId,
                        // is_active: true,
                        // institution_id: +authData.institution_id,
                    },
                    data: {
                        is_active: false,
                    }
                })
                await BasicResponse(res, 1, 'Book Deleted', deleteBook)
                if (!deleteBook) {
                    await BasicResponse(res, 0, 'Book Not Found to Delete', [])
                    return
                }

            } else if (typeId === 2 || typeId === 3) {
                const deleteProduct = await prisma.sm_products.update({
                    where: {
                        id: productId,
                        // is_active: true,

                    },
                    data: {
                        is_active: false,
                    },
                })
                console.log('deleteProduct ', deleteProduct)
                if (!deleteProduct) {
                    if (typeId === 2) {
                        await BasicResponse(res, 0, 'A Copies Not Found to Delete', [])
                        return
                    }
                    if (typeId === 3) {
                        await BasicResponse(res, 0, 'A Stationery Not Found to Delete', [])
                        return
                    }
                }

                if (typeId === 2) {
                    await BasicResponse(res, 1, 'A Copies Deleted', deleteProduct)
                }
                if (typeId === 3) {
                    await BasicResponse(res, 1, 'A Stationery Deleted', deleteProduct)
                }
            }

        } catch (e) {
            console.log(e);
            await BasicResponse(res, 0, 'Something Went Wrong', e)
        } finally {
            await prisma.$disconnect();
        }
    }`

[austincrim]

Hey @OwaliShawon 👋,

Are you certain the data you are trying to update exists and you are passing the correct ID?

Could you share your full schema.prisma?

[vladi-stevanovic]

👋 Hello @OwaliShawon I'm going through pending GitHub Discussions to check if you need any help. Is this issue still open?
Please let us know if we can investigate it further or if you've already solved it, we'd love to know how!

It would be super useful for other users facing this problem! 🙌

[calidion]

encountered the same problem.

[EkaanshArora]

I faced this issue trying to insert a record in the database. This record had a relation set to another table, but the "foreign key" passed to the record did not map to a record in the relation table. For example:

User {
id String
postIds String[]
posts Posts[]
}

Post {
id String
userId String
User User
}

Now if you try to insert a Post with a userId that doesn't exist, you'll see the error.

[OleksandrKostrov]

The same issue

[jeff-an]

just happened to me for a prisma.create call on a table that has zero foreign keys.

[jeff-an]

stack trace:

PrismaClientKnownRequestError: 
Invalid `prisma.module.create()` invocation:


An operation failed because it depends on one or more records that were required but not found. Record to update not found.
    at In.handleRequestError (/app/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/runtime/library.js:122:6854)
    at In.handleAndLogRequestError (/app/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/runtime/library.js:122:6188)
    at In.request (/app/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/runtime/library.js:122:5896)
    at async l (/app/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/runtime/library.js:127:11167)
    at <anonymous> (/app/packages/REDACTED:122:9)
    at async Promise.all (index 0)
    at <anonymous> (/app/REDACTED:280:7)
    at async Proxy._transactionWithCallback (/app/node_modules/.pnpm/@prisma+client@5.13.0_prisma@5.13.0/node_modules/@prisma/client/runtime/library.js:127:9534)