davecheney/pub

Error with auto-migrate

Opened this issue · 1 comments

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

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