用久了好像数据库损坏了，未登录不能看见备忘录了

[peidongqi]

Describe the bug

用久了好像数据库损坏了，未登录不能看见备忘录了，怎么处理呢？重新部署过，问题依旧

Steps to reproduce

The version of Memos you're using

stable

Screenshots or additional context

[Issues-translate-bot]

Issue is not in English. It has been translated automatically.

---

Title: It seems that the database has been damaged after using it for a long time. You can no longer see the memo if you are not logged in.

[peidongqi]

问题不是英文的。它已被自动翻译。

**标题：**看来数据库在长时间使用后已经损坏了。如果您未登录，则无法再看到该备忘录。

公开的内容看不见了啊~！！！之前提示failed to list memos: database disk image is malformed (11) 、我发了一个备忘又没提示了，但公开的内容无法被读取，如何修复？

[Issues-translate-bot]

Issue is not in English. It has been translated automatically.

---

The question is not in English. It has been automatically translated.

Title: It appears that the database has become corrupted after prolonged use. If you are not logged in, you will no longer be able to see this note.

The public content cannot be seen~! ! ! Previously, I was prompted with failed to list memos: database disk image is malformed (11). I sent a memo and it was not prompted again, but the public content cannot be read. How to fix it?

[RoccoSmit]

Are you able to share the server logs when you are trying to view the public memos?

[peidongqi]

当您尝试查看公共备忘录时，是否可以共享服务器日志？

2024/12/19 16:26:09	stderr	2024/12/19 08:26:09 ERROR server error method=/memos.api.v1.MemoService/ListMemoTags error="rpc error: code = Internal desc = failed to list memos"
2024/12/19 16:26:08	stderr	2024/12/19 08:26:08 ERROR server error method=/memos.api.v1.MemoService/ListMemos error="rpc error: code = Internal desc = failed to list memos: database disk image is malformed (11)"

[Issues-translate-bot]

Issue is not in English. It has been translated automatically.

---

Is it possible to share server logs when you try to view public notes?

2024/12/19 16:26:09	stderr	2024/12/19 08:26:09 ERROR server error method=/memos.api.v1.MemoService/ListMemoTags error="rpc error: code = Internal desc = failed to list memes"
2024/12/19 16:26:08	stderr	2024/12/19 08:26:08 ERROR server error method=/memos.api.v1.MemoService/ListMemos error="rpc error: code = Internal desc = failed to list memos: database disk image is malformed (11)"

[RoccoSmit]

Have a look at this article regarding SQL corruption errors.