Condo's Sugar Baby Posts - Answer Overflow

Condo's Sugar Baby

•Created by Condo's Sugar Baby on 9/17/2024 in #help

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

2 replies

XXata

•Created by Condo's Sugar Baby on 8/1/2024 in #help

Issues connecting to the database

I'm trying to connect to my db using the new Postgres + Prisma setup. For some reason whenever I try to push or migrate I keep getting the message

Error: P1001: Can't reach database server at `us-east-1.sql.xata.sh:5432`

Please make sure your database server is running at `us-east-1.sql.xata.sh:5432`.

Error: P1001: Can't reach database server at `us-east-1.sql.xata.sh:5432`

Please make sure your database server is running at `us-east-1.sql.xata.sh:5432`.

I've used Postgres connections to other databases as well, and I've confirmed that the Postgres is enabled If it makes any difference, I'm using Prisma 5.17.0 on a Next.js 14.2.5 project. Any help is much appreciated, thank you!

9 replies

Gaming

Programming