LocalNotionApi Starting: Wed Apr  1 08:21:26 PM UTC 2026
Listing Environment...
DATABASE_URL=postgres://morty:SumSumRulz!@localhost:5432/ln-payment
FIREBASE_KEY_FILE=/opt/localnotion/ln-api/dist/config/firebaseServiceAccountKey.json
HOME=/opt/localnotion
INVOCATION_ID=0b2479490d2546bfa3119f11de11520e
JOURNAL_STREAM=9:1709866
LANG=en_US.UTF-8
LN_API_PORT=3000
LN_PAYMNT_PORT=3001
LOGNAME=morty
NODE_ENV=production
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/var/lib/snapd/snap/bin
PGADMIN_DEFAULT_EMAIL=devops@charlestontek.com
PGADMIN_DEFAULT_PASSWORD=unknown
POSTGRES_DB=ln-main
POSTGRES_HOST=localhost
POSTGRES_PASSWORD=SumSumRulz!
POSTGRES_PAYMENT_DB=ln-payment
POSTGRES_PORT=5432
POSTGRES_USER=morty
POSTMARK_API_KEY=a94aef7a-b5db-442b-913d-940a54299a0d
PWD=/opt/localnotion/ln-api
SHELL=/bin/bash
SHLVL=1
STRIPE_SECRET_KEY=sk_test_51STXRZGAKelMJatYHeFPgPlP3hTiMRpzXogkzpX3fhmPau6DOgLQs4zNZvzMceWNn7GVvYSAHTVp7ahV0Vhz1lmV00dx5kFQqu
STRIPE_WEBHOOK_SECRET=whsec_D6g0JytR20kfXHUT8nNkqb49ZdjF22gA
SYSTEMD_EXEC_PID=550187
TYPEORM_SYNCHRONIZE=0
USER=morty
_=/usr/bin/env
Listing Environment Finished
[dotenv@17.2.3] injecting env (0) from .env -- tip: ✅ audit secrets and track compliance: https://dotenvx.com/ops
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [NestFactory] Starting Nest application...
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] AppModule dependencies initialized +33ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] ClaimsModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] MulterModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] PostmarkModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] HttpModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] ConfigHostModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] AboutModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:27 PM     LOG [InstanceLoader] ConfigModule dependencies initialized +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmCoreModule dependencies initialized +102ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] TypeOrmModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] UserModule dependencies initialized +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] LocationsModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] ClientModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] BookingModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [InstanceLoader] ProductModule dependencies initialized +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] AboutController {/about}: +13ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/about, GET} route +3ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] BookingController {/Booking}: +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Booking/list, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Booking/create/:slug, POST} route +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Booking/pre-checkout/:slug, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Booking/details/:paymentTrackingId, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Booking/available_resources, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] ProductController {/Product}: +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/list/:slug/:location_slug, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/list, GET} route +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/delete/:id, DELETE} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/get/:id, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/create, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/update, PUT} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/get, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/calendar-resources, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Product/:id, GET} route +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] UserController {/User}: +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/:id, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/:uuid, PUT} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/:id, DELETE} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/update-password, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/auth/:email, GET} route +2ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/auth/:uid, DELETE} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/auth/claim/application/:uid, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/User/auth/claim/reset/:email, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] ClientController {/Client}: +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/create, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/list, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/:id, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/slug/:slug, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client, PUT} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/send-admin-invite, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/Client/:id, DELETE} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RoutesResolver] LocationsController {/locations}: +1ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/locations, POST} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/locations/list, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/locations/:id, GET} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/locations/:id, PATCH} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [RouterExplorer] Mapped {/locations/:id, DELETE} route +0ms
[Nest] 550194  - 04/01/2026, 8:21:28 PM     LOG [NestApplication] Nest application successfully started +38ms
listening on http://[::1]:3000
Successfully fetched user data: DxIbobp8PkS0ql8tSh5HooCHxQB2
Successfully fetched user data: UnySPQZOntZ4Xn0RcezJ9vUriZs1
Successfully fetched user data: DxIbobp8PkS0ql8tSh5HooCHxQB2
Successfully deleted user: DxIbobp8PkS0ql8tSh5HooCHxQB2
testclient@home.com
Successfully fetched user data: oAc0bvqIniafTgiyPQnLsAOjqTY2
Successfully deleted user: oAc0bvqIniafTgiyPQnLsAOjqTY2
testclient@home.com
[Nest] 550194  - 04/01/2026, 9:13:39 PM   ERROR [ExceptionsHandler] QueryFailedError: column TblBooking.location_id does not exist
    at PostgresQueryRunner.query (/opt/localnotion/ln-api/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:216:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async SelectQueryBuilder.loadRawResults (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2231:25)
    at async SelectQueryBuilder.getRawMany (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:646:29)
    at async SelectQueryBuilder.executeEntitiesAndRawResults (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2018:26)
    at async SelectQueryBuilder.getManyAndCount (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:850:36)
    at async BookingService.getBookingsByClient (/opt/localnotion/ln-api/dist/modules/booking/booking.service.js:241:31)
    at async /opt/localnotion/ln-api/node_modules/@nestjs/core/router/router-execution-context.js:46:28
    at async /opt/localnotion/ln-api/node_modules/@nestjs/core/router/router-proxy.js:9:17
    at async /opt/localnotion/ln-api/node_modules/@nestjs/core/router/router-explorer.js:199:17 {
  query: 'SELECT DISTINCT "distinctAlias"."TblBooking_id" AS "ids_TblBooking_id", "distinctAlias"."TblBooking_created_at" FROM (SELECT "TblBooking"."id" AS "TblBooking_id", "TblBooking"."paymentTrackingId" AS "TblBooking_paymentTrackingId", "TblBooking"."start_date" AS "TblBooking_start_date", "TblBooking"."end_date" AS "TblBooking_end_date", "TblBooking"."first_name" AS "TblBooking_first_name", "TblBooking"."last_name" AS "TblBooking_last_name", "TblBooking"."email" AS "TblBooking_email", "TblBooking"."phone_number" AS "TblBooking_phone_number", "TblBooking"."quantity" AS "TblBooking_quantity", "TblBooking"."final_rate_applied" AS "TblBooking_final_rate_applied", "TblBooking"."status" AS "TblBooking_status", "TblBooking"."created_at" AS "TblBooking_created_at", "TblBooking"."client_id" AS "TblBooking_client_id", "TblBooking"."resource_type_id" AS "TblBooking_resource_type_id", "TblBooking"."location_id" AS "TblBooking_location_id", "TblBooking__TblBooking_resourceType"."id" AS "TblBooking__TblBooking_resourceType_id", "TblBooking__TblBooking_resourceType"."name" AS "TblBooking__TblBooking_resourceType_name", "TblBooking__TblBooking_resourceType"."description" AS "TblBooking__TblBooking_resourceType_description", "TblBooking__TblBooking_resourceType"."product_id" AS "TblBooking__TblBooking_resourceType_product_id" FROM "tbl_booking" "TblBooking" LEFT JOIN "tbl_resource_type" "TblBooking__TblBooking_resourceType" ON "TblBooking__TblBooking_resourceType"."id"="TblBooking"."resource_type_id"  LEFT JOIN "tbl_client" "TblBooking__TblBooking_client" ON "TblBooking__TblBooking_client"."id"="TblBooking"."client_id" WHERE (((("TblBooking__TblBooking_client"."id" = $1))))) "distinctAlias" ORDER BY "distinctAlias"."TblBooking_created_at" DESC, "TblBooking_id" ASC LIMIT 10 OFFSET 0',
  parameters: [
    21
  ],
  driverError: error: column TblBooking.location_id does not exist
      at /opt/localnotion/ln-api/node_modules/pg/lib/client.js:545:17
      at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
      at async PostgresQueryRunner.query (/opt/localnotion/ln-api/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:181:25)
      at async SelectQueryBuilder.loadRawResults (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2231:25)
      at async SelectQueryBuilder.getRawMany (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:646:29)
      at async SelectQueryBuilder.executeEntitiesAndRawResults (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2018:26)
      at async SelectQueryBuilder.getManyAndCount (/opt/localnotion/ln-api/node_modules/typeorm/query-builder/SelectQueryBuilder.js:850:36)
      at async BookingService.getBookingsByClient (/opt/localnotion/ln-api/dist/modules/booking/booking.service.js:241:31)
      at async /opt/localnotion/ln-api/node_modules/@nestjs/core/router/router-execution-context.js:46:28
      at async /opt/localnotion/ln-api/node_modules/@nestjs/core/router/router-proxy.js:9:17 {
    length: 121,
    severity: 'ERROR',
    code: '42703',
    detail: undefined,
    hint: undefined,
    position: '882',
    internalPosition: undefined,
    internalQuery: undefined,
    where: undefined,
    schema: undefined,
    table: undefined,
    column: undefined,
    dataType: undefined,
    constraint: undefined,
    file: 'parse_relation.c',
    line: '3722',
    routine: 'errorMissingColumn'
  },
  length: 121,
  severity: 'ERROR',
  code: '42703',
  detail: undefined,
  hint: undefined,
  position: '882',
  internalPosition: undefined,
  internalQuery: undefined,
  where: undefined,
  schema: undefined,
  table: undefined,
  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'parse_relation.c',
  line: '3722',
  routine: 'errorMissingColumn'
}