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 , 5 years ago
Resolution: | → needsinfo |
---|---|
Status: | new → closed |
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.2 → master |
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.