1 post tagged “n96 lifeblog sqlite”

Ok heres a quick post how to get rid of crap double entries in your Nokia Lifeblog Database. I got these double entries when pimping my N95 Firmware and everything got messed up. So if you want to get rid of double entries here is what You do:

1. Do your Backups. Backup your whole NokiaLifeblogData Folder in your "My Files" while Lifeblog is *not* running. Don´t blame me if you loose all your stuff, i told you

2. Use Windows Explorer to find files that contain "*[1]*". Delete or Move them to someone else. If you got tripple entries search for "*[2]*" etc.

3. Now we deleted the Files but there are still References in the Lifeblog Database. Thanks a lot to the brilliant developers of Lifeblog this is a sqlite database. Get yourself a copy of http://sqlitebrowser.sourceforge.net/

4. Fire up the Sqlitebrowser and open your database file. It should be in your "My Files\NokiaLifeblogData\DataBase_2" folder. The file shoule be named NokiaLifeblogDataBase.db3

5. You did your Backups right? ;)

6. Go to the "Execute SQL" Tab and paste the following Query:

DELETE from LbObjectCore where LbObjectId IN (SELECT LbObjectId  FROM  LbObjectFileReference WHERE Filename like '%[%]%' );

Hit the "execute query" button. It may take some time since this is a joint query. Be patient.

7. Close the Sqlite Browser and click "yes" to save the database on exit.

8. Fire up Lifeblog and and check the results. All the crap double entries should be gone.

That's it, hope that helped You. Thanks a lot to the Lifeblog guys again for using such a open db-format which gives us the power to make things happen we need and even share the tricks ;)