Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

journey_id appears twice in create table statement, database table does not create. #548

Open
Assignees
abheek9
@atwskris

Description

@atwskris

Bug description

[1] query failed: CREATE TABLE "journey_location" ("journey_id" uuid NOT NULL, "customer_id" bigint NOT NULL, "stepEntry" bigint NOT NULL, "stepEntryAt" TIMESTAMP NOT NULL DEFAULT now(), "journeyEntry" bigint NOT NULL DEFAULT '0', "journeyEntryAt" TIMESTAMP NOT NULL DEFAULT now(), "moveStarted" bigint, "messageSent" boolean, "journey_id" uuid NOT NULL, "step_id" uuid NOT NULL, "customer_id" bigint NOT NULL, "workspace_id" uuid NOT NULL, CONSTRAINT "PK_ccb6f56366731fb59ab930900d7" PRIMARY KEY ("journey_id", "customer_id"))[1] error: error: column "journey_id" specified more than once[1] [Nest] 2270916  - 01/27/2025, 4:47:17 AM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)...[1] QueryFailedError: column "journey_id" specified more than once[1]     at PostgresQueryRunner.query (/root/laudspeaker/laudspeaker/src/driver/postgres/PostgresQueryRunner.ts:299:19)[1]     at processTicksAndRejections (node:internal/process/task_queues:95:5)[1]     at PostgresQueryRunner.executeQueries (/root/laudspeaker/laudspeaker/src/query-runner/BaseQueryRunner.ts:659:13)[1]     at PostgresQueryRunner.createTable (/root/laudspeaker/laudspeaker/src/driver/postgres/PostgresQueryRunner.ts:571:9)[1]     at RdbmsSchemaBuilder.createNewTables (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:613:13)[1]     at RdbmsSchemaBuilder.executeSchemaSyncOperationsInProperOrder (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:224:9)[1]     at RdbmsSchemaBuilder.build (/root/laudspeaker/laudspeaker/src/schema-builder/RdbmsSchemaBuilder.ts:95:13)[1]     at DataSource.synchronize (/root/laudspeaker/laudspeaker/src/data-source/DataSource.ts:335:9)[1]     at DataSource.initialize (/root/laudspeaker/laudspeaker/src/data-source/DataSource.ts:273:43)

How to reproduce

  1. fresh install
  2. npm run start
  3. watch output

Environment

  • Laudspeaker Cloud
  • self-hosted Laudspeaker, version/commit:please provide

Additional context

Attempted both docker and external PostgreSQL.
Manual creation and correction of create statement does not solve this and it still throws and error.

Thank you for your bug report – we love squashing them!

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions


    [8]ページ先頭

    ©2009-2025 Movatter.jp