KnugiHK / WhatsApp-Chat-Exporter

A customizable Android and iOS/iPadOS WhatsApp database parser that will give you the history of your WhatsApp conversations in HTML and JSON. Android Backup Crypt12, Crypt14, Crypt15, and new schema supported.
https://wts.knugi.dev/
MIT License
518 stars 76 forks source link

Encrypted backup (iphone) sqlite3.OperationalError: no such table: Files #104

Closed Desideratum11 closed 5 days ago

Desideratum11 commented 5 days ago

Back up is encrypted and i followed instruction and installed

pip install git+https://github.com/KnugiHK/iphone_backup_decrypt

prior to running the extractor. Unsure if there are extra steps that i need to take in order to decrypt? Instruction on the decryptor werent too elaborate Untitled

KnugiHK commented 5 days ago

Hi. Is your specified path point to an iOS full backup?

Desideratum11 commented 5 days ago

Yes. I downloaded it from icloud on mac and transferred the entire folder over to my windows computer.

KnugiHK commented 5 days ago

What's your iOS version?

Desideratum11 commented 5 days ago

iOS 16.1.1

KnugiHK commented 5 days ago

Can you open the Manifest.db of the backup and post the database schema here?

Desideratum11 commented 5 days ago

the Manifest.db file shows at a 0kb empty database with tables, indices, views, and triggers all showing 0

Desideratum11 commented 5 days ago

the only unencrypted file in the backup itself (done about an hour ago) is Backup.plist but no .db file other than the empty manifest

KnugiHK commented 5 days ago

I guess there is no Manifest.db file in your downloaded backup and the file is actually created by the exporter.

I've never tried downloading a backup from iCloud, so there might be significant differences between iCloud backups and those created locally using iTunes or Finder. In simple terms, the exporter may not support iCloud-downloaded backups. I'm not entirely sure about this, but I may look into it later.

Desideratum11 commented 5 days ago

i figured as much haha. you can close this then. If i manage to back it up unencrypted do you think that would work?

KnugiHK commented 5 days ago

i figured as much haha. you can close this then. If i manage to back it up unencrypted do you think that would work?

The best way (and the expected way) to do it is by backing up your phone with macOS's Finder or iTunes on Windows. Encrypted or not should not matters as long as you do it with the mentioned tools.