Error with auto-migrate
Opened this issue · 1 comments
Deleted user commented
I want to create SQLite database:
root@freebsd:~ # ~/go/bin/pub auto-migrate --dsn "pub.db"
time=2023-12-15T08:46:17.596+03:00 level=INFO msg="setting all in_reply_to_id to null if the parent status does not exist"
2023/12/15 08:46:17 /root/go/pkg/mod/github.com/davecheney/pub@v0.0.0-20230509085442-b10b24ee062a/automigrate.go:21 no such table: statuses
[5.093ms] [rows:0] SELECT * FROM `statuses` WHERE in_reply_to_id is not null ORDER BY `statuses`.`id` LIMIT 1000
pub: error: no such table: statuses
13werwolf13 commented
same problem
[werwolf@home] /tmp/pub (main) ⚡
❯ ./pub --dsn /tmp/pub/pub.db auto-migrate --log-sql
time=2023-12-15T14:20:29.166+05:00 level=INFO msg="setting all in_reply_to_id to null if the parent status does not exist"
2023/12/15 14:20:29 /tmp/pub/automigrate.go:21 no such table: statuses
[1.601ms] [rows:0] SELECT * FROM `statuses` WHERE in_reply_to_id is not null ORDER BY `statuses`.`id` LIMIT 1000
pub: error: no such table: statuses
[werwolf@home] /tmp/pub (main) ⚡
❯
go version: go version go1.20.12 linux/amd64
os version: openSUSE Tumbleweed