yashsingh1/xdaforums huggingface dataset:
[Android Apps and Games] Jelgerw:
Hi all,

first of all, thanks to everyone working on this. Can't believe that the developers of Whatsapp themselves haven't made this easier.

I got everything to work up untill the point where I want to merge my old database with my new database. I followed all these steps up until step 8. Whenever I click the arrow (doesn't matter if I want to transfer rows from left to right or right to left), I get the following error:

Abort due to constraint violation

columns key_remote_jid, key_from_me, key_id are not unique

My databases stem from Android phones (HTC Desire S and my new HTC One). The versions of whatsapp on both phones is the same.

Does anyone know what the problem could be, and how to fix it? Bearing in mind that I have no knowledge of my own on SQL or any of this. All I did was follow the steps laid out for me.

I searched practically the whole thread, saw some people having the same problem, but didn't see any one with a solution.

Any help is appreciated!
[Android Apps and Games] zenjk:
May be I need latest

Hello ztedd,

Firstly, thank you very much for this tool.

I do need a lil help though, here is what i am trying to do.

1. I have a ChatStorage.sqlite file from my iPhone 5

2. When i try to use whatsapp_xtract_iphone it shows me following information on the screen

Python Version 2.x

Detected non-SQLite database, potentially an encrypted Android database

Trying to decrypt Android database...

Decrypted file written to ChatStorage.sqlite.plain.db

Error: File is not an encrypted Android database

Questions:

1. I am confused that why its telling me that its an Android Database, while its from the iPhone

2. Can this be decrypted?

3. Not sure if i have the latest and the greatest version of the scripts, where can i find it?

Really appreciate your help and response.

Cheers

- zen
[Android Apps and Games] Blinkin89:
A general message to all

Hi everyone,

I've been trying to give some support here and there because I love this tool, although I have nothing to do with the dev(s) of this tool.

I just want to confirm Jelgerw's last sentence: there are no working solutions posted for the current problems.

It's hard to debug these things without being able to replicate the problems, and since the creator of this tool hasn't been posting for a long long time (almost a year ago isn't it?) I don't think we can expect much (official) help.

I will keep reading these posts because if I can help, with my limited real life time, then I want to try that. But it's hard because I'm not a dev or in any way related to him/her.

I hope we all can enjoy future a version of this tool because it's really useful. Well it used to be without all the problems that the latest WhatsApp changes in the db and encryption are causing.

All the best,

Blinkin
[Android Apps and Games] Jelgerw:
Ha Blinkin,

thanks for your reply. Is there any explanation as to why this error occurs when trying to merge the database? I saw people reply that it did work for them. Any idea what the problem might be?
[Android Apps and Games] zenjk:
Thanks!

Thanks Blinkin! really appreciate your post.

Seems like you have used this tool, i am very new to it and just trying to figure out if i can use this tool to decrypt ChatStorage.sqlite from my iPhone 5? Would you know about it? Any help would be greatly appreciated.

Cheers
[Android Apps and Games] Tatyana88:
Problem

Hi! Please, help me!

When i open installpycrypto.bat, i get this message: error: <operationalError> unable to open database file None None

Computer is 64bit

Pithon27

Xtract v2.2

Sorry for my english

Thank u.
[Android Apps and Games] khoolio:
Merge multi db.crypt files

Hello all, thanks for all your time and support. This is first post for me after 1000s of searching for how to merge multi db.crypt files of whatsapp together.

actually I have about 40 of "msgstore-YYYY-MM-DD.1.db.crypt" files and I need to merge all as one file so I can get all my chat history back to live!

Please help me ..
[Android Apps and Games] smootsito:
Hi, i have this problem

//dl.dropboxusercontent.com/u/37442992/Help.png

How i can solve it? what i do wrong? Thanks:crying:
[Android Apps and Games] mila1907:
hi guys! any support for blackberry?
[Android Apps and Games] Riya Patel:
Error code of whatsapp extract

Hey i was trying to get whatsapp chat from whatsapp crypted file using whatsapp extracter and python. I did the same procedure as you explained but while running whatsapp_xtract_console file and typing given code i got this error

Import error : NO module named Crypto.Cipher

Additionally I have attached the snapshot.

waiting for your favorable reply.

Thank you..:cyclops:
[Android Apps and Games] philipepi:
very good,

worked like a charm
[Android Apps and Games] minigweek:
Worked Like A CHarm

Thanks folk...

Both the extractor , steps about megring the sql lite db worked like a charm!

Any one one windows if feel stuck, msg I might be able to guide u!
[Android Apps and Games] minigweek:
Did you try running the file named "!install...." it will connect to the net and install packages required for the crypto algorithm...

After that decryption should be successful.
[Android Apps and Games] Blinkin89:
You're welcome.

I have not a clue why this is happening. I know the problem but I don't understand which differences are causing the failing because like you said: some people don't have the problem. I hope someone can give us the answer.

You're welcome.

I think (or more guess) ark0n3 could help you. He made the WhatsappMigrator: http://xdaforums.com/showthread.php?p=32889018&highlight=ark0n3#post32889018 I think he needs to decrypt the iOS db, but I'm not sure. I don't have a iPhone around to verify this. But you could always ask him of course.

And not completely related to your question but this might be helpful (I hope): http://www.hongkiat.com/blog/backup-whatsapp-to-computer/

As far as I know someone was working on it... but I haven't heard much about it anymore. I might be on a different topic though.
[Android Apps and Games] robsonglima:
Problem with lines...

C:\whats>python wh b.crypt

Python Version 3.x

Android mode!

trying to repair android database...

trying to decrypt android database...

Traceback (most recent call last):

File "whatsapp_xtract.py", line 961, in ma

c1.execute("SELECT * FROM chat_list")

sqlite3.DatabaseError: file is encrypted or

During handling of the above exception, anot

Traceback (most recent call last):

File "whatsapp_xtract.py", line 979, in ma

c1.execute("SELECT * FROM chat_list")

sqlite3.OperationalError: no such table: cha

During handling of the above exception, anot

Traceback (most recent call last):

File "whatsapp_xtract.py", line 2062, in <

main(sys.argv[1:])

File "whatsapp_xtract.py", line 988, in ma

from Crypto.Cipher import AES

ImportError: No module named 'Crypto'

Can we help me?
[Android Apps and Games] robsonglima:
Closed Case!

Tks Guys!!

I resolved this problem!
[Android Apps and Games] Riya Patel:
Replyy

Thank u for replying sir.

Yes i had run that "!install.." file..i performed the steps exactly u said..but got the error at last!!

Pls help me out of dis..!

I wanna learn this :) Thanku you.

Waiting for ur reply again :)
[Android Apps and Games] crussel:
I get this error message. Someone have an idea how to solve the problem?

Thanks.
[Android Apps and Games] DualDark:
Hey everyone, i need some help here.

I dunno where is my mistake, i think that there's an error while installing file !install pyCrypto but im not really sure, and then when i drag n' drop my db.cryp to the proper file i got another errors.

I'll attach both screenshots, I hope someone could help me

Just for the record, first a installed the x64 python, then i read the first post correctly and uninstall this version and install de x86.

Thanks in advance.

_____________________________________________________________________-

nevermind... i just solved the problem with this -> http://xdaforums.com/showpost.php?p=41607192&postcount=591
[Android Apps and Games] yorkshirepudd:
whatsapp xtract error help

Hi

i keep getting this message, it has been working perfectly for months and then gave this error below, can anyone help please?

thanks

marc

Traceback (most recent call last):

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

main(sys.argv[1:])

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

curr_message = Message(msgs["Z_PK"],msgs["ZISFROMME"],msgs["ZMESSAGEDATE"],m

sgs["ZTEXT"],contactfrom,msgs["ZMESSAGESTATUS"],media["ZMEDIALOCALPATH"],media["

ZMEDIAURL"],media["ZTHUMBNAILDATA"],ZXMPPTHUMBPATH,mediawatype,media["ZFILESIZE"

],media["ZLATITUDE"],media["ZLONGITUDE"],media["ZVCARDNAME"],media["ZVCARDSTRING

"])

IndexError: No item with that key

C:\Whatsapp_Xtract_V2.2_2012-11-17>pause

Press any key to continue . . .
[Android Apps and Games] markthetaylor:
Whatsapp Xtract error

I am also getting the same issue. I believe that it has happened with the latest update from Whatsapp app v2.11.5. Its possible that whatsapp information interfaces have been changed and the whatsapp_xtract.py script is not provisioned as per the new interfaces.

Does anyone have solution to this problem.? Urgent help required. Please advise.

Thanks.
[Android Apps and Games] elgouna0:
Whatsapp Xtract Error

I am getting the same error as shown in the two messages before. Help is highly appreciated. On previous sqlite files it worked fine. The difference to the previous results is marked in red. This information is new.

Python Version 2.x

iPhone mode!

*** METADATA PLIST DUMP ***

Plist ver.: 1

UUID:

ListsRequested: True

NSStoreModelVersionHashesVersion: 3

GroupsRequested: True

NSStoreModelVersionIdentifiers: ['2.11.5']

NSPersistenceFrameworkVersion: 479

NSStoreModelVersionHashes:

WAMessageWord: uI3vOPgV67W88Lb/5nQ7H+koKaxi7DrnyUwKRFVk05U=

WAGroupInfo: eSGZH+oIvii5cwqLHsBeWVbSQaWgoMSRfr27k1aBcgQ=

WABroadcast: aryOIMrXvcETzP0GUb2TAlCvB//b82ISmkfbcW5z7Nk=

WAGroupMember: Bixzg/JWorjHdKKG9ChcELk99mA9hKpKFCKvr37iW34=

WAMessage: PxbcN/a/eSEU1PaJ38KqxU/3pOD4maxxcWYdZFI1v+M=

WAChatSession: IPc7JcSLIDJEKbreSwyThbwrostnkKlkA0fTUuDvF40=

WAChatProperties: F4Z/TeC3UHNEjwQKYM7jaTKQUjuIIS1dGFGW9cRKyYg=

WAMediaItem: JHz80+O+pUeKqLqw9Ecy8gKXPhg3zgmymapluv8fueM=

WABlackListItem: tUA3p+9kSuWHiSPnaawz92JFG1ZbX1lYqXQ5LZKKJrI=

_NSAutoVacuumLevel: 2

PicturesInSync: True

DefaultWP: True

NSStoreType: SQLite

***************************

Traceback (most recent call last):

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

main(sys.argv[1:])

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

curr_message = Message(msgs["Z_PK"],msgs["ZISFROMME"],msgs["ZMESSAGEDATE"],m

sgs["ZTEXT"],contactfrom,msgs["ZMESSAGESTATUS"],media["ZMEDIALOCALPATH"],media["

ZMEDIAURL"],media["ZTHUMBNAILDATA"],ZXMPPTHUMBPATH,mediawatype,media["ZFILESIZE"

],media["ZLATITUDE"],media["ZLONGITUDE"],media["ZVCARDNAME"],media["ZVCARDSTRING

"])

IndexError: No item with that key

D:\Download\WhatsAppXtract\Whatsapp_Xtract_V2.2_2012-11-17>pause

Press any key to continue . . .
[Android Apps and Games] markthetaylor:
Whatsapp_xtract.py Issue resolved

Okay, I have the fix for this issue now.

This may not be the best solution (which I will continue working on) but for now, at least it will enable you to read the chats as always. Do the following.

Just locate in the Xtract folder the file named whatsapp_xtract.py and hove over to line number 1667 (which reads as follows):

curr_message = Message(msgs["Z_PK"],msgs["ZISFROMME"],msgs["ZMESSAGEDATE"],msgs["ZTEXT"],contactfrom,msgs["ZMESSAGESTATUS"],media["ZMEDIALOCALPATH"],media["ZMEDIAURL"],media["ZTHUMBNAILDATA"],ZXMPPTHUMBPATH,mediawatype,media["ZFILESIZE"],media["ZLATITUDE"],media["ZLONGITUDE"],media["ZVCARDNAME"],media["ZVCARDSTRING"])

Replace the word "media["ZTHUMBNAILDATA"]" in the above line with "None".

Once done, try to run the program again. It shall work as before.

Please report the issues that you still may be facing with this fix and I will try to work on the resolution.

enjoy!!! :)

Thanks.
[Android Apps and Games] elgouna0:
Whatsapp Error

This workaround did the job. Thank you very much.
[Android Apps and Games] m1n9u1z:
I'm getting the following error: could not operate on a closed cursor. Also, i get a access denied mesage. Sorry I don't have the screens now, i'm not at home.
[Android Apps and Games] alphredo:
deleted conversations in the ".plain" file

Dear friends,

I can generate the HTML files and it's great.

BUT I noticed that if I simply read the ".plain" version of the DB with notepad I can also read lots of deleted conversations!!!

Is there any way to include also these deleted conversations in the HTML file?

Thanks.
[Android Apps and Games] squeeish:
I had the same Index error too and the workaround fixes it. Thanks!
[Android Apps and Games] Ripper_X:
i have tried in Windows 7 (both 32 and 64 bits) and in an old XP machine.

here you have the screenshots.

Thanks for your time and patience
[Android Apps and Games] Mayn:
I'm sorry but I'm afraid it's still not working:
[Android Apps and Games] ztedd:
Include Blackberry Whatsapp support (messagestore.db)?

Thanks!

In general, this would be an interesting enhancement. Can you tell me how you got the messagestore.db file?

Please download and install SQLite Database Browser : http://sqlitebrowser.sourceforge.net/

Open your messagestore.db file with it - does it work? What do you see?

If the file can be opened with SQLite Database Browser, then generally it also can be converted like the Android or Iphone files. However, the database structure is different for each platform. So it would be necessary to adopt the code.

Google gave me these links:

http://gkfy.com/2012760/open-whatsapp-database-files/

https://code.google.com/p/linuxsleuthing/source/browse/blackberry_tools/bbwhatsapp.py

You may download and try that python script (bbwhatsapp.py) with your messagestore.db database file. Please tell me if it works.

However that scripts seems to be rather basic. It does not much more than you could achieve by opening the db file with SQLite Database Browser and exporting it to Excel CSV using File - Export.

Theoretically, if this all works (and the messagestore.db file is not encrypted using the strong Blackberry encryption) we could include the support for this as well. But we would need a sample blackberry database for this.

So if you could send us your messagestore.db file, it should be possible.

CREATING A SAMPLE DATABASE:

You may also create a new blackberry sample database by reinstalling the blackberry whatsapp and then sending some test messages.

Ideally, these should include:

Also you can use SQLite Database Browser to anonymize your database file by modifying/deleting sensitive information.
[Android Apps and Games] ztedd:
I updated the file again, see first post.

But I guess you will somehow get a result file with completely empty messages :/

Not sure what exactly fails there.

Maybe your Iphone database file uses a changed structure in comparison to the sample iphone database I used while coding. Maybe we only could solve this problem if you can send me your db file or post screenshots of the Database structure using SQLite Database Browser. (open all "+" and make screenshots of the database structure of each table like ZWACHATSESSION etc.)

Update: I found the error. Stay tuned, I fix it!

Update: fixed error of handling timestamps in Iphone database. see link in first post.
[Android Apps and Games] gu1lty:
i´ve installed python Oo

when I start the install pyCrypto.bat the following window appears:
[Android Apps and Games] ztedd:
I don't get this... manually importing AES works but when called from inside the script, it fails??!

Can you please do this:

- run "whatsapp_xtract_console.bat" inside the folder of this script

- there type: pypm show pycrypto

- make a screenshot

- then type: python

- type: from Crypto.Cipher import AES

- type: import os

- type: os.system("whatsapp_xtract.py -i msgstore.db.crypt")

- make a screenshot
[Android Apps and Games] ztedd:
Du hast Python installiert, müsstest aber ActivePython installieren! Siehe im Readme / Howto im Punkt 4:
[Android Apps and Games] gu1lty:
yay deutsch :D

ehm ich hab auf der seite active python die 32bit version geladen und installiert, dennoch kommt die gleiche meldung beim ausführen der datei :\
[Android Apps and Games] besiegen:
It is simply in the whatsapp directory on the micro sd card.

Hi Ztedd, the blackberry messagestore is encrypted. I have tried the python script below but just returns with error: sqlite3.databaseError: File is encrypted or is not a database.

Unfortunately I can not supply you with a sample database, for this I apologise.

Carry on the good work
[Android Apps and Games] Ripper_X:
And here it is the screenshot with the process
[Android Apps and Games] ztedd:
:)

Hast du bei der Installation alle diese Optionen gewählt?

Insbesondere "register as Default Python" ist wohl notwendig damit er pypm findet.

Du kannst es aber auch so machen:

Startmenü - ActiveState ActivePython - Python Package Manager (PyPM)

aufrufen

Dann eingeben:

pypm install pycrypto

danach ggf.:

pypm show pycrypto

Falls es nicht klappt, mach wieder nen Screenshot ;)
[Android Apps and Games] Mayn:
Hey ztedd,

did you update the file (it's still version -4), and the link is dead :confused:

Thanks!
[Android Apps and Games] ztedd:
This is kind of weard...

Okay try this:

- whatsapp_xtract_console.bat

- python

- import Crypto

- make screenshot

Then:

- open windows explorer, go to folder:

%APPDATA%\Python

- Browse to folder site-packages

- Copy the whole folder Crypto to the folder where you installed Whatsapp Xtract (in your case, ...\carpeta compartida\v\Crypto)

- then run whatsapp_xtract_android_crypted.bat

- make screenshot if it doesn't work

Does this work for you?
[Android Apps and Games] ztedd:
Yes, it's updated, current version is -6 (Whatsapp_Xtract_V2.0_2012-04-30-6.zip)

You need to reload the first page!

Use the keyboard shortcut F5 or STRG + F5 or STRG + R to really reload it. Then it should show you the new links.
[Android Apps and Games] ztedd:
As I told you, the strong blackberry encryption can't be decrypted or at least you have to use third-party solutions to do this.

Simply copying the messagestore.db from the micro sd card itself (without using the Blackberry phone) will not work as this is the encrypted file.

You need to sync your blackberry with desktop manager (or connect the Blackberry phone to computer and then mount the microSD) and then copy the unencrypted messagestore.db file. Maybe this can be opened with SQLite Database Browser.

If this doesn't work you still could try to import the file again to the Blackberry. Maybe the Whatsapp application on Blackberry also supports an import of the Backup during installation like on Android. I don't have a Blackberry, so I can't try this.
[Android Apps and Games] gu1lty:
Mh hatte ich eig installiert.

Funktioniert leider dennoch auch über die Kommandozeile nicht..
[Android Apps and Games] ztedd:
Okay nimm Windows Explorer, gehe zum Programme-Ordner wo du Active Python installiert hast (zum Beispiel C:\Program Files (x86)\Python27).

Gehe dort zum Ordner Scripts, z.B. C:\Program Files (x86)\Python27\Scripts

Gibt es dort eine pypm.exe?

Wenn ja, dann mach folgendes.

- öffne die shell (Startmenü - Ausführen - cmd)

- gebe ein c: (vorausgesetzt der programme ordner liegt in C:)

- cd "C:\Program Files (x86)\Python27\Scripts" (oder wo halt deine pypm.exe liegt)

und jetzt:

- pypm install pycrypto

und dann

- pypm show pycrypto

Wenn das wieder nicht funktioniert oder du gar nicht den Installationsordner und Ordner Scripts findest, dann ist Active Python nicht richtig installiert.

Dann kann ich dir aber auch nicht helfen! Sondern du musst im Internet nach Hilfe zur Installation von ActivePython suchen.

Ggf. deinstallieren, neu installieren, neu starten.
[Android Apps and Games] Mayn:
Hallo ztedd,

es tut mir wirklich leid:
[Android Apps and Games] gu1lty:
also aus mir unbekannten gründen lag es wohl an windoof 7

habe es aus spaß mal auf meinem laptop der mit XP läuft installiert und ohne probleme läufts!

dennoch vielen dank! :)
[Android Apps and Games] Ripper_X:
It just worked!

Thanks a lot for your time and help!
[Android Apps and Games] sam@xda29:
Urgent Help

C:\Whatsapp_Xtract_V2.51_2013-03-15>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...

Traceback (most recent call last):

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

main(sys.argv[1:])

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

from Crypto.Cipher import AES

File "C:\Program Files (x86)\Python27\lib\site-packages\Crypto\Cipher\AES.py",

line 50, in <module>

from Crypto.Cipher import _AES

ImportError: DLL load failed: %1 is not a valid Win32 application.

C:\Whatsapp_Xtract_V2.51_2013-03-15>pause

Press any key to continue . . .

How can I solve this..

Please urgent help needed

I have Installed pycrypto and as well as the activephython of same version and also followed all the steps and all.

So can Anyone figure out please
[Android Apps and Games] capoeira81:
May i know why i got this error message?

C:\Windows\system32>"C:\Python27\Scripts\pypm" install pycrypto

error: Failed to download pypm-be.activestate/2.7.5.6/win64-x64/inde

x.gz>. Reason: <urlopen error [Errno 11004] getaddrinfo failed>

C:\Windows\system32>"C:\Python27\Scripts\pypm" show pycrypto

error: Failed to download pypm-be.activestate/2.7.5.6/win64-x64/inde

x.gz>. Reason: <urlopen error [Errno 11004] getaddrinfo failed>

Sorry i have to edit the URL above as i cannot post it in my first post in this forum.
[Android Apps and Games] sam@xda29:
Reply plz
[Android Apps and Games] sam@xda29:
Worked...thanks
[Android Apps and Games] dokazjasni:
BlackBerry

Hi all,

i'm trying to extract my whatsapp messages from a BlackBerry messageStore.db but i got the following Error:

python whatsapp_xtract.py messageStore.db
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 2062, in <module>
main(sys.argv[1:])
File "whatsapp_xtract.py", line 988, in main
from Crypto.Cipher import AES
ImportError: No module named Crypto.Cipher

Seems like the BlackBerry Whatsapp Files are encrypted. Can anybody decrypt it?

Thanks

:good: