• Welcome, Guest. Please login.
 

PROBLEM: Problems with *.sqlite.: I can't restore chat history of Whatts App:

Started by AlexanderMontiel, February 05, 2015, 01:01:17 pm

Previous topic - Next topic

AlexanderMontiel

I SEARCHED ALL OVER INTERNET BUT NOT GET AN ANSWER, SEEMS ONLY ON ME  ON THE PLANET HAS PASSED THIS.

MY PROBLEM IS:


I have an iPhone 4 to 16 GB with Jailbreak IOS 7.1.2

2 days ago just, i just send a message, and had open Whatts App.

Accidentally dropped my iPhone from a height of 1 meter: When i raise the iPhone is off and will not turn on, which I thought was odd, because even before he had fallen but never been something.

I proceed to open the iPhone, remove and put the battery: then turn on normally.

Until there everything seemed fine: until I open Whatts App and tells me .:

"SEEMS WHATSAPP HAVE PROBLEMS TO READ YOUR HISTORY CHATS. WHATTSAPP TRY HIM BACK. IT MAY TAKE SEVERAL MINUTES"

I give in recovering and reaching 10%: mark mistake .:

"UNFORTUNATELY WHATTS APP COULD NOT RECOVER YOUR HISTORY CHATS, PLEASE RESTORE IF OF ICLOUD"

Here another problem arises:
There had activated the automatic backup of chats due to which there was no space Icould.


When I go to restore Icould: The last copy was 13/9/2014: 6 months ago.

And a message appears which says "Restore now, if you skip this step, can not be restored later."

Obviously restore from six months ago does not serve me well.

So far the application of Whatts App occupied 6.5 GB

Proceeded to delete all my pictures of Icould to make space.
I have no backup of iPhone on the PC.

With iTools: I explore the application and backup throughout, including files and media files and file chats .

After exploring Whatts App and backup in my hard drive application, delete many media files to reduce the size of the App, until he was 4 GB.

I climb back up the iPhone (only data Whatts App) to iCloud.

After proceeded to restore chats Whatts App from iCloud (13/09/2014)

And surprise surprise ...

Chats were restored until that day ... 13/09/2014

And:
The application decreased from 4 GB to 890 MB:
WhattsApp delete all previous media: Fortunately I had backup earlier.

Then i tried to restore chats remotely via the file: "ChatStorage.sqlite"...

But Whatts App show me again the error:

"SEEMS WHATSAPP HAVE PROBLEMS TO READ YOUR HISTORY CHATS. WHATTS APP TRY HIM BACK. IT MAY TAKE SEVERAL MINUTES"

Again reaching the 10% mark mistake .:

"UNFORTUNATELY WHATTS APP COULD NOT RECOVER YOUR HISTORY CHATS, PLEASE RESTORE IR OF ICLOUD"

And again restore chats Whatts App from iCloud (09/13/2014).

Evidently the "ChatStorage.sqlite" file is damaged.

I looking in the PC a file browser for archives *.sqlite but none can open the file saying what was corrupt or damaged.

Only SQLITEADMIN opened it.
I explore cells and all open and all data are in the file, but reaching to de cell "ZWAMESSAGE" (here stay all messages) marks the error:

"SQL ERROR: LOGIC ERROR OR MISSING SQL DATABASE"

If I open "ChatStorage.sqlite" with a hex editor, I can distinguish many parts of the chats.

I tried to form a new file or try to fix it but all my attempts are unsuccessful and upload the file on the phone, and open Whatts App. "SEEMS WHATSAPP HAVE PROBLEMS TO READ YOUR HISTORY CHATS. WHATTS APP TRY HIM BACK. IT MAY TAKE SEVERAL MINUTES". and the cycle repeats.


The data (4GB) are in Icould and the PC but:
When restoring from iCloud is restored but error Whatts App:

"SEEMS WHATSAPP HAVE PROBLEMS TO READ YOUR HISTORY CHATS. WHATTS APP TRY HIM BACK. IT MAY TAKE SEVERAL MINUTES"

When restoring from iTunes is restored but error Whatts App .:

"SEEMS WHATSAPP HAVE PROBLEMS TO READ YOUR HISTORY CHATS. WHATTS APP TRY HIM BACK. IT MAY TAKE SEVERAL MINUTES"

I reiterate that through Hexadecimal editor I can distinguish fragments of conversations but I can not restore to the iPhone chat history because seem the *.sqlite stay corrupt.

Even at the end of the file, i see the last message which i send (before the fall of the phone) and see all conversations that day.
The data are in "ChatStorage.sqlite" the problem is what somehow the file is corrupted and i not know how to fix it.


I hope someone can please help or give me ideas.


I really need chats history again, is very important.

Thank you in advance.