docker-outline icon indicating copy to clipboard operation
docker-outline copied to clipboard

SequelizeDatabaseError: column team.slackId does not exist

Open miaohf opened this issue 1 year ago • 0 comments

I get db error before my first login. please help!!

  SequelizeDatabaseError: column team.slackId does not exist
      at Query.formatError (/opt/outline/node_modules/sequelize/lib/dialects/postgres/query.js:392:16)
      at Query.run (/opt/outline/node_modules/sequelize/lib/dialects/postgres/query.js:87:18)
      at processTicksAndRejections (internal/process/task_queues.js:95:5)
      at async /opt/outline/node_modules/sequelize/lib/sequelize.js:619:16
      at async PostgresQueryInterface.select (/opt/outline/node_modules/sequelize/lib/dialects/abstract/query-interface.js:953:12)
      at async Function.findAll (/opt/outline/node_modules/sequelize/lib/model.js:1752:21)
      at async /opt/outline/build/server/routes/api/auth.js:52:19
      at async apiWrapperMiddleware (/opt/outline/build/server/routes/api/middlewares/apiWrapper.js:14:5)
      at async errorHandlingMiddleware (/opt/outline/build/server/middlewares/errorHandling.js:17:7)
      at async /opt/outline/node_modules/koa-mount/index.js:58:5
      at async /opt/outline/node_modules/koa-mount/index.js:52:26
      at async logger (/opt/outline/node_modules/koa-logger/index.js:67:7)

DatabaseError [SequelizeDatabaseError]: column team.slackId does not exist
    at Query.formatError (/opt/outline/node_modules/sequelize/lib/dialects/postgres/query.js:392:16)
    at Query.run (/opt/outline/node_modules/sequelize/lib/dialects/postgres/query.js:87:18)
    at processTicksAndRejections (internal/process/task_queues.js:95:5)
    at async /opt/outline/node_modules/sequelize/lib/sequelize.js:619:16
    at async PostgresQueryInterface.select (/opt/outline/node_modules/sequelize/lib/dialects/abstract/query-interface.js:953:12)
    at async Function.findAll (/opt/outline/node_modules/sequelize/lib/model.js:1752:21)
    at async /opt/outline/build/server/routes/api/auth.js:52:19
    at async apiWrapperMiddleware (/opt/outline/build/server/routes/api/middlewares/apiWrapper.js:14:5)
    at async errorHandlingMiddleware (/opt/outline/build/server/middlewares/errorHandling.js:17:7)
    at async /opt/outline/node_modules/koa-mount/index.js:58:5
    at async /opt/outline/node_modules/koa-mount/index.js:52:26
    at async logger (/opt/outline/node_modules/koa-logger/index.js:67:7) {
  parent: error: column team.slackId does not exist
      at Parser.parseErrorMessage (/opt/outline/node_modules/pg-protocol/dist/parser.js:278:15)
      at Parser.handlePacket (/opt/outline/node_modules/pg-protocol/dist/parser.js:126:29)
      at Parser.parse (/opt/outline/node_modules/pg-protocol/dist/parser.js:39:38)
      at Socket.<anonymous> (/opt/outline/node_modules/pg-protocol/dist/index.js:10:42)
      at Socket.emit (events.js:400:28)
      at Socket.emit (domain.js:475:12)
      at addChunk (internal/streams/readable.js:293:12)
      at readableAddChunk (internal/streams/readable.js:267:9)
      at Socket.Readable.push (internal/streams/readable.js:206:10)
      at TCP.onStreamRead (internal/stream_base_commons.js:188:23) {
    length: 110,
    severity: 'ERROR',
    code: '42703',
    detail: undefined,
    hint: undefined,
    position: '73',
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'parse_relation.c',
    line: '3514',
    routine: 'errorMissingColumn',
    sql: 'SELECT "team"."id", "team"."name", "team"."subdomain", "team"."domain", "team"."slackId", "team"."googleId", "team"."avatarUrl", "team"."sharing", "team"."signupQueryParams", "team"."guestSignin", "team"."documentEmbeds", "team"."collaborativeEditing", "team"."defaultUserRole", "team"."createdAt", "team"."updatedAt", "team"."deletedAt", "authenticationProviders"."id" AS "authenticationProviders.id", "authenticationProviders"."name" AS "authenticationProviders.name", "authenticationProviders"."enabled" AS "authenticationProviders.enabled", "authenticationProviders"."providerId" AS "authenticationProviders.providerId", "authenticationProviders"."createdAt" AS "authenticationProviders.createdAt", "authenticationProviders"."teamId" AS "authenticationProviders.teamId" FROM "teams" AS "team" LEFT OUTER JOIN "authentication_providers" AS "authenticationProviders" ON "team"."id" = "authenticationProviders"."teamId" WHERE ("team"."deletedAt" IS NULL);',
    parameters: undefined
  },

err.log

miaohf avatar Oct 24 '22 07:10 miaohf