upgrade destroyed all subscriptions

[solnull]

I've been using Vienna for about a month or so now with no problems, and it's been great. Until about fifteen minutes ago, when I got an alert about an upgrade. I figured, hey, why not, and when Vienna returned... it'd not only lost every single one of my 60+ subscriptions, it also lost the entire left sidebar. No "unread mail" box, no "today's mail" box, no trash, no... nothing. At all. Strangely, it did retain all the windows I'd had open behind the main reading window, but everything else is gone. If I remove messages.db, I get the default setup (and the left sidebar is back), but it's with a bunch of subscriptions I don't want and none of the sixty I went through all that trouble to add. Not to mention all the articles I'd marked for later reading, now gone. If I put messages.db back, then I'm back to blank sidebar and no subscriptions.

What's strange is that there's a folder call "source" in the application support/vienna/ folder, and it contains xml for all my subscriptions plus five or six default subscriptions. Is there any way to get Vienna to compile its subscription list from those xml entries? because clearly message.db isn't doing jack. Also, if I get it working again, I'll consider it lesson learned to never, ever accept an upgrade request from Vienna again, or at least not without exporting and backing up severely, because this crap is majorly annoying.

Any ideas for getting the xml files to become subscriptions again?

[barijaona]

I understand you were already on a 3.0 beta version, probably build 2820.
I doubt the problem you encounter is directly related to the upgrade. Nothing has really changed between 2820 and 2821 regarding database use and logic...

Can you try the solution I suggest here : http://www.cocoaforge.com/viewtopic.php?f=18&t=25000 ?

The xml files are only some caches of latest RSS feeds fetch (local feeds only, not applicable for Google Reader)... If you haven't exported an OPML file, they may give you a clue about the list of your local feeds, but they are not directly usable by Vienna...

By the way, if the reindex solution does not work, try to export an OPML file anyway...

[solnull]

I attempted the sql-lite fix shortly after trying the "remove, recreate, etc" message.db fix, since those two seem to be the only suggestions archived. No go.

I did try to export, too, and it gave me an export file that consisted of nothing.

I'm not quite sure how the problem couldn't be directly related to the upgrade, or at least directly triggered by the upgrade. Prior to that, I had closed and opened vienna a number of times, and it had reopened each time without missing a beat. I'd even crashed vienna a half-dozen times, most of which seemed to be related to having it open a tab in the background and then process smart folders (unread etc). It'd reopen just fine and carry on after that blip. Then I upgrade, it reopens, and I get this. Which says to me that it doesn't have to be database logic, so much as something that accidentally tosses out the subscription list while upgrading to, uh, whatever was new. I can't actually tell, having no sidebar. O.o

So if the message.db doesn't work, the sql reindex doesn't work, and the opml doesn't work, then there's just nothing to be done and this is just what vienna does sometimes?

[barijaona]

If you are ready to send me the database (gzipped), I can try to analyze it...

[cordovabay]

Yup... updated to the recommended release level yesterday and today all subscriptions are gone! Vienna had been working since I upgraded to the new release of Mountain Lion. This seems like a pretty fundamental product failure. Not impressed!

[barijaona]

Please, give as much details as possible to enable investigations.