dkforest

commit 0a295abba9273de6cb2a283c4e38c750a1d0ed0f
parent 8af5e6de6d81253f12eb991680ad2231e8cad03d
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Sun, 29 Jan 2023 05:51:33 -0800

re-delete soft-deleted links when rebuilding index

Diffstat:
M
pkg/web/handlers/handlers.go
 | 
1
+

1 file changed, 1 insertion(+), 0 deletions(-)
diff --git a/pkg/web/handlers/handlers.go b/pkg/web/handlers/handlers.go
@@ -1408,6 +1408,7 @@ func LinksReindexHandler(c echo.Context) error {
 	if err := database.DB.Exec(`INSERT INTO fts5_links(fts5_links) VALUES('rebuild')`).Error; err != nil {
 		logrus.Error(err)
 	}
+	database.DB.Exec(`delete from fts5_links where rowid in (select id from links where deleted_at is not null)`)
 	return c.Redirect(http.StatusFound, c.Request().Referer())
 }