升级部分数据丢失

[xwshan]

Describe the bug

1. 0.18.1版本升级到0.22.4，标签全部丢失。
2. 原来的热力图记录的天数，也无法在0.22.4上表现出来。
3. 另外，直接在以前的笔记上，点击评论报错，如下图😃 非常期待，下个版本可以关注一下，低版本的memos在升级过程中的问题😄

Steps to reproduce

1. v0.18.1 upgrade to v0.22.4

The version of Memos you're using.

v0.18.1

Screenshots or additional context

No response

[Issues-translate-bot]

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

---

Title: Partial data is lost during upgrade

[xwshan]

而且，多级标签也没有了，低版本且想升级的用户，慎重😄

[Issues-translate-bot]

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

---

Moreover, multi-level labels are no longer available. Users with lower version and want to upgrade should be careful😄

[abangfundi]

+1

[olin2011]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

[xwshan]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

[olin2011]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

备份没有备份评论的

[xwshan]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

备份没有备份评论的

我升级前，对数据进行了备份。所以可以，使用备份数据，继续使用旧版的memos 😄

[olin2011]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

备份没有备份评论的

我升级前，对数据进行了备份。所以可以，使用备份数据，继续使用旧版的memos 😄

没事，我的资料还在。主页查看评论是同样报错，但个人资料页能正常查看到评论数据。

[Issues-translate-bot]

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

---

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

It is recommended that you make a backup before upgrading. Use the backed up data for downgrade.

Backup There is no backup of comments

I backed up the data before upgrading. So yes, use the backup data and continue to use the old version of memos 😄

It's okay, my information is still there. The same error is reported when viewing comments on the homepage, but the comment data can be viewed normally on the personal profile page.

[xwshan]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

备份没有备份评论的

我升级前，对数据进行了备份。所以可以，使用备份数据，继续使用旧版的memos 😄

没事，我的资料还在。主页查看评论是同样报错，但个人资料页能正常查看到评论数据。

你可以试试，先编辑一下笔记，比如在笔记最后加一个空格，然后保存。再查看评论，应该就可以了 😄

[Issues-translate-bot]

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

---

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

It is recommended that you make a backup before upgrading. Use the backed up data for downgrade.

Backup There is no backup of comments

I backed up the data before upgrading. So yes, use the backup data and continue to use the old version of memos 😄

It's okay, my information is still there. The same error is reported when viewing comments on the homepage, but the comment data can be viewed normally on the personal profile page.

You can try to edit the note first, such as adding a space at the end of the note, and then save it. Check the comments again, it should be fine 😄

[abangfundi]

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

建议你升级之前，做好备份。使用备份的数据进行降级。

备份没有备份评论的

我升级前，对数据进行了备份。所以可以，使用备份数据，继续使用旧版的memos 😄

没事，我的资料还在。主页查看评论是同样报错，但个人资料页能正常查看到评论数据。

你可以试试，先编辑一下笔记，比如在笔记最后加一个空格，然后保存。再查看评论，应该就可以了 😄

这个是可行的，编辑后的变化，数据里的payload字段由 {} 变成了 {"property": {}}，hasLink 是 property 的一个属性，要批量更新的话，可以使用SQL执行

UPDATE public.memo 
SET payload = '{"property": {}}'
WHERE payload = '{}'

现在不报错了，不过还是感觉少了数据，所以备份好数据，谨慎更新

[Issues-translate-bot]

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

---

Upgrading from 0.20.1 to 0.22.4 with the same issue, and then rolling back to the 0.20.1 page will result in an error

It is recommended that you make a backup before upgrading. Use the backed up data for downgrade.

Backup There is no backup of comments

I backed up the data before upgrading. So yes, use the backup data and continue to use the old version of memos 😄

It's okay, my information is still there. The same error is reported when viewing comments on the homepage, but the comment data can be viewed normally on the personal profile page.

You can try to edit the note first, such as adding a space at the end of the note, and then save it. Check the comments again, it should be fine 😄

This is feasible. After editing, the payload field in the data has changed from {} to {"property": {}}. hasLink is an attribute of property, if you want to update it in batches. Can be executed using SQL

UPDATE public.memo
SET payload = '{"property": {}}'
WHERE payload = '{}'

No errors are reported now, but I still feel that there is a lack of data, so back up the data and update carefully.