Xata•2d ago

Prisma changes not being applied to database on specific fields.

I'm trying to build an admin dashboard/client support ticket page. I have a clients table which has "avatarUrl" and "imageId" fields as well as other random information needed for the site. All other fields can be updated with no problems, but for some reason the avatarUrl and imageId simply refuse to be updated. I can update these fields through the Prisma Studio, but no changes can be made through the

await prisma.client.update

await prisma.client.update

query works. I have ensured that the ID matches, and the updated information is valid, but no changes are ever made. Running

    const res1 = await prisma.client.update({
      where: { id },
      data: {
        avatarUrl: "Test02",
        imageId: "Test01"
      }
    });

    console.log(res1);

    const res1 = await prisma.client.update({
      where: { id },
      data: {
        avatarUrl: "Test02",
        imageId: "Test01"
      }
    });

    console.log(res1);

also returns the desired output, but again, changes aren't reflected on the database

1 Reply

tsg•2d ago

hi, what types are the avatarUrl and imageid? Can you perhaps give me your prisma schema file, or a relevant snippet of it? Then I can try perhaps reproducing on my side

Gaming

Programming

Prisma changes not being applied to database on specific fields.