WhatsApp-Chat-Exporter: Problem with Senders' names null in some chats only

Hello, thank you for your lifesaver software 😃

Using Android on Google Pixel 2 XL

I’ve been able to extract all my wa databases with your extractor software. Also the exporter works without any problem.

Nonetheless some exported html chats have all their senders’s name with the name of the chat, and by debugging I could see that msg.sender is null.

I can’t figure out why this happens with only some chats

Those chats, and only those, have a filename number-name where number is starting by 120363

The groups that are working all have their filename without the number part in their exported html files.

In the ‘messages’ function in ..../Whatsapp_Chat/WhatsApp-Chat-Exporter/venv/lib/python3.11/site-packages/Whatsapp_Chat_Exporter/extract.py the c.execute() call happens in the sqlite3.OperationalError block.

I wander if there’s a mistake in the code being that wa reports all the senders correctly

I would love to solve this (it’s urgent because wa is clogging my cell completely) I’m able to understand the ‘jid jid_group’ part in the line 263 of extract.py.

'LEFT JOIN jid jid_group
                            ON jid_group._id = message.sender_jid_row_id'

only intuitively. I guess is accepting the first of the two matching field that is not null. I couldn’t find documentation for that syntax with two field names.

Also the senders’ avatars are not present, I would love to have them, but that’s of course much less important, and probably for a separate question.

Thanks for any help

About this issue

Original URL
State: closed
Created 9 months ago
Comments: 20 (9 by maintainers)

Commits related to this issue

An attempt to fix #67 — committed to KnugiHK/WhatsApp-Chat-Exporter by KnugiHK 8 months ago
Bug fix on missing sender in group chats #67 — committed to KnugiHK/WhatsApp-Chat-Exporter by KnugiHK 8 months ago

Most upvoted comments

Is it possible to have a contacts export including the name an phone number of all contacts in a single html file?

@txanetxarra Is feature no.3 mentioned in #69 similar to what you are asking for?

@KnugiHK,

Ok, glad to see that my suggestions are already being considered.

I’ll be willing to try with the release.

Best regards 😉👍.

txanetxarra on Oct 29, 2023

Definitely all PM chats are working right. 😃

marcello-pietrobon on Oct 10, 2023

@KnugiHK Thanks again for your effort… Your software is great! 😀🎆

Lehnemann on Oct 31, 2023

Hi everyone. Commit 7da71e8 should fixed the problem. Feel free to try it in dev branch.

KnugiHK on Oct 29, 2023

The same is happening with me… on Android 13.

I hope this coming week to be able to find the time to fix it, or at least to test KnugiHK’s explanation.

marcello-pietrobon on Oct 20, 2023

I suspected that the jid of the group does not contain a dash, in which group chats are assumed to have one, and therefore sender is not populated

That’s great. I looked at the code and I see this pattern recurring in many places, so I guess I’ll wait for your fix. The only thing maybe is to know if you’ll be able to fix it this month or not, otherwise I may consider to fix it myself and open a PR for that.

It is available for iOS. Android support will need to be added.

I looked into the folder Media/WhatsApp Profile Photos/ and it appears empty… maybe the files are hidden or placed somewhere else? I wander if a simple hint could lead me to a quick fix. But again, this is way less important for me. (or I can open a separate thread for it, svp let me know).

Thank you so much for your prompt replies, very very helpful for me.

Best, Marcello

marcello-pietrobon on Oct 10, 2023