yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] Blinkin89:
Aah well that's at least something.

Problem is that we can't created .db.crypt files or convert the normal .db to a crypted version.

At least as far as my knowledge goes (I'm just a user of this just like you not a dev).

And you're right about the size, 1kb means it's corrupted.

There's one thing you could try (only if your phone is rooted) but it's something I've jhad bad experiences with. But I'm not sure if I did something wrong or that the method isn't going to work anyway...

You could try to copy the plan db file (the one you want to be a crypted) to the dat folder of android (which is in the root) and then again data and then in the databases folder of the whatsapp folder.

So in easy words the location to copy the msgstore.db file to is: (root) > data > data > com.whatsapp > databases

But again, I'm not sure if whatsapp will accept this. So I can recommend you to backup whatsapp first before even trying this. ;)
[Android Apps and Games] Lctwisk:
repaired database

Hi guys,

Got a corrupted msgstore.db.crypt but I repaired it, and now I've got a working msgstore.db. The problem is that I need a encrypted database file to get my conversations back in whatsapp. How can I encrypt my database file again?

Thanks in advance !
[Android Apps and Games] djuve:
Here the same problem!

Convert it by whatsappmigrigator to a crypted file, but whatsapp don't get the conversations back from the backup.
[Android Apps and Games] djuve:
I tried to find this to copy the file in the root. But i can't find it. The root/data/ is empty.

What would i do now??
[Android Apps and Games] Blinkin89:
I already (kinda) answered this question a few pages ago.

Are you sure? Your device has to be rooted. Use a explorer app that can use root structures like root explorer.

If you go to the highest level of the folder structure (called the root) you'll see folders like 'acct', 'bin', 'data', 'sd', and lots more.

There you need to go into the data folder and then another data folder. It's impossible that it's empty. That would mean non of your app exist nor work.
[Android Apps and Games] BlinkyBlonky:
Help needed

Hi,

first of all thanks for this tool. Sadly i have some trouble getting it to work.

I have read nearly all post and it seems that are several people with my kind of problem, but even after trying out the posted solutions, i still have the same trouble.

So any help is highly appreciated. Here is the description:

I have installed ActivePython 2.7.2.5 and installed the pycrypto-2.6.win32-py2.7 into c:/python27

I have downloaded serveral version of Whatsapp Xtract (2.1, 2.2, 2.51)

When i try to decrypt my msgstore.db.crypt i still get follollowing error:

D:\Down\Software\wa>python whatsapp_xtract.py msgstore.db.crypt

Python Version 2.x

Detected non-SQLite database, potentially an encrypted Android database

Trying to decrypt Android database...

Traceback (most recent call last):

File "whatsapp_xtract.py", line 2740, in <module>

main(sys.argv[1:])

File "whatsapp_xtract.py", line 1442, in main

decoded = cipher.decrypt(open(options.infile,"rb").read())

ValueError: Input strings must be a multiple of 16 in length

I am not able to solve this, tried with different Python/pycrypto combinations.

Please advise, what am i doing wrong ?

Thank you very much.
[Android Apps and Games] BlinkyBlonky:
Or maybe you could state where i can get the matching ActivePython for the included libraries in 2.51, as they are not downloadable anymore form the provider site.

Please help me to get this working.

Thanks.
[Android Apps and Games] Tr1gun:
question...

today i backup the whatsapp msg i get the crypt and save it

after that i delete all the msg wait a few days and make another backup crypt...

i can merge the 2 db for have the extracted text with both of db?
[Android Apps and Games] Alex8und8:
#9248: database disk image is malformed

Hi,

I followed all steps of the guide but it wont work for me. I got the error that the database disk image is malformed.

C:\Users\Alex\Desktop\Whatssapp Extract\Whatsapp_Xtract_V2.2_2012-11-17>python w

hatsapp_xtract.py msgstore.db.crypt

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

decrypted database written to msgstore.plain.db

Error sqlite3.Error while reading chat #9248: database disk image is malformed

C:\Users\Alex\Desktop\Whatssapp Extract\Whatsapp_Xtract_V2.2_2012-11-17>pause

Drücken Sie eine beliebige Taste . . .

i also tried this then:

- start whatsapp_xtract_console.bat and then type:

- echo .dump | sqlite3.exe msgstore.plain.db > Temp.sql

- echo .quit | sqlite3.exe -init Temp.sql msgstore_new.db

- python whatsapp_xtract.py msgstore_new.db

but it also wont help.
[Android Apps and Games] Blinkin89:
Aah so They don't provide that version anymore?

I didn't knew that.

Glad I still have ActivePython-2.7.2.5-win32-x86 on my HDD.

Here you go. ^^

https://dl.dropboxusercontent.com/u/2980851/ActivePython-2.7.2.5-win32-x86.msi

Yes you can. The instructions are on the first page in the third post. You've to use sql tools.

I've done this myself and found it a bit hard to use the first time, but practise helped a lot and some problems have been explained in this topic already. Which is nice.

I'm not sure but did you used whatsapp xtract version 2.51 or above?

Else you might try opening the db with a sql tool (see first page third post) and locate chat #9248 by yourself and see if there's something wrong.

Or delete it and save the db, maybe it helps. Good luck!
[Android Apps and Games] Tr1gun:
umm i think i'll make a small program for merge 2 db ^^
[Android Apps and Games] Blinkin89:
That would be very nice.
[Android Apps and Games] vasanth_devil:
help me out..please

Am getting this issue when i try to open a backup DB renamed.

C:\watsapp>python "C:\watsapp\whatsapp_xtract.py" C:\watsapp\msgstore.db

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

decrypted database written to C:\watsapp\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.

i tried some techniques in this thread. bt nothing worked out

please provide an solution plzzzzz

thanks in advance

---------- Post added at 06:11 AM ---------- Previous post was at 05:36 AM ----------

getting an error:

C:\watsapp>python whatsapp_xtract.py msgstore.db -w wa.db

Python Version 2.x

Detected non-SQLite database, potentially an encrypted Android database

Trying to decrypt Android database...

Decrypted file written to msgstore.db.plain.db

Error: File is not an encrypted Android database

C:\watsapp>pause

how to rectify these?
[Android Apps and Games] thijs_v:
Problems with WhatsApp after merge 2 db files

Hello,

I have merge the db files of 2 old phones. One I have justed till 10th of June and the other from the 10th of June till now.

Because I have an new phone I have merged the two db files.

Finally I did manage to merge the files and get WhatsApp running. WhatsApp did recover my chats (about 40.000). But when I go back to the 10th of June or earlier in my chats WhatsApp closes every time. But It doesn't happen at all the chats.

I think WhatsApp has a problem with locating the media, but all the images are located in the Media directory under WhatsApp Images.

Does anyone have an idea what is causing the force close downs?
[Android Apps and Games] XplodFire:
C:\Whatsapp>python whatsapp_xtract.py msgstore.db.crypt

Python Version 2.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Traceback (most recent call last):

File "whatsapp_xtract.py", line 2453, in <module>

main(sys.argv[1:])

File "whatsapp_xtract.py", line 1371, in main

from Crypto.Cipher import AES

ImportError: No module named Crypto.Cipher

C:\Whatsapp>pause

Press any key to continue . . .

PLEASE HELP NEEDED

I DOWNLOADED THE PYCRYPTO LIBRARY ALSO BUT I AM STILL GETTING THIS ERROR
[Android Apps and Games] djuve:
Yes i ma sure the phone is rooted. I see the Maps acct, sdcards, systeem, vendor, sbin and config.
[Android Apps and Games] SunnyGrewal11:
can v edit messages n put em back ?

hey .. i just did everything u wrote n it worked as well ... but main question i got here is that can i edit the messages n then put em back into my fone ??

its vry vry imp for me so if its not possible then can u tell any way for that ?
[Android Apps and Games] edgeball:
pretty much same here, I was able to get my group chat back of which I am the owner, but I can't open it..
[Android Apps and Games] Snapy1991:
Whatsapp backup has issues

Hello guys,

i have done the steps like in the first page and now i got this message in the DOS window when i started whatsapp_xtract_android_crypted.bat file:

Detected non-SQLite database, potentially an encrypted Android database

Trying to decrypt Android database...

Decrypted file written to msgstore.plain.db

Succes! Decrypted file is an SQLite databse

Android mode!

Checking Android database integrity...

Android database has integrity issues. Attempting to fi it...

Error: near line 27020: cannot commit-no transaction is active

Android database has been succesfully repaired and has no integrity issues

Generating log files...

Than he generated the conversations as html.files.

My original file is msgstore.db.crypt and its size is 5,31 MB

after the process i got following files:

msgstore.plain.db 5,31MB

msgstore.plain.db.repaired.db 3,74MB

msgstore.plain.db.repaired.sql 6,3MB

msgstore.plain.db.sql 6,3MB

My question now is which new generated file do i have to copy to my phone so that Whatsapp can restore the conversations correctly?Do i have to rename the files or something like that?

Thank you for your help
[Android Apps and Games] theobservers:
the .crypt file cannot be read by my phone

Sorry to bother you .

But I've a question that after I've successfully repair the corrupted msgstore.db.crypt file

I can read the conversations stored with my computer (which means it actually has contents in it)

Then the repaired file is named msgstore.plain.db.repaired.db which is not encrypted

and I use the WhatsAppMigrator to turn it into a .crypt type file.

The problem is that my phone cannot read the .crypt file , I can see the people once I chatted with , but the chats are empty

( just like the one having the same question a few pages before )

And I've looked backward to find the solution , but it seems that I need my phone rooted to finish this problem

But i wonder that if my phone was not rooted before I get this trouble (accidentally delete my chats) , can I still use that method ? :confused: and I am so confused about the method ..... I'm begging you that would you mind posting me with detailed procedures.... I really appreciate it

I'm so confused and I really want my chat history back. Thanks for your time for reading this ..
[Android Apps and Games] Blinkin89:
Mm, you could try to lookup information about directories for your device when it's rooted.

There's probably a different directory where the app data is stored if it's not in the data directory.

I wouldn't know which one but I'm very sure there are more people with the same question and probably someone has the solution.

Aah so it's possible to turn it into a crypt. But it isn;t working 100%.

I really hope the dev's of these tools can help you, and all the others.

I'm keeping track of this topic because I really really love this tool and I'll try to help where I think I can.

Sorry to say, but I can't help with this.

So I hope some of the dev's become active on this topic again. Fingers crossed.

UPDATE: I haven't used this tool for exact one month... I just tried extracting my most recent db's just to discover the same problem that it doens't recognise the db's.

My installation of whatsapp extract hasn't been changed, so this must mean whatsapp has changed the code and the constructin of the db.

So that means till this tool get's updated it's useless with the most recent whatsapp version.

Can anybody else confirm this?

This really sucks, I feel stupid that I didn't test it after the recent update.
[Android Apps and Games] breakbiter:
First of all, sorry for my English, I'm Spanish.

I have a copy of my conversations and I need to restore it.

The problem is that this copy is corrupted, because I formatted my memory card and I had to save my data with a special program that retrieves them.

I am using Whatsapp_Xtract_V2.2_2012-11-17 and Whatsapp_Xtract_Py_2_51.

img46.imageshack.us/img46/5194/1r8s.jpg

as seen in the photo, the html is blank.

Thanks for your attention
[Android Apps and Games] delhiboy:
edit chat

hi,i want to edit chat of whatsapp..

can it be done,like i open that file in sql and then can read it and edit it then save it,and put it in my device and then edited chat conversation will come..

i have installed sqlite,but i am unable to repair that file...the second step i cant understand.."start whatapp_xtract_console.bat"

please help.
[Android Apps and Games] Blinkin89:
Just discovered that the crypted db's are working for me...

The one's from the data directory (root required) won't work.

Error I get is:

"Error: file is encrypted or is not a database".

Above that it says that the db hasn't got any integrity issues.

I'm now going to compare a older db to the new one to see what's different.

To be continued...

Edit: problem found. Idk if this is only on my end though...

The wa.db seems to be empty when I open it with SQLite Database Browser, but the filesize is the same as it used to be (22kb).

I used an older wa.db copy that I had in a clockworkmod backup and now I could print all messages.

So eigther something is wrong on my end or Whatsapp also encrypted the wa.db or something... or they use a different db.
[Android Apps and Games] mayur.3.92:
I use whatsapp+ and have Done as stated

get the error (running as admin closed cmd prompt window immediatelt so plz se screenshot i got running normally)

and i have only msgstore.db.crypt but not other database or .db files will this work??(whatsapp registered with no X)

Actually i want to recover data of whatsapp registered with no X and have the entire copy of sd card data!

now registered whatsapp with no Y and have entire sd card data + /data/data/com.whatsapp/databases/msgstore.db and wa.db

however the device is same.
[Android Apps and Games] darwusch:
It was working fine, but not anymore since whatsapp version 2.11.23.

I'm using the root method with msgstore.db and wa.db and I get this message:

Traceback (most recent call last):
File "whatsapp_xtract.py", line 2670, in <module>
main(sys.argv[1:])
File "whatsapp_xtract.py", line 1651, in main
curr_chat = Chatsession(chats["id"],chats["display_name"],chats["wa_name"],chats["jid"],None,cha
ts["unseen_msg_count"],chats["status"],lastmessagedate)
IndexError: No item with that key

Anyone else having this issue?
[Android Apps and Games] harimar:
Will this S/W store my DB at any site??

I just want ask is it safe to use?

I hope it will not upload those chat on web somewhere?

plz reply!

and by the it really works/..............:D
[Android Apps and Games] Blinkin89:
As far as I know it doesn't.

But I can't guarantee it for 1005 (please note I know nothing of the code).
[Android Apps and Games] Cursed Chico:
I have created db files with extractor. Now i want to merge. I open sqlite browser but it cant accept the db files. It says file is not sqlite 3 database. Where do i do wrong?
[Android Apps and Games] charsta:
First of all I want to say that the tool works just fine with me on both windows and linux!

But I don't understand how the thumbnails for pictures and videos appear on the report, when I didn't include any media files to the coresponding folders.

Thumbnails are generated correctly, but when I click on them I get this message "Media object not found", on the new window.

Is it possible to get a picture/video thumbnail without opening the link??

Not that have problem is just I do get it! I mean, I just copy the database (no other files)!!

Edit:

Turns out that the thumbnails are included into the database file!! :p
[Android Apps and Games] Blinkin89:
Yes that's correct the thumbnails are raw data inside the db's. I broke my brains on that one to figure it out. xD

To get the media files working as a link:
[Android Apps and Games] Cursed Chico:
Thank you all merged 3 db and it seems nice. Just ,the new ones appear bottom without any information but when send a message to that persıon, everything goes normal.
[Android Apps and Games] sirucato:
Hi, I have a problem with this. I try with whatsapp_xtract_console.bat but I see this message in console:

C:\Users\xx\Desktop\I\Whatsapp_Xtract_V2.2_2012-11-17>cmd.exe /t:

A0 /k python whatsapp_xtract.py -h

Python Version 3.x

usage: whatsapp_xtract.py [-h] [-w WAFILE] [-o OUTFILE] infile

Converts a Whatsapp database to HTML.

positional arguments:

infile input 'msgstore.db' or 'msgstore.db.crypt' (Android)

or 'ChatStorage.sqlite' (iPhone) file to scan

optional arguments:

-h, --help show this help message and exit

-w WAFILE, --wafile WAFILE

optionally input 'wa.db' (Android) file to scan

-o OUTFILE, --outfile OUTFILE

optionally choose name of output file

C:\Users\xx\Desktop\I\Whatsapp_Xtract_V2.2_2012-11-17>python what

sapp_xtract.py -i msgstore.db.crypt

Python Version 3.x

usage: whatsapp_xtract.py [-h] [-w WAFILE] [-o OUTFILE] infile

whatsapp_xtract.py: error: unrecognized arguments: -i

C:\Users\xx\Desktop\I\Whatsapp_Xtract_V2.2_2012-11-17>

Anybody knows why?? Thanks!
[Android Apps and Games] Fathamon:
Ich habe nun folgendes Problem.

Ich konnte die msgstore.db.cryt auslesen und als Temp.sql abspeichern. Die Größe ist gleich geblieben.

Anschließend habe ich die fehlerhaften Zeilen in der Datenbank behoben.

Nun stehe ich vor dem Problem, das ich es nicht schaffe die SQL wieder zurück zu schreiben, damit ich sie mit Xtract auslesen kann.

wenn ich den Befehl in der Xtract Console ausführe

erstellt er mir zwar eine .db Datei, dennoch ohne Inhalt, sprich sie ist leer.

Was muss ich tun? Stehe total auf den Schlauch gerade.:confused:
[Android Apps and Games] lup3x:
How do you get the contact names from msgstore.db?

Can i see the sourcecode anywhere?
[Android Apps and Games] Fathamon:
You can't see the contact names, but you can see the contact phonenumber at least the Temp.sql File, where create the "chat_list" table.
[Android Apps and Games] lup3x:
But then how do i get the contact names? Apparently the script only uses mgstore.db am i right?
[Android Apps and Games] akshitsoota:
Wow! This method works like a charm. Checked on 28th August, 2013!
[Android Apps and Games] Blinkin89:
It gets it from the wa.db. A small database that has the data about which names are for which numbers.
[Android Apps and Games] lup3x:
Right I saw that. But wa.db seemed empty when I opened it but now it works. Thanks!
[Android Apps and Games] HiStudio:
Many people need it, thanks for your hard work:good:
[Android Apps and Games] Fawaz.A:
Thanks man .. very useful! :good:
[Android Apps and Games] Genovia:
Hello,

May I know how thumbnail images are stored in the msgstore database ??

I would like to extract and view them outside the awesome html report generated by this tool

Thanks.

Genovia
[Android Apps and Games] officiallyme:
i am at work so haven't tried it yet and probably won't be able today. but does this tool allow you to copy all lessages from a specific thread at once?

i would like to export my conversations with certain people to a pdf file.

and if possible, not one message at a time :D
[Android Apps and Games] icecoldkilla:
Error: near line xxx: messages.key_remote_jid may not be NULL

Hey guys,

I used ver. 2.51 and happily my broken msgstor.db.crypt could be repaired

BUT there are some issues:

Before whatsapp_xtract_android_crypted.bat gives me the .html files it shows some errors in the batch box.

For me the errors are:

As I open msgstore.plain.db in SQLite Database Browser it says the ID's go only until 12163 which is below the error lines 12396-12399...

I'm doing this to get my Whatsapp chats back because I did a full Wipe. Whatsapp sees that there is a Backup and WA tries to import it, but it fails and there are no old chats. Just 2 groups but without any chatlines in it.

I hope somebody can help

If you have questions don't hesitate to ask me :)
[Android Apps and Games] Lctwisk:
Corrupted db, whatsapp xtract can repair it. But you will not be able to restore it ever again
[Android Apps and Games] icecoldkilla:
Why is that?

Is the structure lost due to the decryption. Or can Whatsapp only read the encrypted file. I wonder why WA cannot open the crypted file that I saved. It says backup found, but it doesn't show the messages. Is this issue because of a corrupt backup and when yes can I repair it to get back my messages in Whatsapp?
[Android Apps and Games] Lctwisk:
Whatsapp needs an encrypred database file. And for now there is no way to encrypt a repaired decrypted file AFAIK
[Android Apps and Games] JuLePe:
Yep! I have the same problem.

wa.db (the archive that contains the contact list, status, etc.) has been modified by WhatsApp team in the new versions hence the issue.

So, if you has not modified your contact list from the last update, you can use an older backup of wa.db or use the command without "-w wa.db" but you'll get a list without names, only the mobile numbers of your contacts.

Another way is to make a backup of "com.whatsapp", install a former version, refresh your contact list in the app, copy wa.db, reinstall the newer one and overwrite it with the backup.

You'll have to do that until a new update of WhatsApp Xtract, if we get it.
[Android Apps and Games] PowerMogli:
It worked for me too. But...

In chat list I dont see the correct last message of each. The last message in chat list is the last message in the first (older) backup file.

And WhatsApp is crashing when I scroll up and there is a thumbnail (mediapreview).

I dont know exactly how but this guy has done it right:

http://xdaforums.com/showpost.php?p=31595785&postcount=270

Anyone here who knows how to solve both issues? Thx :good:
[Android Apps and Games] tjaschka:
I have the same problem. I have a repaired DB. I also encrypted this file with WhatsAppMigrator. But every time I try to restore, WA imports the DB, but in the end I get an empty list. Copying the decrypted file with root in /datadata/... doesn't work too.

Do you have any ideas, how it's possible to import the repaired DB?

Maybe download old WA, where you know, the import works? (then restore&backup&update)

Any other helpful ideas? :)
[Android Apps and Games] pangag:
After merge I am able to see the message list. I am also able to see the new and old message. BUT

On opening some chats its closing whatsapp. (Unfortunately, whatsApp has stopped) and it is throwing me out.

I have updated the chat_list table with latest message_table id but still the same problem.

Please Help.

I tried to search but could not find any solution on the post.

Please help....!!!!
[Android Apps and Games] pangag:
I am facing the same Issue.

Please help if you get the solution.
[Android Apps and Games] magerhert:
Thank you all devs. It works like a charm. Also good detailed explanation on this topic.

Only mistake i made was dragging the DB files from out a other folder than the Whatsapp xtract folder and that does not work(with me though), like you mentioned in the topic, i had to copy the files to the root and that worked. Nice tool btw!
[Android Apps and Games] caurusapulus:
Hello guys, i was looking for a method for merging two whatsapp databases.

Is the above method still valid?

I have now a HUGE database in my Gnexus and whatsapp is really slowing down when opening, so I was wondering if I can delete it and start from scratch, but maybe in some month merge them.

Ty in advance :)
[Android Apps and Games] nacxo:
Hi, its work! But ... where can i see the gps location data?