So I've done some research to recover some messages, but the only answer ive gotten isnt helping entirely. Ive found the command, SELECT datetime (message.date / 1000000000 + strftime ("%s", "2001-01-01"), "unixepoch", "localtime") AS message_date, message.text, message.is_from_me, chat.chat_identifier
BUT, I don't need files from that folder. I need files from the chat folder itself. Not "chat_message_join"
I can see the phone number i want to view and everything in the browse data folder, but its the issue of reading the message content that i cant solve. Thank you anyone who can help.
Answer by
Swati Dubey
Unfortunately, the given information is not sufficient to provide a direct solution to your specific issue with recovering chats in DB Browser for SQLite. It seems like you have found a command that retrieves the necessary data, but now you are facing difficulties in reading the message content. It might be helpful to delve deeper into the command syntax or seek further assistance from the software's support community or forums.
So I've done some research to recover some messages, but the only answer ive gotten isnt helping entirely. Ive found the command,
SELECT datetime (message.date / 1000000000 + strftime ("%s", "2001-01-01"), "unixepoch", "localtime") AS message_date, message.text, message.is_from_me, chat.chat_identifier
BUT, I don't need files from that folder. I need files from the chat folder itself. Not "chat_message_join"
I can see the phone number i want to view and everything in the browse data folder, but its the issue of reading the message content that i cant solve. Thank you anyone who can help.
Unfortunately, the given information is not sufficient to provide a direct solution to your specific issue with recovering chats in DB Browser for SQLite. It seems like you have found a command that retrieves the necessary data, but now you are facing difficulties in reading the message content. It might be helpful to delve deeper into the command syntax or seek further assistance from the software's support community or forums.