Post Reply

[Q] How to fix corrupt database?

8th March 2014, 12:32 PM   |  #1  
Basjoo's Avatar
OP Junior Member
Thanks Meter: 1
 
23 posts
Join Date:Joined: Jan 2012
More
Hello,

When I try to recover my Whatsapp messages on my new phone after I have copied the Whatsapp folder from my old phone to the SDcard, it suddenly crashes after 10 seconds: "Whatsapp has stopped working"

I looked into the System Log to find some clues about this crash. It looks like it has something to do with SQLite and the msgstore.db (or msgstore.db.crypt) file which says that the msgstore.db file is corrupt.

  1. "E/DefaultDatabaseErrorHandler (3784): Corruption reported by sqlite on database: /data/data/com.whatsapp/databasesmsgstore.db"
  2. "E/AndroidRuntime (3784): java.lang.AssertionError: android.database.sqlite.SQLiteDatabaseCorruptExcep tion: Database disk image is malformed (code 11), SQLiteConnection.java,-2"
  3. "E/SQLiteLog (3784): (14) cannot open file at line 30191 of [00bb9c9ce4]"
  4. "E/SQLiteDatabase (3784): Failed to open database '/data/data/com.whatsapp/databases/msgstore.db' "
  5. "E/SQLiteDatabaseException: unknown error (code 14): Could not open database"
  6. "I/sqlite_db_corrupt (3784): /data/data.com.whatsapp/databases/msgstore.db"


Can somebody help me to unravel this mistery? I really want to copy my old messages to my new phone and continue using the app on my new phone.

How can I fix the corrupt msgstore file? Or see what part of the file is corrupt (the exact cause)

NOTE: I added some screenshots of the System Log file to give you more information
Attached Thumbnails
Click image for larger version

Name:	Screenshot_2014-03-07-20-19-09.jpg
Views:	241
Size:	208.9 KB
ID:	2619943   Click image for larger version

Name:	Screenshot_2014-03-07-20-25-53.jpg
Views:	223
Size:	213.6 KB
ID:	2619944   Click image for larger version

Name:	Screenshot_2014-03-07-20-26-24.jpg
Views:	239
Size:	211.5 KB
ID:	2619946   Click image for larger version

Name:	Screenshot_2014-03-07-20-27-42.jpg
Views:	232
Size:	207.1 KB
ID:	2619947  
Last edited by Basjoo; 8th March 2014 at 12:52 PM.
8th March 2014, 04:37 PM   |  #2  
Senior Member
Flag Tangerang
Thanks Meter: 20
 
102 posts
Join Date:Joined: Aug 2013
More
Many people complained about whats app is force closed since Facebook bought whats app company,you should google it,or you can try delete backup folder on whats app /sdcard/whatsapp/backup maybe it can help,sorry if im not helped you

Sent from my N986 using xda premium
8th March 2014, 10:15 PM   |  #3  
Basjoo's Avatar
OP Junior Member
Thanks Meter: 1
 
23 posts
Join Date:Joined: Jan 2012
More
Quote:
Originally Posted by kelvinvalencio

Many people complained about whats app is force closed since Facebook bought whats app company,you should google it,or you can try delete backup folder on whats app /sdcard/whatsapp/backup maybe it can help,sorry if im not helped you

Sent from my N986 using xda premium

Thanks for your reply. But If I delete the backup file, then it will not be possible for Whatsapp to recover my message history right?
9th March 2014, 12:07 AM   |  #4  
Junior Member
Thanks Meter: 2
 
11 posts
Join Date:Joined: Mar 2014
thanks
appreciate it
The Following User Says Thank You to prodev_1990 For This Useful Post: [ View ]
Post Reply Subscribe to Thread

Tags
.db, corrupt data, crash, sqlite, whatsapp
Previous Thread Next Thread
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Top Threads in Questions and Answers by ThreadRank