Next.js Vercel Deployment Error: Failed to Collect Page Data for /api/favourites/[drivingSchoolId]

Hello, I'm trying to deploy my Next.js application to Vercel, but I'm encountering a build error related to a specific API route. The error message indicates that there was a failure in collecting page data for /api/favourites/[drivingSchoolId], and the build process exits with code 1. Below is the relevant part of the error log:

Error message:

1 at fa (/vercel/path0/node_modules/@prisma/client/runtime/library.js:33:69)2    at new t (/vercel/path0/node_modules/@prisma/client/runtime/library.js:131:739)3    at 13543 (/vercel/path0/.next/server/app/api/favourites/[drivingSchoolId]/route.js:1:3921)4    at t (/vercel/path0/.next/server/webpack-runtime.js:1:128)5    at 91782 (/vercel/path0/.next/server/app/api/favourites/[drivingSchoolId]/route.js:1:2942)6    at t (/vercel/path0/.next/server/webpack-runtime.js:1:128)7    at 40100 (/vercel/path0/.next/server/app/api/favourites/[drivingSchoolId]/route.js:1:1267)8    at t (/vercel/path0/.next/server/webpack-runtime.js:1:128)9    at t (/vercel/path0/.next/server/app/api/favourites/[drivingSchoolId]/route.js:1:4006)10    at /vercel/path0/.next/server/app/api/favourites/[drivingSchoolId]/route.js:1:4041 {11  clientVersion: '5.16.2',12  errorCode: undefined13}14> Build error occurred15Error: Failed to collect page data for /api/favourites/[drivingSchoolId]16    at /vercel/path0/node_modules/next/dist/build/utils.js:1268:1517    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {18  type: 'Error'19}20Error: Command "npm run build" exited with 1

Vercel Alum

Hi, and welcome !

We'd need some more information on your code. Would you mind sharing how you've set up your app?

In the meantime, you can also check out some suggestions from the community: https://github.com/vercel/next.js/discussions/50955

Hello, Yes sure I will provide more info. my /api/favourites/[drivingSchoolId] route code

1import { NextResponse } from "next/server";23import getCurrentUser from "@/app/actions/getCurrentUser";4import prisma from "@/app/libs/prismadb";56interface IParams {7    drivingSchoolId?: string;8}910export async function POST(request: Request, { params }: { params: IParams }) {11    const currentUser = await getCurrentUser();12    if (!currentUser) return NextResponse.error();1314    const { drivingSchoolId } = params;1516    if (!drivingSchoolId) {17        return NextResponse.json({ success: true, message: "Tato autoškola není dostupná" }, { status: 400 });18    }1920    const alreadyExists = await prisma.user_favourite_car_driving_school.findFirst({21        where: {22            AND: [{ user_id: currentUser.user_id }, { driving_school_id: Number(drivingSchoolId) }],23        },24    });2526    if (alreadyExists) return NextResponse.json({ success: true, message: "Počkejte chvílu, ukládám záznam" }, { status: 400 });2728    await prisma.user_favourite_car_driving_school.create({29        data: {30            user_id: currentUser.user_id,31            driving_school_id: Number(drivingSchoolId),32        },33    });3435    return NextResponse.json({ success: true, message: "Označeno jako oblíbené" }, { status: 200 });36}3738export async function DELETE(request: Request, { params }: { params: IParams }) {39    const currentUser = await getCurrentUser();4041    if (!currentUser) return NextResponse.error();4243    const { drivingSchoolId } = params;4445    if (!drivingSchoolId) return NextResponse.json({ success: true, message: "Tato autoškola není dostupná" }, { status: 400 });4647    await prisma.user_favourite_car_driving_school.deleteMany({48        where: {49            AND: [{ user_id: currentUser.user_id }, { driving_school_id: Number(drivingSchoolId) }],50        },51    });5253    return NextResponse.json({ success: true, message: "Zrušeno oblíbené" }, { status: 200 });54}

my tsconfig.json

1{2    "compilerOptions": {3        "lib": ["dom", "dom.iterable", "esnext"],4        "allowJs": true,5        "skipLibCheck": true,6        "strict": true,7        "noEmit": true,8        "esModuleInterop": true,9        "module": "esnext",10        "moduleResolution": "Node",11        "resolveJsonModule": true,12        "isolatedModules": true,13        "jsx": "preserve",14        "incremental": true,15        "plugins": [16            {17                "name": "next"18            }19        ],20        "paths": {21            "@/*": ["./*"]22        }23    },24    "include": ["next-env.d.ts", "**/*.ts", "**/*.tsx", ".next/types/**/*.ts"],25    "exclude": ["node_modules"]26}27

Vercel Alum

Hi, !

Thanks for your patience 🙏

After taking a look at your code, it looks like the issue is likely related to Prisma client initialization or database connection during the Vercel deployment process.

Some ideas on how to troubleshoot this:

Adding a postinstall script to generate the Prisma client during build.
Verifying the database connection string in Vercel's environment variables.
Updating the Prisma client initialization to use a singleton pattern.
Implementing error handling in the API route.
Checking compatibility between Prisma and Next.js versions.
Verifying the Prisma schema against the database structure.

Let us know how you get on!

Vercel Alum

I also spotted this on Twitter, unsure if it's related to your issue but might be worth sharing: https://x.com/2co_p/status/1828714135242125815

This topic is closed. It no longer accepts new replies.

Hello, Yes sure I will provide more info. my /api/favourites/[drivingSchoolId] route code

1import { NextResponse } from "next/server";23import getCurrentUser from "@/app/actions/getCurrentUser";4import prisma from "@/app/libs/prismadb";56interface IParams {7    drivingSchoolId?: string;8}910export async function POST(request: Request, { params }: { params: IParams }) {11    const currentUser = await getCurrentUser();12    if (!currentUser) return NextResponse.error();1314    const { drivingSchoolId } = params;1516    if (!drivingSchoolId) {17        return NextResponse.json({ success: true, message: "Tato autoškola není dostupná" }, { status: 400 });18    }1920    const alreadyExists = await prisma.user_favourite_car_driving_school.findFirst({21        where: {22            AND: [{ user_id: currentUser.user_id }, { driving_school_id: Number(drivingSchoolId) }],23        },24    });2526    if (alreadyExists) return NextResponse.json({ success: true, message: "Počkejte chvílu, ukládám záznam" }, { status: 400 });2728    await prisma.user_favourite_car_driving_school.create({29        data: {30            user_id: currentUser.user_id,31            driving_school_id: Number(drivingSchoolId),32        },33    });3435    return NextResponse.json({ success: true, message: "Označeno jako oblíbené" }, { status: 200 });36}3738export async function DELETE(request: Request, { params }: { params: IParams }) {39    const currentUser = await getCurrentUser();4041    if (!currentUser) return NextResponse.error();4243    const { drivingSchoolId } = params;4445    if (!drivingSchoolId) return NextResponse.json({ success: true, message: "Tato autoškola není dostupná" }, { status: 400 });4647    await prisma.user_favourite_car_driving_school.deleteMany({48        where: {49            AND: [{ user_id: currentUser.user_id }, { driving_school_id: Number(drivingSchoolId) }],50        },51    });5253    return NextResponse.json({ success: true, message: "Zrušeno oblíbené" }, { status: 200 });54}

my tsconfig.json

1{2    "compilerOptions": {3        "lib": ["dom", "dom.iterable", "esnext"],4        "allowJs": true,5        "skipLibCheck": true,6        "strict": true,7        "noEmit": true,8        "esModuleInterop": true,9        "module": "esnext",10        "moduleResolution": "Node",11        "resolveJsonModule": true,12        "isolatedModules": true,13        "jsx": "preserve",14        "incremental": true,15        "plugins": [16            {17                "name": "next"18            }19        ],20        "paths": {21            "@/*": ["./*"]22        }23    },24    "include": ["next-env.d.ts", "**/*.ts", "**/*.tsx", ".next/types/**/*.ts"],25    "exclude": ["node_modules"]26}27