Thread: [Conversations] WIP: Fix Conversations (SMS) send problem with database
View Single Post
computerinfo21 is offline computerinfo21
2011-11-22 , 19:11
Posts: 85 | Thanked: 97 times | Joined on May 2011
#16
Originally Posted by Discoveryellow View Post
Wow, this is pretty nifty [and fu***n advanced] thread! I wished I could make a better sense of it and fix my N900 that get SMS messages completely messed up (sent sms lost, incoming sms in disarray and outgoing ones never marked as sent or delivered). N900+me=love/hate-relationship

Anyways, I want to learn and fix my /rtcom-evetlogger/ database, but I am not sure which of the suggestions posted here is the solution and all seem different.

On a specific note: I got Sqliteman, but how do I extract the home/user/.rtcomm-eventlogger/el-v1.db to my computer? Please step by step, including how to put it back.

I am a noob, but I want to learn and try fixing this. (Hey, I got sudo gainroot thing on my N900

Thank you in advance!
Well you could try the other fixes listed like copying the database, but I had similar issues to what you are having and they were not resolved until I actually edited the info in it.

Ok, to help clarify the specifics of from my previous post
Important note: I incorrectly typed the directory, it is ".rtcom-eventlogger" (I put ".rtcomm" previously)

1. Put the n900 in offline mode (Press Power button once, chose offline from menu)

2. Make a back up using the Backup App (A full back up is a good idea, I only backed up the conversations (Communication and Calendar option)

3. [Modified this step to only back up the database instead of the whole folder] Make a copy of the /home/user/.rtcom-eventlogger/el-v1.db file in case of problems, then copy it where you can access from your computer
3a. Open X-Terminal on the n900 (ctrl + shift + x or through the menus) and type the following commands in it pressing enter after each (3b through 3e)
3b. Get root access by typing:
Code:
sudo gainroot
3c. Make a back up of the el-v1.db database file:
Code:
cp /home/user/.rtcom-eventlogger/el-v1.db /home/user/.rtcom-eventlogger/el-v1_backup.db
3d. Copy the el-v1 database file to the "MyDocs" folder so it will be available when you mount it:
Code:
cp /home/user/.rtcom-eventlogger/el-v1.db /home/user/MyDocs/el-v1_backup.db
3e. Type exit twice to close the terminal (first one exits root mode, second one closes terminal):
Code:
exit
4. Now connect the n900 to your computer using "Mass Storage Mode". You should be able to open Sqliteman, and then open the el-v1.db file directly on the mounted n900.

5. Go through the sql part of my previous post, executing sql commands as necessary. When finished close the program.

6. Safely remove the n900 from the machine (exactly how varies by operating system, should be a tray icon in Windows)

7. Copy the el-v1.db file back to the correct location
7a. Open X-Terminal on the n900 (ctrl + shift + x or through the menus)
7b. Get root access by typing:
Code:
sudo gainroot
7c. Copy the el-v1 database file from where we put it in "MyDocs" back to correct location:
Code:
cp /home/user/MyDocs/el-v1.db /home/user/.rtcom-eventlogger/el-v1.db
7d. Change the owner and group on the database to what they should be:
Code:
chown user:users /home/user/.rtcom-eventlogger/el-v1.db
7e. Change the permissions to what they should be:
Code:
chmod 644 /home/user/.rtcom-eventlogger/el-v1.db
7f. For what it is worth, you can compare the permissions of everything in the directory by typing:
Code:
ls -l /home/user/.rtcom-eventlogger/
7g. Type exit twice to close the terminal (first one exits root mode, second one closes terminal):
Code:
exit
Restart the phone, let it go online, and try to see if it resolves the issue. If the Conversations app won't open or something you can always restore from the Backup app.
 

The Following 2 Users Say Thank You to computerinfo21 For This Useful Post: