Database fried

[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?

[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

[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"

[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...