#ERROR [ExceptionsHandler] relation "core.user" does not exist

1 messages · Page 1 of 1 (latest)

dawn wave
#

Hi, I am trying to set up the dev environment following the guide book, everything works fine untill I try to login using [email protected],
error msg:

error: error: relation "core.user" does not exist
[Nest] 52296  - 04/24/2024, 6:57:45 AM   ERROR [ExceptionsHandler] relation "core.user" does not exist
QueryFailedError: relation "core.user" does not exist
    at PostgresQueryRunner.query (/Users/yankaiwang/Projects/twenty/src/driver/postgres/PostgresQueryRunner.ts:331:19)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at SelectQueryBuilder.loadRawResults (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:3805:25)
    at SelectQueryBuilder.executeEntitiesAndRawResults (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:3551:26)
    at SelectQueryBuilder.getRawAndEntities (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:1670:29)
    at SelectQueryBuilder.getOne (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:1697:25)
    at AuthService.checkUserExists (/Users/yankaiwang/Projects/twenty/packages/twenty-server/src/engine/core-modules/auth/services/auth.service.ts:150:18)
    at AuthResolver.checkUserExists (/Users/yankaiwang/Projects/twenty/packages/twenty-server/src/engine/core-modules/auth/auth.resolver.ts:65:24)
    at target (/Users/yankaiwang/Projects/twenty/node_modules/@nestjs/core/helpers/external-context-creator.js:74:28)
    at Object.checkUserExists (/Users/yankaiwang/Projects/twenty/node_modules/@nestjs/core/helpers/external-proxy.js:9:24)
Exception Captured
  {
    operation: { name: 'CheckUserExists', type: 'query' },
    document: 'query CheckUserExists($email: String!) {\n' +
      '  checkUserExists(email: $email) {\n' +
      '    exists\n' +
      '    __typename\n' +
      '  }\n' +
      '}',
    user: undefined
  }
  [
    QueryFailedError: relation "core.user" does not exist
        at PostgresQueryRunner.query (/Users/yankaiwang/Projects/twenty/src/driver/postgres/PostgresQueryRunner.ts:331:19)
        at processTicksAndRejections (node:internal/process/task_queues:95:5)
        at SelectQueryBuilder.loadRawResults (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:3805:25)
        at SelectQueryBuilder.executeEntitiesAndRawResults (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:3551:26)
        at SelectQueryBuilder.getRawAndEntities (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:1670:29)
        at SelectQueryBuilder.getOne (/Users/yankaiwang/Projects/twenty/src/query-builder/SelectQueryBuilder.ts:1697:25)
        at AuthService.checkUserExists (/Users/yankaiwang/Projects/twenty/packages/twenty-server/src/engine/core-modules/auth/services/auth.service.ts:150:18)
        at AuthResolver.checkUserExists (/Users/yankaiwang/Projects/twenty/packages/twenty-server/src/engine/core-modules/auth/auth.resolver.ts:65:24)
        at target (/Users/yankaiwang/Projects/twenty/node_modules/@nestjs/core/helpers/external-context-creator.js:74:28)
        at Object.checkUserExists (/Users/yankaiwang/Projects/twenty/node_modules/@nestjs/core/helpers/external-proxy.js:9:24) {
      path: [ 'checkUserExists' ],
      locations: [ [Object] ],
      extensions: [Object: null prototype] {}
    }
  ]
#

I checked the init.sql, there is only some basic setup, should we put test user in there?

// from init.sql
CREATE DATABASE "default";
CREATE DATABASE "test";
CREATE USER twenty PASSWORD 'twenty';
ALTER ROLE twenty superuser;
#

nvm, just noticed that I missed this step:

npx nx database:reset twenty-server