Nodejs Express Prisma-Session商店奇怪错误

Question

软件包Prisma-Session商店拒绝工作 这是我的设置

  session({
    store: new PrismaSessionStore(new PrismaClient(), {
      checkPeriod: 2 * 60 * 1000, //ms
      dbRecordIdIsSessionId: true,
      dbRecordIdFunction: undefined
    }),
    name: 'sid',
    secret: process.env.KEY,
    saveUninitialized: true,
    resave: true,
    cookie: {
      path: '/',
      httpOnly: true,
      secure: process.env.NODE_ENV === 'development' ? false : true,
      maxAge: 2 * 60 * 60 * 1000 // ms
    }
  })
);

，我有这个奇怪的错误 知道Prisma在包装外工作完美

set(): Error:
Invalid `this.prisma[this.sessionModelName].update()` invocation in
/Users/hossam/wk/pim/node_modules/@quixo3/prisma-session-store/dist/lib/prisma-session-store.js:493:81

  490 case 3:
  491     _a.trys.push([3, 8, , 9]);
  492     if (!(existingSession !== null)) return [3 /*break*/, 5];
→ 493     return [4 /*yield*/, this.prisma[this.sessionModelName].update(
  The provided value for the column is too long for the column's type. Column: data
Error:
Invalid `this.prisma[this.sessionModelName].update()` invocation in
/Users/hossam/wk/pim/node_modules/@quixo3/prisma-session-store/dist/lib/prisma-session-store.js:493:81

  490 case 3:
  491     _a.trys.push([3, 8, , 9]);
  492     if (!(existingSession !== null)) return [3 /*break*/, 5];
→ 493     return [4 /*yield*/, this.prisma[this.sessionModelName].update(
  The provided value for the column is too long for the column's type. Column: data
    at RequestHandler.request (/Users/hossam/wk/pim/node_modules/@prisma/client/runtime/index.js:49022:15)
    at async PrismaClient._request (/Users/hossam/wk/pim/node_modules/@prisma/client/runtime/index.js:49919:18)```

Answer 1

错误消息说data的列值太长。这是session模型上的一个字段，在您的schema.prisam中 prisma会话商店说要创建。我认为您必须使该列更大。我不知道您使用哪个数据库，但以下是文档用于字符串。

如果您在schema.prisma中像This Data String一样设置它，请根据数据库检查文档是否为字符串的默认值。

您可以添加数据字符串 @db.varchar（＆lt; insert Length在此处＆gt;）以明确设置字符长度。