no such table: legacy_available_messages_view

[jskswamy]

When trying to import, with the latest version of WhatsApp, I'm getting the following error

2022-04-24 23:34:15.603 watoi[61850:16744452] Loaded 313 chat(s)
2022-04-24 23:34:15.604 watoi[61850:16744452] no such table: legacy_available_messages_view
fish: Job 1, 'watoi/build/Release/watoi msgst…' terminated by signal SIGABRT (Abort)

[2Sea-cat]

I also got this problem. I checked relevant issues, maybe WhatsApp did change the database tables. The last commit that changed that legacy_available_messages_view, was 5 months ago, with the introduction to ephemeral messages. That was and obvious addition, right now there seems to be not major changes.

However I found out the help wanted tagged issue#51. Seems like they still do not have it working completely. Gonna try to replicate their sql changes and let you know.

[2Sea-cat]

I forgot to reply, I'm so sorry. Yes, if you add the view to your msgstr.db you will get the script to work and migrate the chats. You can get it done with something that can open sqlite databases and then adding the code in the link I provided the other day.