You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Go Version
e.g. go version go1.11 linux/amd64
Obtained by running: go version 1.21
Stacktrace
Please provide if available
Additional context
Add any other context about the problem here.
I followed this issue and then when it came to the command $ migrate -path migrations/ -database $CHESS_DB_DSN force <VERSION> I get the error: error: can't read limit argument N
so now I am stuck... also a side note: If I am running this command as version 1 for the first time then what previous version am I supposed to revert to? version 0?
The text was updated successfully, but these errors were encountered:
CREATETABLEIF NOT EXISTS movies (
id bigserialPRIMARY KEY,
created_at timestamp(0) with time zoneNOT NULL DEFAULT NOW(),
title textNOT NULL,
year integerNOT NULL,
runtime integerNOT NULL,
genres text[] NOT NULL,
version integerNOT NULL DEFAULT 1
);
@Delta456 hi, you should use force and up commands separately:
migrate -path=... -database=... force 1 # This will mark db as 1st migration was applied (you have to check if state is correct still, command just marks migrations as not-dirty in schema_migrations table
migrate -path=... -database=... up 2 # This will try to apply 2nd migration to db
Describe the Bug
A clear and concise description of what the bug is.
Steps to Reproduce
Steps to reproduce the behavior:
migrate -path=./migrations -database=$CHESS_DB_DSN up
error: migration failed: syntax error at or near ")"
Expected Behavior
to migrate
Migrate Version
e.g. v3.4.0
Obtained by running:
migrate -version
:v4.17.0
Loaded Source Drivers
e.g. s3, github, go-bindata, gcs, file
Obtained by running:
migrate -help
Loaded Database Drivers
e.g. spanner, stub, clickhouse, cockroachdb, crdb-postgres, postgres, postgresql, pgx, redshift, cassandra, cockroach, mysql
Obtained by running:
migrate -help
Go Version
e.g. go version go1.11 linux/amd64
Obtained by running:
go version
1.21
Stacktrace
Please provide if available
Additional context
Add any other context about the problem here.
I followed this issue and then when it came to the command
$ migrate -path migrations/ -database $CHESS_DB_DSN force <VERSION>
I get the error:error: can't read limit argument N
so now I am stuck... also a side note: If I am running this command as version 1 for the first time then what previous version am I supposed to revert to? version 0?
The text was updated successfully, but these errors were encountered: