there is a glitch in the n900 that seems to be triggered by someone sending you a message that is more the 140 characters and is broken up into 2 or more messages. it doesnt happen all the time, but seems like i have problems when that happens if i am too fast and start to open the first message and the second populates after it.
some of the symptoms are:
cannot see messages,
you can see the message come in, but cannot open it.
only see the messages you send.
avatars missing
messages not sending out.
so, if you dont mind loosing some sms...then delete them all and see if that works. if not, report back.
well, you have everythingto gain and nothing to loose at this point.
Now close and re-open your Conversations app - the changes should be immediate!
Cpitchford originally helped me with this.
here is more detailed and i dont think that it deletes all your data like i had to.
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
---------
