Crash on startup

[BillWeiss]

I apologize for the hand-wavy issue report, part of what I'm looking for is where to look for data :)

I recently backed up with Time Machine and restored to a fresh install a few times in a row due to hardware issues. Once that all happened, Vienna won't start: the icon shows up in the dock, bounces once or twice, and closes. I've tried with a couple of different versions of 3 Beta (20, 16, whatever I had lying around in my download folder) with the same result. Moving ~/Library/Preferences/uk.co.opencommunity.vienna2.plist aside doesn't fix anything. Same with ~/Library/Caches/uk.co.opencommunity.vienna2. Moving ~/Library/Application Support/Vienna/messages.db aside allows it to start, but that seems to include my feed list, so that's not very useful :(

Sadly I don't have a backup of my feed list, and I'm not syncing to anywhere. Otherwise I'd just move the messages.db aside and recreate.

Where else can I look for useful debug output? I don't see anything that looks interesting in Console, but it's quite possible I just don't know where to look.

[dak180]

That sounds like it might be a corrupted database.

On 2014/04/21, at 2:35 PM, Bill Weiss notifications@github.com wrote:

Moving ~/Library/Application Support/Vienna/messages.db aside allows it to start, but that seems to include my feed list, so that's not very useful :(

[BillWeiss]

That makes a certain sense :) Is there anything I can do to pull my list of feeds out of there?

[dak180]

It is just an sqlight database (last I checked) so standard recovery techniques for such should work.

One link to get you started: http://random.kakaopor.hu/how-to-repair-an-sqlite-database

On 2014/04/21, at 4:21 PM, Bill Weiss notifications@github.com wrote:

That makes a certain sense :) Is there anything I can do to pull my list of feeds out of there?

---

My Web Sites:
http://dak180.users.sourceforge.net/

[BillWeiss]

Got it! My sqlite db was bad enough that I couldn't do the dump/restore, but I managed to pull the right data out doing this:

echo '.dump' | sqlite3 messages.db | grep rss_folders | grep INSERT | awk -F, '{print $2}'

Probably not the most elegant way to do it, but it worked.

[barijaona]

Fine trick, @BillWeiss. Should probably be in a Vienna FAQ somewhere.

[BillWeiss]

I was hoping to see some sort of "here's what our table scheme" is in the docs, but I quickly went to "eh, how hard can it be?" :)

[barijaona]

There is a table scheme in developers' docs. The FAQ should also point to this document.