Skip to content

Migrating from MySQL to Postgresql - invalid input syntax for type uuid #3932

@joshuaevans9807

Description

@joshuaevans9807

Describe the Bug

When i migrate from MySQL by exporting into either an SQL file or CSV files, i get the above error when i import the website_event table. Full output is below using CSV files

What do i need to do to fix the invalid input syntax?

Database

PostgreSQL

Relevant log output

postgres@postgresql:~/umami$ psql -U postgres -d umami -c "\COPY website_event FROM 'website_event.csv' CSV NULL '\N'"

ERROR:  invalid input syntax for type uuid: "event_id"
CONTEXT:  COPY website_event, line 1, column event_id: "event_id"

Which Umami version are you using? (if relevant)

v2.20.2

Which browser are you using? (if relevant)

N/A

How are you deploying your application? (if relevant)

Docker Compose using a separate server for the database

Metadata

Metadata

Assignees

No one assigned

    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