Opened 5 years ago

Closed 5 years ago

#30896 closed Bug (needsinfo)

"OperationalError: (1054, "Unknown column ...)" error when running migrations on an empty MySQL database.

Reported by: coolnodje Owned by: nobody
Component: Migrations Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

I keep hitting this problem while trying to replay an entire database migrations on a new fresh DB (from MySQL to PostgreSQL to be precise).

MySQL complains of a non existing column that was removed in a later stage of migrations.
This column doesn't exist in MySQL anymore as it is up to date with the newest migration. So it's only natural that the column cannot be found.

The question is: why is migrate looking for this column at this stage? It can only be found in the target new DB.

I'm not including any code at this stage but I guess I can probably find a way to share the whole migrations if this doesn't sound like an already addressed problem.

Change History (1)

comment:1 by Mariusz Felisiak, 5 years ago

Resolution: needsinfo
Status: newclosed
Summary: MySQLdb._exceptions.OperationalError: (1054, "Unknown column ...) error when `migrate --database=newfreshdb`"OperationalError: (1054, "Unknown column ...)" error when running migrations on an empty MySQL database.
Version: 2.2master

Thanks for this report, however we will not be able to reproduce this issue (or check if it is a duplicate of an existing one) without a small sample project or more detailed report.

Note: See TracTickets for help on using tickets.
Back to Top