Corrupted Conversations Database

One bad thing happened to my phone just a few nights ago. Somehow due to receiving a malformed SMS, the conversations and call history database was corrupted. This prevented the Conversations windows from working. I could not access any of my previous messages & new messages were not stored anymore.

It was not pretty, but this is what I had to do to fix it. I first copied the database file out to my PC to back it up, the file is ~/.rtcom-eventlogger/el-v1.db

Then I deleted the file, ran touch to create a new empty one & rebooted.
This fixed the issue, however all the messages & call history was lost.

Fortunately it is possible to access the data inside the el-v1.db from a PC, because it's an SQLite database file. I used SQLite Database Browser to access the file & retrieved the imported stuff. They're all in the Event table.

It was a nightmare, I hope nobody else gets this problem.

N900 - Missing GTK icons after upgrade to PR1.2

I had encountered this anoying little bug after i upgraded the Maemo firmware to PR1.2. It only happens in a few apps so I didn't immediately notice it. The issue is that a few stock GTK icons used in some apps such as cbrpager, abiword, gnumeric and kmplayer were missing. A broken link icon was shown it their place.

Took me quite a long time to look for the solution and I had almost given up. Today by sheer luck I finally came across the solution posted in the maemo.org forums just 3 days ago.
Here's the Link

In short, here's the solution. In the Terminal:
sudo gainroot
mv /usr/share/icons/hicolor/48x48/mimetypes/gtk-* /usr/share/icons/hicolor/48x48/hildon/

That's it. I'm happy now.