andreas-mausch / whatsapp-viewer

Small tool to display chats from the Android msgstore.db database (crypt12)
https://andreas-mausch.de/whatsapp-viewer/
MIT License
1.23k stars 381 forks source link

Viewer doesn't show messages on Wine #100

Open ectatomma opened 3 years ago

ectatomma commented 3 years ago

Hi! I'm trying to run the program on Wine. It loads the chat list without problems, however the right pane doesn't show the messages. I have read on issues #66 and #76 that is runs fine on Wine, so I'm wondering what Wine version and configuration you're using. I'm using an IBM Thinkpad X230 Core i5, Integrated 3rd Gen Intel graphics, Ubuntu 18.04, Playonlinux 4.3.4 and so far I tried Wine 4.11, 3.12 and 2,19.

b00bob commented 3 years ago

Hi ectatomma, I just tried it out on my machine with Wine 5.9 and PlayOnLinux 4.3.4 running and I see my messages on the right pane. You probably need the latest wine version.

ectatomma commented 3 years ago

Hi b00bob, I decided to install a virtual machine with Windows 7 and the issue persisted, so I ran a database recovery with sqlite3 msgstore.db ".recover" | msgstore_recovered.db and it found several errors in the database:

Error: near line 337166: UNIQUE constraint failed: message_ftsv2_segdir.rowid Error: near line 337172: UNIQUE constraint failed: message_ftsv2_segdir.rowid Error: near line 337173: UNIQUE constraint failed: message_ftsv2_segdir.rowid Error: near line 337178: UNIQUE constraint failed: message_ftsv2_segdir.level, message_ftsv2_segdir.idx Error: near line 337179: UNIQUE constraint failed: message_ftsv2_segdir.level, message_ftsv2_segdir.idx Error: near line 362456: UNIQUE constraint failed: messages.key_remote_jid, messages.key_from_me, messages.key_id

The recovered database worked fine on the VM, however on my Playonlinux 4.3.4, Wine 5.9 or Wine 5.11, it shows this error message:

loadimage() failed: could not create decoder imagen

andreas-mausch commented 3 years ago

Hi, I just did a test with my wine version wine-5.16 on Manjaro and images are displayed.

WhatsApp Viewer uses Windows Imaging Component to decode images.

Maybe winetricks windowscodecs helps? (Found here: https://askubuntu.com/questions/228049/how-can-i-install-windowscodecs-using-wine-1-5-19)