Page 1 of 1

Database fried

Posted: Mon Nov 19, 2012 11:26 am
by jochen.fuchs
Hi,
It looks like my database is fried. Vienna only starts when I remove my messages.db.
Is there any possibility to fix the database?

Re: Database fried

Posted: Tue Nov 20, 2012 3:33 am
by barijaona
You might try this :

- Download SQLite Database Browser, a free utility http://sqlitebrowser.sourceforge.net
- For safety, backup first messages.db
- Open SQLite Database Browser, navigate to messages.db and open it
- select the "Execute SQL" tab
- in the SQL string entry, type "REINDEX"
- click on "Execute query"
- save and quit

Hope this helps

Re: Database fried

Posted: Wed Dec 05, 2012 3:24 pm
by jarome
This does not work because SQLLite Browser will not let you navigate to the Library folder! It is not listed in the file list, presumably because it is "hidden"

Re: Database fried

Posted: Wed Dec 05, 2012 5:12 pm
by barijaona
In the Finder, use the Go to Folder... menu item, type ~/Library and click OK.

Then drag the folder to Finder's lateral bar.

Note to developers : it might be a good idea to insert a direct access to this reindex function in a future version of Vienna...