Could anyone help me understand why my `$queryRaw`...
# orm-helpd
Dan Calise
10/20/2022, 2:45 PMCould anyone help me understand why my
$queryRaw Copy code
code: 'P2010',
clientVersion: '4.3.1',
meta: { code: 'N/A', message: 'N/A' },👀 1
v
Vladi Stevanovic
10/21/2022, 7:46 AM
👋 Hi @Dan Calise thank you for raising this question, my team mates @Nurul and @Raphael Etim will check it asap!
In the meantime, can you tell us a little more about your use case? (e.g. is it a personal / work project, is it in prod). It'll help us frame our answers!
Vladi Stevanovic
10/21/2022, 7:47 AM
If this is related to this question I assume the stack is Next.js and an SQLite database.
n
Nurul
10/21/2022, 3:51 PMHello @Dan Calise 👋
Could you please share the raw query which you are invoking so that I can try to replicate it locally?
And also please let us know the Prisma version that you are using.
v
Vladi Stevanovic
10/25/2022, 7:03 PM
👋 Hi @Dan Calise did you have a chance to check Nurul's question? Let us know if you still need help here!
d
Dan Calise
10/26/2022, 3:34 PMHi sorry, I never saw this. It’s really any simple raw query.. her was one
Copy code
const league = await prisma.$queryRaw(
Prisma.sql`SELECT DatabaseCreationDate FROM LeagueGeneral`
);Dan Calise
10/26/2022, 3:35 PMi tried without Prisma.sql as well
Dan Calise
10/26/2022, 3:37 PMversion 4.5.0
n
Nurul
10/26/2022, 6:24 PM@Dan Calise Can you share the LeagueGeneral model? I would need that to simulate this query.
d
Dan Calise
10/26/2022, 6:38 PMi trimmed it down but here you go
Dan Calise
10/26/2022, 6:39 PM Copy code
model LeagueGeneral {
LeagueYearOutput Int
OutputName String @id
OutputFileFormat String
LeagueOwner String
DatabaseCreationDate String
}