search

hoarder-app / hoarder

A self-hostable bookmark-everything app (links, notes and images) with AI-based automatic tagging and full text search
https://hoarder.app
GNU Affero General Public License v3.0
5.93k stars 195 forks source link

"no such table: tasks" when adding a new item #666

Open Azhelor opened 6 hours ago

Azhelor commented 6 hours ago

Describe the Bug

Hi,

I just installed the last version of Hoarder (v 0.19.0) following the steps here : https://docs.hoarder.app/Installation/docker/

Installation, sign up and log in worked just fine but when I'm trying to add a new item from the home page, I get a red alert saying "no such table: tasks". But when I refresh the page, the item appears.

By the way, I got a similar mistake when trying to delete an item, with a red alert bow saying "Something went wrong. There was a problem with your request." Mention that because I assume both errors could be linked.

I found another bug report with the same error and found out that my queue.db is also empty this might come from a database migration error, but I have no idea how to fix that since I'm pretty new to all of this.

Thanks for your help.

Steps to Reproduce

  1. Install a brand new Hoarder with docker compose
  2. Create user and log in
  3. Try to add a new item

Expected Behaviour

I guess item should be immediately added and visible and no error should be shown.

Screenshots or Additional Context

No response

Device Details

No response

Exact Hoarder Version

v0.19.0

MohamedBassem commented 6 hours ago

Hey, can you try deleting queue.db and restarting the container? That should recreate it