const userRecord = await db.user.update({
    where: {
        id: userIdForDb,
    },
    data: {
        // Remove `id` from here if it was still there, and remove all `?.` from validatedData.data.field
        firstName: validatedData.data.firstName,
        lastName: validatedData.data.lastName,
        postcode: validatedData.data.postcode, // Make sure these fields are correctly passed from validatedData
        email: validatedData.data.email,
        phoneNumber: validatedData.data.phoneNumber,
        aboutMe: validatedData.data.aboutMe,
    },
});

const updatedClerkUser = await (await clerkClient()).users.updateUser(user.id, {
     publicMetadata: {
         onboarded: true,
     },
});

Server: User ID from Clerk session (currentUser): user_2zPQd2ZhtqDzxIU7NU2s45utyRs
Server: User ID from form data (validatedData): {
  firstName: 'Lama',
  lastName: 'Baioi',
  postcode: 'BL1 3BH',
  email: 'mansoor.eb@gmail.com',
  phoneNumber: '0753791889',
  aboutMe: 'FIRST NAME LAST NAME'
}
Server: Attempting to update DB for ID: user_2zPQd2ZhtqDzxIU7NU2s45utyRs
prisma:query SELECT 1
prisma:query UPDATE "public"."User" SET "firstName" = $1, "lastName" = $2, "postcode" = $3, "email" = $4, "phoneNumber" = $5, "aboutMe" = $6, "updatedAt" = $7 WHERE ("public"."User"."id" = $8 AND 1=1) RETURNING "public"."User"."id", "public"."User"."name", "public"."User"."firstName", "public"."User"."lastName", "public"."User"."postcode", "public"."User"."avatar", "public"."User"."email", "public"."User"."phoneNumber", "public"."User"."aboutMe", "public"."User"."createdAt", "public"."User"."updatedAt"
Server: Successfully updated DB user record with ID: user_2zPQd2ZhtqDzxIU7NU2s45utyRs
Server: Clerk publicMetadata updated for user: user_2zPQd2ZhtqDzxIU7NU2s45utyRs
 PUT /api/onboarding 200 in 1074ms
 GET / 200 in 152ms

    try {
      const response = await fetch("/api/onboarding", {
        method: "PUT",
        headers: {
          "Content-Type": "application/json",
        },
        body: JSON.stringify(formData),
      });
      console.log('body:', formData);

      if (!response.ok) {
        const errorData = await response.json();
        console.error("API Error:", errorData.error);
        if (errorData.details) {
          const apiErrors: Partial<FormData> = {};
          errorData.details.forEach((detail: any) => {
            if (detail.path && detail.path[0]) {
              apiErrors[detail.path[0] as keyof FormData] = detail.message;
            }
          });
          setErrors(apiErrors);
        }
        throw new Error(errorData.error || "Failed to submit onboarding data");
      }

      setIsSubmitted(true);
    } catch (error) {
      console.error("Onboarding submission error:", error);
      setErrors({ email: "An unexpected error occurred. Please try again." });
    } finally {
      setIsSubmitting(false);
    }
  };

  const validateForm = (): boolean => {
    try {
      formDataSchema.parse(formData);
      setErrors({});
      return true;
    } catch (e) {
      if (e instanceof z.ZodError) {
        const newErrors: Partial<FormData> = {};
        for (const issue of e.issues) {
          if (issue.path[0]) {
            newErrors[issue.path[0] as keyof FormData] = issue.message;
          }
        }
        setErrors(newErrors);
      }
      return false;
    }
  };

const userRecord = await db.user.update({
            where: {
                id: userIdForDb,
            },
            data: {
                // Remove `id` from here if it was still there, and remove all `?.` from validatedData.data.field
                firstName: validatedData.data.firstName,
                lastName: validatedData.data.lastName,
                postcode: validatedData.data.postcode, // Make sure these fields are correctly passed from validatedData
                email: validatedData.data.email,
                phoneNumber: validatedData.data.phoneNumber,
                aboutMe: validatedData.data.aboutMe,
            },
        });
        console.log("Server: Successfully updated DB user record with ID:", userRecord.id);

const userRecord = await db.user.update({
            data: {
                id: userIdForDb || validatedData.data.whatever
                firstName: validatedData.data.firstName,
                lastName: validatedData.data.lastName,
                postcode: validatedData.data.postcode, // Make sure these fields are correctly passed from validatedData
                email: validatedData.data.email,
                phoneNumber: validatedData.data.phoneNumber,
                aboutMe: validatedData.data.aboutMe,
            },
        });
        console.log("Updated user", userRecord);

"db:generate": "prisma migrate dev",
"db:migrate": "prisma migrate deploy",
"db:push": "prisma db push",
"db:studio": "prisma studio",

import { neon } from '@neondatabase/serverless';

export async function GET() {
    const sql = neon(process.env.DATABASE_URL);

    const rows = await sql("SELECT * FROM posts");

    return Response.json({ rows })
}

rm -rf prisma/migrations/
rm -rf .next
pnpm db:generate
pnpm db:push 

UPDATE "public"."User" SET "firstName" = "Some User", "lastName" = "Whatever", "postcode" = $3, "email" = $4, "phoneNumber" = $5, "aboutMe" = $6, "updatedAt" = $7 WHERE ("public"."User"."id" = "user_dgfdhfhfg" AND 1=1) RETURNING "public"."User"."id", "public"."User"."name", "public"."User"."firstName", "public"."User"."lastName", "public"."User"."postcode", "public"."User"."avatar", "public"."User"."email", "public"."User"."phoneNumber", "public"."User"."aboutMe", "public"."User"."createdAt", "public"."User"."updatedAt"

UPDATE "public"."User"
SET
    "firstName" = 'Mansoor UPDATED',
    "lastName" = 'Barri UPDATED',
    "postcode" = 'MV12 9XH',
    "email" = 'mansoor.eb.ak@gmail.com',
    "phoneNumber" = '0750357919349',
    "aboutMe" = 'this is updated on neon'
WHERE
    "public"."User"."id" = 'user_2zWKT4tvKGWacjE12hZ1A5vPzAi'
RETURNING
    "public"."User"."id",
    "public"."User"."name",
    "public"."User"."firstName",
    "public"."User"."lastName",
    "public"."User"."postcode",
    "public"."User"."avatar",
    "public"."User"."email",
    "public"."User"."phoneNumber",
    "public"."User"."aboutMe",
    "public"."User"."createdAt",
    "public"."User"."updatedAt";