senderJID null check needed about watoi

[residentsummer]

Hi, @CopyCat73 !

I'd like to take a look at the new structure of msgstore.db to figure out why remote_resource field is empty. Is it acceptable to ask you to send me an obfuscated copy of your file? If you're OK with that, please remove all sensitive data (see instructions below) and send it to (my github nickname)@gmail.com.

To mask all the text you could use the following commands (media type 0 is for text):

cp msgstore.db msgstore_obfuscated.db
sqlite3 msgstore_obfuscated.db 'update messages set data = "secret" where media_wa_type == 0'
sqlite3 msgstore_obfuscated.db 'update messages set media_caption = "secret" where media_caption != ""'

To check that text is indeed removed:

sqlite3 -header -column msgstore_obfuscated.db 'select * from messages where media_wa_type == 0 limit 10' |less -FRS

[bruno-motacardoso]

Hello,

I had the same problem. But fixing the script with your code/fix worked fine, thanks @CopyCat73.

Maybe it should be merged with the code @residentsummer ?