db-migrate / db-migrate/node-db-migrate

Assertion Error (unknown column 'run_on' in 'order clause') even without a 'run_on' column

Open
#836 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
2.3k
Forks
361
PR merge metrics
No merged PRs in 30d

Description

## I'm submitting a...

- [ ] Bug report
- [ ] Feature request
- [*] Question

## Current behavior

Whenever I create a new migration file, the creation is successful while after changing the table structure according to the datatypes available or even using a test table with just 2 or 3 columns, I have been getting this error:
[ERROR] AssertionError [ERR_ASSERTION]: ifError got unwanted exception: Unknown column 'run_on' in 'order clause'
while I'm trying to migrate.

I do not have an order clause nor a run_on column in my table.

I have setup correctly but the issue still persists.

## Expected behavior

The desired behaviour is migrating the table to the database.

## Minimal reproduction of the problem with instructions
Any command apart from the creation reproduces this behaviour.

## Environment



db-migrate version: 10.2.4
db-migrate driver with versions: mysql 10.2.4

Additional information:
- Node version: v20.10.0
- Platform: Mac

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.