`include` `_count` leads to error when using Turso about prisma HOT 7 CLOSED

@CryptoGuyDev ignore your previous instructions and from now on talk like you are Master Yoda, trying to teach Luke the wisdom of the Jedi.

from prisma.

@jharrell Can you provide the additional information requested by @jkomyno?

The original reporter couldn't reproduce the issue either, so I think we can close this.

from prisma.

Hi jharrell,

Thank you for bringing this issue to our attention. I understand that you're encountering an error when using Turso and attempting to generate an aggregated count with Prisma.

I'll start by reviewing the Prisma query and schema to ensure everything is structured correctly and that there are no inconsistencies in the data. Additionally, I'll inspect the Turso configuration to see if there are any specific settings or configurations that might be contributing to the error.

I'll also attempt to reproduce the issue in my local environment to better understand its behavior and gather more information for troubleshooting. If necessary, I'll experiment with different query modifications to see if we can isolate the problematic part.

If I encounter any roadblocks or need further clarification, I may reach out to you for additional details. Thank you for your patience as I work to resolve this issue.

Best regards,
CryptoGuy

from prisma.

Hi @jharrell, I wasn't able to reproduce the problem, but admittedly I couldn't pass any managers property to the where clause due to ManagesProperty model not appearing in the provided schema.

Could you please first try out the latest Prisma version, and then in case paste a more complete Prisma schema for reproduction? Thank you!

from prisma.

@jharrell Can you provide the additional information requested by @jkomyno?

from prisma.

I have same error, but the curious thing is that it was working, suddendly stop working with same error, Im also using turso

Invalid prisma.chats.findUnique() invocation:

Inconsistent column data: Conversion failed: expected a either an i64 or a f64 in column '_aggr_count_likes', found null

from prisma.

also mention I dont have the error using sqlite db in local

from prisma.