Migration error on latest update 1.3.1

Questions
,
1

Migration Error on latest release (and the one before)

Hi guys please , im running into this migration error in mysql (installed on cloudways and running with pm2)

image
image1887×157 54.9 KB

Information on your n8n setup

  • n8n version:1.3.1
  • Database:mysqldb/mariadb
  • Running n8n via (Docker, npm, n8n cloud, desktop app):pm2 cloudways / and tried with node too
  • Operating system:ubuntu
4

Hi @Mehdi_YAHIA_CHERIF, welcome to the community!

I am sorry you’re having trouble. The duplicate columns name problem suggests a previous migration could have been interrupted, leaving your database in an inconsistent state.

To resolve this I’d restore a previous backup that you know is working, then re-run the migration without interrupting it, watching out for any errors.

Alternatively, seeing MySQL/MariaDB as a backend database is deprecated, you might want to consider exporting your workflows and credentials using the CLI on this occasion. Then start n8n with a fresh PostgreSQL database and import workflows + credentials using the CLI.