yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] zeekabal:
not able to install pycrypto

Dears,

I am getting this error whenever I try to install pycrypto.bat, what could be the reason?

C:\Users\Elbaba\Desktop\Whatsapp_Xtract_V2.1_2012-05-10-2>rem If you want to dec

rypt android whatsapp msgtore.db.crypt files, then you need to run this (after i

nstalling ActivePython)

C:\Users\Elbaba\Desktop\Whatsapp_Xtract_V2.1_2012-05-10-2>"C:\Program Files (x86

)\Python32\Scripts\pypm" install pycrypto

Expanding "%APPDATA%\Python\Scripts" in user's %PATH%; please launch a new Comma

nd Window

Thanks,
[Android Apps and Games] ztedd:
Whatsapp_Xtract_V2.1_2012-05-10-2 isn't the latest version. Please download the latest version from the first page and try it again with that.
[Android Apps and Games] ztedd:
regarding deleted messages, everything I said in the posting on the previous page still is the latest status:
[Android Apps and Games] ztedd:
Where would you want to import it afterwards?
[Android Apps and Games] NillyD:
I am getting this response:

Is there a step I've done incorrectly?

Help would be very appreciated!
[Android Apps and Games] ztedd:
maybe the files weren't copied correctly. Maybe you should try again to copy the files from the SD card, e.g. using a different way (maybe ejecting SD card and inserting it in an SD card reader instead of mounting the phone to the PC).

You may also try to open the msgstore.plain.db with some SQLite Editor or SQLite repair tool (please google that).
[Android Apps and Games] ofmb:
Convert whatsapp to sms xml

Did anyone already wrote a script to Convert whatsapp to sms xml?

That'll be awesome. Just think how well SwiftKey can learn your testing :-D
[Android Apps and Games] MariaT:
Issue in "!install pyCrypto.bat"

Hi,

I tried to follow the steps to run the command "!install pyCrypto.bat" from the command prompt after running "whatsapp_xtract_console". But I am getting the following error message:

"C:\Users\Maria Thomas\Whatsapp>"C:\Python27\Scripts\pypm" install pycrypto

error: Failed to download <%s>. Reason: <urlopen error [Errno 11004] getaddrinfo failed>"

I am not sure how to proceed after this. I had copied the Python as mentioned for Windows(x86).

I am unable to post the url since I am a new user. I have attached the screenshot of my cmd window.

Thanks in advance
[Android Apps and Games] ztedd:
Looks like you have some firewall that blocks the internet access to the pycrypto install script command window. You should allow the internet access for it.
[Android Apps and Games] ztedd:
No, I don't think so, but I add it to the Feature Requests.
[Android Apps and Games] dhiraj228:
i think whatsapp has changed its encryption

hi

i am getting this error now before evrything was working fine

C:\Users\dk\Downloads\Whatsapp_Xtract_V2.1_2012-05-16>python "C:\Users\dk\Downlo

ads\Whatsapp_Xtract_V2.1_2012-05-16\whatsapp_xtract.py" C:\Users\dk\Downloads\Wh

atsapp_Xtract_V2.1_2012-05-16\msgstorle.db.crypt

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Error during decrypting: Input strings must be a multiple of 16 in length

Could not decrypt database file. Guess it's not a valid Android/Iphone database

file or Whatsapp changed the encryption.

Press any key to continue . . .
[Android Apps and Games] ztedd:
Do you get this error only with that particular msgstore.db.crypt file, but not with others?
[Android Apps and Games] Mustaaa:
Hmm thanks for this, was looking for it.

But it won't display the messages?

I get this:

Do I need to wait? This is with both, msgstore.db.crypt and msgstore.db and wa.db.

What can I do to fix this?
[Android Apps and Games] koenster:
Hi all!

Can I convert the .HTML files to the Crypted DB files again?

Hope somebody can awnser! :D
[Android Apps and Games] Mustaaa:
Hmm my problem is fixed. I just opened the HTML file with Chrome. Thanx
[Android Apps and Games] ztedd:
No, there isn't such a function. Why would you need that?
[Android Apps and Games] Salomonisch:
I also have this problem, all db's since yesterday or the day before react with this "Error Message", older db's still works fine...

And yes i copied at least ten times each db and tried it again and again... But no change...

Please help me and the other ones... Thanks in advance! :)
[Android Apps and Games] redlag:
Hey, I am running Windows XP and getting the following error. Any idea?

M:\New Folder (8)>rem If you want to decrypt android whatsapp msgtore.db.crypt f

iles, then you need to run this (after installing ActivePython). If you get erro

rs then try to do this: rightclick on this !install pyCrypto.bat and choose "run

as administrator"!

M:\New Folder (8)>"C:\Program Files\Python27\Scripts\pypm" install pycrypto

skipping "pycrypto"; already installed at "%APPDATA%\Python" (2.7)

M:\New Folder (8)>"C:\Program Files\Python27\Scripts\pypm" show pycrypto

Name: pycrypto

Latest version: 2.5

Author: Dwayne C. Litzenberger <dlitz@dlitz.net>

Summary: Cryptographic modules for Python.

Home Page: http://www.pycrypto.org/

Available versions: 2.5, 2.4.1, 2.4, 2.3, 2.2, 2.1.0, 2.0.1

Status: Already installed (2.5) at "%APPDATA%\Python" (2.7)

M:\New Folder (8)>setx pythonpath "C:\Program Files\Python27"

'setx' is not recognized as an internal or external command,

operable program or batch file.

M:\New Folder (8)>SetEnv -a pythonpath "C:\Program Files\Python27"

_

Press any key to continue . . .

Edit : Already solved! :)
[Android Apps and Games] koenster:
Because I want to merge 2 whatsapp chat history's with eachother. I can edit the conversations in the .HTML file, but not in the .DB file...

Thats why ;)
[Android Apps and Games] ztedd:
Merging of chat database files is already on the feature requests list.
[Android Apps and Games] ztedd:
Then maybe the answer is exactly what is described inside the error message:

Which version of Whatsapp on Android do you use?
[Android Apps and Games] Salomonisch:
I use the WhatsApp Version 2.7.9946

A friend of mine has the same problem since update...

Still thanks in advance :)
[Android Apps and Games] dhiraj228:
all db after 26 are having this problem guess whatsapp has released a new update and it got updated
[Android Apps and Games] tejasdave:
Thanks...was looking for this.
[Android Apps and Games] ztedd:
I just tried the newest version 2.8.529 and it still works fine. I have no idea what's the problem. If you like you can send me a sample database file that doesn't work and I'll have a look on it. Just contact me by private message.
[Android Apps and Games] Marvi70:
hi ztedd,

I am using your tool since a few weeks, and it's awesome! thanks for this.

Do you know if it's possible to merge the db-files into one with all messages?

e.g. I have 7 backup files, i deleted some messages every day, and now I want to have an overview of all messages over these last 7 days.

I saw that every message have an ID defined as primary key in the DB-file. But with my knowledge of sqlite it was not possible for me to get the desired result ;)

thanks for your support
[Android Apps and Games] MeTa Apps:
Thanks! :)
[Android Apps and Games] nobotics:
Buisiness edition

Hello,

I´am new here. Sorry for my bad englisch but i´m a german boy and my school time are many years ago.

I have a problem to encrypt my backup from an android-system. I install Python but when i klick/ want to install !install pyCrypto.bat DOS said to me:

This package requieres a valid Buisness Edition please visit www_activestat..........

Status: not installed

I have installed Python 2.7. I don´t know what i should do or what I forget. Please help me if anybody know what I should do, thx

nobotics
[Android Apps and Games] ztedd:
Auf gut deutsch: 32bit/x86 version von ActivePython installieren, NICHT die 64bit-Version!
[Android Apps and Games] manolitoohara:
Undelete whatapp chats

Hello.

Is there any tool to undelete whatapp chats?

Can add this feature to your program?

Thanks.
[Android Apps and Games] ztedd:
What do you want? Can you describe in more detail, please?
[Android Apps and Games] seeto84:
Hi all, is there no any methods for restoring backup for Blackberry?

I have visited this website every single day & hope i can restore the important message history.

:(
[Android Apps and Games] N-ever:
sir can i convert sqlite file to db.crypt file so that i can read my iphone wtsapp record in my android phone? many thanks
[Android Apps and Games] manolitoohara:
I have delete some important conversation and I want to undelete it and read it again.
[Android Apps and Games] Pimped.UK:
Hi,

Thanks to the OP for releasing this invaluable tool. I understand that merging chat histories is on the feature request list, but I have a slightly different request; I'd like to me able to import a backup into my current conversations in whatsapp or merge one or more db.crypt files together so that I can import them all into whatsapp.

I had a lot of conversations in my backup, but instead of importing them, my whatsapp received 613 new messages so I don't have any of my old conversations. I can import them, but then I lose my current conversations and vice versa.

I'm willing to play around with code if it helps. My speciality is SQL, ASP, Java (not as good at it anymore, but can pick it up fairly quickly)
[Android Apps and Games] ztedd:
On Android, whatsapp creates backups every day at /sdcard/WhatsApp/Databases. Just take a backup that was created before you deleted the chat. Note that only backups of the last seven days are stored.

Maybe you can use an undelete / file recovery tool to find older deleted backups on the SD card.
[Android Apps and Games] ztedd:
No, that's not possible yet. It's still on the feature requests list.
[Android Apps and Games] ztedd:
You can try the following:

1. Create a new backup (menu Button - Settings - Chat Settings - Backup Chat history)

2. Force-Close Whatsapp so that it won't receive any new messages.

3. now you should have two .db.crypt files, the older one with all your backupped chats and the newer one with ~ 613+ messages. Use Whatsapp Xtract to convert the .db.crypt files to .htm and unencrypted .db files

4. Now use the tool SQLite Compare (see howto) to merge the two .db files into one

5. Now copy the merged .db file as "msgstore.db" into the folder /sdcard/WhatsApp/Databases and make sure that there isn't any other file there (copy the other files in another folder)

6. uninstall whatsapp, install whatsapp and choose yes when asked to import the backup

If you want to include the merging function into the code of Whatsapp Xtract, you should have a look at the SQLite commands of Python. It's quite similar to SQL. Until someone has done this, you can use the mentioned tool SQLite Compare, though it's a bit difficult to use.
[Android Apps and Games] ztedd:
No, apparently there isn't. We haven't figured out yet how to copy the unencrypted database files from a Blackberry device.

Since I don't own a Blackberry, I can't try it myself, so I have to rely on the community to find out if and how the unencrypted database files can be copied (using your known Blackberry encryption key).
[Android Apps and Games] Pimped.UK:
Thanks, that sounds simple enough! From what I was reading around on this thread, would I need to have root access to my phone? It seems that I don't need to root my phone from your reply.

I'm gonna get cracking on with this and let you know how I get on. Hope it works =D =D

---------- Post added at 05:48 PM ---------- Previous post was at 05:22 PM ----------

I tried and got up to the part of extracting using the tool and got the following error:

I noticed when I used !install pyCrypto.bat, I got the following output with errors:

EDIT: Can't seem to reply so posting as an edit.

I'm sorry, I skim read that part so it just looked like as though you said choose 32bit/64bit, should have paid more attention....my bad!

Will get back on it tonight :)
[Android Apps and Games] ztedd:
Yes, you don't need root access.

****ing damn it, I don't know how often I answered this question in the last weeks, I even highlighted the following advice in red on the main page:

What more could I do to make this even clearer??
[Android Apps and Games] Willem Anders:
Hi there,

A few days ago I left a message on the forum about reading Whatsappfiles on your computer.

Well... I found a great site myself (after a few weeks searching and trying and searching).

And... it works!

So to help other people, here is the site:

http://www2.unsec.net/whatsapp/

Succes!
[Android Apps and Games] ztedd:
Thanks. But you can also use our Whatsapp Xtract tool, I think it's even cooler :D

For example it displays the smileys :)
[Android Apps and Games] mayankchopra:
32 bit version worked

guys those who get media import failed error try 32bit version of activepython it worked for me
[Android Apps and Games] aawadhi63:
DB history

I have the same issue with my Blackbery! as I bought a new Bb, I wanted to read the old whatsApp msgs as they contain some numbers I require but hoplessly trying with no success. can someone assit please!!!
[Android Apps and Games] ztedd:
You already quoted the answer:
[Android Apps and Games] Guariboa:
I was doing all steps... then i readed "Not supported for blackberry"

Well i need to read some conversation i have because Im in personal problems. I have some evidence there that can help me a lot.

If you need a donation tell me.. But i need that for blackberry

Please and thanks...
[Android Apps and Games] akeedthe:
bloody brilliant!!!! works flawlessly. only hitch was python HAD to be installed to program files instead of default.

thanks :)
[Android Apps and Games] sun_man:
this is an absolute awesome tool - thank dude, works perfectly..... and i agree the online tool is good but this is better.....
[Android Apps and Games] GermainZ:
Cool. I used SQLite editor till now to read messages without the sender knowing, but this seems like a better alternative when my phone is charging.
[Android Apps and Games] CJCord:
"Abort due to constraint violation

column key_remote.jid is not unique"

this is an error when i triy to copy right db to left db in "table chat_list"

in messages everything is fine, and in the output file i can see that there has been an conversation but (i think so) due to not copied chat_list there is no conversation-text

can i just change the IDs of the chat-list entries?

€: corrected some important typos

€2: tried copying from left to right instea of right to left. that works....in a way. now i the older conversations under the newer, but the timestamp is correct O.o *dafuq?!*
[Android Apps and Games] AlaitzZabala:
It does not work for me

I don't know what the application it is not working for me...

I use the following command line: "python whatsapp_xtract.py msgstore.db.crypt", and the messages I obtain are:

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

decrypted database written to msgstore.plain.db

trying to repair decrypted android database...

Could not open database file. Guess it's not a valid Android or Iphone database

file.
​

In fact the "msgstore.plain.db" it is not created at all...

What I'm doing wrong??

Thank you so much!!

Alaitz
[Android Apps and Games] Guariboa:
Just waiting...

Im impatient waiting to the Blackberry reader :( just that ... I need it...

I i have to donate tell me... is importat and urgent
[Android Apps and Games] Antonine:
Wow, this looks great :)

My only problem with it was that I was doing research for a personal project to write an app to do the exact same thing - so finding this means I'll have to think up a new project for myself :p
[Android Apps and Games] lost_:
Thanks for the tool to get the plain db. I was able to merge/combine 3 plain databases from 3 different Android phones by fixing the _id in the messages table of the second database and fixing the chat table to point to the latest relevant messages for contact chats that existed in both. One would need to know SQL to do this.
[Android Apps and Games] CJCord:
is there a tool, that makes this a bit easier?

i still have my 2 DBs that wont fit into eachother :(
[Android Apps and Games] lost_:
Not that I know of. I had 3 different databases because I switched phones during my summer travel without first making a backup before switching. I had to get the db.crypt files into my laptop, convert them into plain using the tool in the OP, then merged them by modifying _id in message tables and updating the chat_list.

I got FCs when viewing one particular thread, and it took me several trials and errors until I narrowed it down to SQL Compare not copying thumbnail blobs properly. So, I used the database that had the blob as the base, merged the other two into it, thus avoiding blob-copying. I'm sure this was possible to get around with other sql tools.

So, the final result was 3 databases merged into one, no FC when imported back to WhatsApp and chat list showing the correct last message of each. I'm just glad that my chat list isn't that big yet because I was updating it with manual SQL. It could have been done with more complex SQL join involving chat and messages tables, but luckily I didn't have that long a chat list.
[Android Apps and Games] dwg84:
Help Please

Hi I am having a problem when I open up the backup in a browser it says there is no messages, but when I open the back up in notepad I can see and read the messages, where have I gone wrong? thanks
[Android Apps and Games] dzay:
Problem

I have the same database in 2 versions(one today, one from yesterday) ChatStorage.sql.

At the one from yesterday it produces the html file but when I open it there's no message shown, at the one from 2day it sais "

C:\Users\d2ay\Desktop\Whatsapp_Xtract_V2.1_2012-05-16(1)>python whatsapp_xtract.

py ChatStorage.sqlite

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Error during decrypting: Input strings must be a multiple of 16 in length

Could not decrypt database file. Guess it's not a valid Android/Iphone database

file or Whatsapp changed the encryption.

C:\Users\d2ay\Desktop\Whatsapp_Xtract_V2.1_2012-05-16(1)>pause

Press any key to continue . . ."

if I open both of them with notepad I can see the messages, barely but they're there.

any advice?
[Android Apps and Games] kairyudo:
Completely lost please help

Hello - I'm sorry cuz this is a really basic problem but I just can't figure it out. Mine is an iphone and I can't find my whatsapp DB. i've downloaded iphone backup as well as i-twin and I just can't figure out how in the world do you find the net.whatsapp folder? on iphone backup, it shows 2 folders with a series of numbers and letters and when i open them, there are many more similiarly named files which i can't open. I've tried reading through posts to see if someone faced what I have but I think everyone's passed the stage i'm at. I'd REALLY appreciate help. I'm very tech/computer challenged. Thank you!
[Android Apps and Games] kairyudo:
figured it out

sorry for posting again - just to say i figured it out and it worked thank you to the creators!! one last question - the html page will be there forever right? there's not way it expires or anything? or should i figure out another way to save it like in Microsoft Word? I only ask cuz it's a huge file and saving it to Word be tiresome but I'd do it if there was a risk of losing the html in the future...
[Android Apps and Games] vantex:
Just One Question

thanks for the program, it works perfectly!

just a question though, at the report generated, I suppose the PK number in the first column is the Message sequence number? therefore message deleted before the backup it will become missing PK number, as the messages should follow the PK sequence and not jumping around?
[Android Apps and Games] shadowmorning:
ok i did all the steps, copied whatsapp extractor to C drive, then downloaded python 64 bit version, installed it then moved on to running the bat file that installs the python plugin. suddenly i realized that i must install python 32bit version! so i UNinstalled python 64 and installed python 32 at windows x86 directory. then i copied the database to the whatsapp extractor directory....and ran the .bat scipts. tried all 3 of them. nothing happens. the message reads smthg like this,,,

C:\Whatsapp_Xtract_V2.1_2012-05-10-2>python whatsapp_xtract.py msgstore.db -w wa

.db

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

decrypted database written to msgstore.db.plain.db

trying to repair decrypted android database...

Could not open database file. Guess it's not a valid Android or Iphone database

file.

C:\Whatsapp_Xtract_V2.1_2012-05-10-2>pause

Press any key to continue . . .

now what guys?
[Android Apps and Games] Qwerty123 \m/:
Anyhelp with this error ?
[Android Apps and Games] ztedd:
You didn't install the PyCrypto library. See step 4. in the howto on page 1.

run !install pyCrypto.bat (contained in this archive. The best is to rightclick on it and choose "run as administrator".)
[Android Apps and Games] ztedd:
Could not open database file. Guess it's not a valid Android or Iphone database file.

Which input file did you use?

Generally, you can take the error message as provided:

Your database file seems just not to be a valid, uncorrupted database file!

And as answered an estimated 100 times before, have a look at the "additional information" posting on the first page:

If you can't open the (unencrypted) database with SQLite Database Browser, then Whatsapp Xtract won't be able to open it as well. (You may also try to repair it as described in the "IF DATABASE CAN'T BE OPENED: REPAIR DATABASE" section).

Then maybe the file wasn't copied correctly, has some kind of CRC error, etc... You only can try to create a new whatsapp backup (In Whatsapp go to settings - more - Backup Chats), copy it again using a different method (e.g. ejecting the microSD card and mounting it directly in your PC, etc.) and try again.

Maybe Whatsapp will change the structure of the database one day. Then older database files would work but newer wouldn't.

These are all possible explications I can give. Now you have to try what's up with your file. You also may send me a personal message or mail and send me your database file so I could check what's up ;) .
[Android Apps and Games] ztedd:
Yes, it should be numbered like you assumed.
[Android Apps and Games] ztedd:
If you don't delete the HTML page or overwrite it by running Whatsapp Xtract a second time with a similar named input file, then it will stay the same. I suggest to copy a backup of the HTML page to a different folder on your computer.
[Android Apps and Games] ztedd:
Do you have Android or Iphone version? Which input file (database) did you use? Which version of Whatsapp do you have? Does it work with older backups?

We need more information to help you.
[Android Apps and Games] ztedd:
Although you provided an Iphone database, Whatsapp Xtract assumed it is an Android file because it couldn't open the Iphone database file. The script tries the following command:

c1.execute("SELECT * FROM ZWACHATSESSION")

If it doesn't work, then it can't open the Iphone database file. Maybe you have a newer version of Whatsapp on Iphone, where the structure of the database was changed.

Please use the tool SQLite Database Browser to check the database structure of your ChatStorage.sqlite file as explained in the "additional information" posting on the first page:

If your ChatStorage.sqlite doesn't contain a table ZWACHATSESSION, then Whatsapp changed the database structure and we would need to update Whatsapp Xtract. For that, we need a sample database file ChatStorage.sqlite. Maybe you could send us a ChatStorage.sqlite file.

Please contact me by sending a personal message.