Theo's Typesafe Cult•2y ago

Auth0 Problems within T3 App - ID Too Long

Hey there, I am having some issues with auth0 Provider in ct3 using the prisma provider generated. I added the auth0 provider but now I am getting this error anytime I use the sign in button

Invalid `p.account.create()` invocation in
/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected]_olz4gynuwklrt45ffo7wirvoly/node_modules/@next-auth/prisma-adapter/dist/index.js:19:42

  16 },
  17 updateUser: ({ id, ...data }) => p.user.update({ where: { id }, data }),
  18 deleteUser: (id) => p.user.delete({ where: { id } }),
→ 19 linkAccount: (data) => p.account.create(
The provided value for the column is too long for the column's type. Column: access_token Error: 
Invalid `p.account.create()` invocation in
/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected]_olz4gynuwklrt45ffo7wirvoly/node_modules/@next-auth/prisma-adapter/dist/index.js:19:42

  16 },
  17 updateUser: ({ id, ...data }) => p.user.update({ where: { id }, data }),
  18 deleteUser: (id) => p.user.delete({ where: { id } }),
→ 19 linkAccount: (data) => p.account.create(
The provided value for the column is too long for the column's type. Column: access_token
    at fn.handleRequestError (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:6477)
    at fn.handleAndLogRequestError (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:5907)
    at fn.request (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:5786)
    at async t._request (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:177:10477) {
  name: 'LinkAccountError',
  code: 'P2000'
}

Invalid `p.account.create()` invocation in
/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected]_olz4gynuwklrt45ffo7wirvoly/node_modules/@next-auth/prisma-adapter/dist/index.js:19:42

  16 },
  17 updateUser: ({ id, ...data }) => p.user.update({ where: { id }, data }),
  18 deleteUser: (id) => p.user.delete({ where: { id } }),
→ 19 linkAccount: (data) => p.account.create(
The provided value for the column is too long for the column's type. Column: access_token Error: 
Invalid `p.account.create()` invocation in
/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected]_olz4gynuwklrt45ffo7wirvoly/node_modules/@next-auth/prisma-adapter/dist/index.js:19:42

  16 },
  17 updateUser: ({ id, ...data }) => p.user.update({ where: { id }, data }),
  18 deleteUser: (id) => p.user.delete({ where: { id } }),
→ 19 linkAccount: (data) => p.account.create(
The provided value for the column is too long for the column's type. Column: access_token
    at fn.handleRequestError (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:6477)
    at fn.handleAndLogRequestError (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:5907)
    at fn.request (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:174:5786)
    at async t._request (/home/ubuntu/code/apollo-computers/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:177:10477) {
  name: 'LinkAccountError',
  code: 'P2000'
}

Solution:

I feel dumb Tropic ensure you read the notes next time...

Jump to solution

5 Replies

Rhys•2y ago

From the error it looks like probably the id is too long, maybe try console.logging what the id it’s trying to create with is and also using a larger string size in Prisma?

tropicOP•2y ago

Maybe, wasnt sure if it would mess up something with Auth0 Not too sure how nextauth works, i fked this one up some how xD

Solution

tropic•2y ago

I feel dumb Tropic ensure you read the notes next time

Rhys•2y ago

uh oh

tropicOP•2y ago

Yeah, I didnt realize, I just changed from sqlite to mysql and started getting that error

Gaming

Programming

Auth0 Problems within T3 App - ID Too Long