timestamps of messages, but missing the message itself

[Jeradin]

Your script is really helpful! I was hoping to use it to find where the missing text is from past messages that show in my iMessage as "still typing" icon or just all the message timestamps displaying but no message text/body.

Have you seen this before?

[ReagentX]

For messages from a database this old, the content may be stored in a different way than current databases or be missing entirely. Can you post a screenshot of how Messages.app displays them?

[Jeradin]

Thanks for the swift reply and moving this to a discussion!

Here is how it looks in my messages app.

[ReagentX]

There is probably no data associated with the message body for those messages, but the rows still exist in the message table. Without seeing the rows it is difficult to say exactly what went wrong.

[Jeradin]

Thank you again @ReagentX for the support and replies. do you think it is worth me playing with the sqlite DB to try to find these missing messages or some other route?