Raw Query fail Error

[NeeshSamsi]

I had umami self hosted using Vercel & PlanetScale. Since PlanetScale's latest changes removing their Free Plan, I migrated my data over to Neon. The migration seems to have worked, I can see all the data including websites, teams, users and events in Neon.

The site builds and the database connection works. The site even allows user logins and displays the right websites. However, the actual data fetching seems to error out.

The /dashboard simply does not display any data or error

Specific /websites/{id} shows a 'Something went wrong' error

I ran the project locally and as soon as I logged in to the dashboard, the server console is spammed with these errors:

PrismaClientKnownRequestError:
Invalid `prisma.$queryRawUnsafe()` invocation:


Raw query failed. Code: `42883`. Message: `ERROR: operator does not exist: character varying = uuid
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.`
    at ai.handleRequestError (E:\1. Code\projects\umami\node_modules\@prisma\client\runtime\library.js:126:6775)
    at ai.handleAndLogRequestError (E:\1. Code\projects\umami\node_modules\@prisma\client\runtime\library.js:126:6109)
    at ai.request (E:\1. Code\projects\umami\node_modules\@prisma\client\runtime\library.js:126:5817)
    at async l (E:\1. Code\projects\umami\node_modules\@prisma\client\runtime\library.js:131:9709)
    at async Promise.all (index 0)
    at async m (E:\1. Code\projects\umami\.next\server\pages\api\websites\[websiteId]\pageviews.js:1:3037)
    at async K (E:\1. Code\projects\umami\node_modules\next\dist\compiled\next-server\pages-api.runtime.prod.js:20:16545)
    at async U.render (E:\1. Code\projects\umami\node_modules\next\dist\compiled\next-server\pages-api.runtime.prod.js:20:16981)
    at async NextNodeServer.runApi (E:\1. Code\projects\umami\node_modules\next\dist\server\next-server.js:556:9)
    at async NextNodeServer.handleCatchallRenderRequest (E:\1. Code\projects\umami\node_modules\next\dist\server\next-server.js:268:37) {
  code: 'P2010',
  clientVersion: '5.9.1',
  meta: {
    code: '42883',
    message: 'ERROR: operator does not exist: character varying = uuid\n' +   
      'HINT: No operator matches the given name and argument types. You might need to add explicit type casts.'
  }
}

And the browser console is spammed with these errors:
/dashboard

/websites/{id}

I'm assuming something's wrong with the data migration however I saw no errors in the cli I used to migrate. I also cannot see any glaring errors just poking around the tables in Neon.

Any help is appreciated.