I'm having problems sending messages to my gf, my most used contact. Messages always pending, won't save, can't open conversation etc. I was told that i have a corrupt database and to type this on in xterminal:
1. First of all make sure ALL conversations are closed including the Conversations window itself and then preferably go into Offline/Airplane/Tablet mode so it's not possible you'll receive any new messages of any kind.


2. Open a terminal and change to root:


Code:
sudo gainroot

3. Change to the directory where the database is stored:

Code:
cd /home/user/.rtcomm-eventlogger

4. Read the contents out the database and write it to a new file (NOTE: The filename is for the newer version of the database file introduced in PR1.2 I believe!!):

Code:
echo .dump | sqlite3 el-v1.db | sqlite3 el-v1-new.db

5. Move the existing file to another file to back it up:

Code:
mv el-v1.db el-v1-old.db

6. Move the newly created file to the proper name:

Code:
mv el-v1-new.db el-v1.db

7. You might need change the permissions on the file:

Code:
chown user el-v1.db
chgrp users el-v1.db

8. For completeness, why not reboot the phone:

Code:
init 6

After i type in the first two codes, everytime i attempt code 4 and hit enter, it just comes up with the same line of cd /home/user/.rtcomm-eventlogger
What a i doing wrong?!