View Single Post
Pyro1099's Avatar
Posts: 127 | Thanked: 19 times | Joined on Jul 2010 @ Wales
#62
Originally Posted by PSX View Post
Found a workaround for this today - the problem occurs because the Headers table in the /home/user/.rtcom-eventlogger/el-v1.db becomes corrupt. Happily this is repairable, on the device:

First gain root access:
Code:
sudo gainroot
..then switch to the target directory:
Code:
cd .rtcom-eventlogger
Now dump the contents of the existing database to a raw SQL file:
Code:
sqlite3 el-v1.db .dump > el-v1.db.sql
Restore the SQL to a new database:
Code:
sqlite3 el-v1.db.new < el-v1.db.sql
You may ignore SQL errors at this stage; they occur due to corruption in the source.

Now overwrite the broken DB (you may wish to back up the original file):
Code:
cp el-v1.db.new el-v1.db
Finally, ensure that the file is owned by 'user' and is in the 'users' group so it may be read by Conversations
Code:
chown user el-v1.db
chgrp users el-v1.db
Now close and re-open your Conversations app - the changes should be immediate!

Hope this helps,

Alex
With this keep both my send and received messages. One guy said it loses the sent messages.
__________________
Computer Nerd Music Lover Addict Gamer

Nokia N900 - Kernel V47 OC'd at 1.15mhz, CSSU, BleedingEdge, 64gb, H-E-N.

Need a ROM for an emulator on the N900? Then send me a message and Thank me in return.

If I help you somehow in a post then please press thanks next to it!

Message me @ Dale_Foster_1099@Hotmail.com
Xbox @ Pyro1099
Last.fm @ Pyro1099
Twitter @ Pyro1099