crashed database

An RSS/Atom newsreader with features comparable to commercial newsreaders.
Micki2000
Harmless
Posts: 3
Joined: Wed Jun 01, 2016 8:40 am

crashed database

Postby Micki2000 » Wed Jun 01, 2016 8:48 am

Hi all,
I know, that someposted before but:
Before a few days my Vienna crashed and now when I opened all subscribtions are empty, no articles no subscriptions.
I tried delete everything from user/my user/library/application support/Vienna and tried put back the message.db or tried open it simply but no result.
I tried open the message.db from another user but still no luck reindex database isn't working.
I am having about one year old db but how can I try? The db is having about 310 mB and if somebody should help me I can send him the file.
I am blind and I tried work with the terminal and repair the sql but no luck.
Thank you for a help.

barijaona
Vienna Team
Posts: 589
Joined: Sat Nov 12, 2011 11:10 am
Contact:

Re: crashed database

Postby barijaona » Wed Jun 01, 2016 11:12 am

Hi,

Generally, it is a bit difficult, but I will try to recover it.
You can send me a link to download the file at barijaona at gmail dot com.
I contribute to Vienna RSS as a developer.
Please, don't forget those tips for writing a good bug report

Micki2000
Harmless
Posts: 3
Joined: Wed Jun 01, 2016 8:40 am

Re: crashed database

Postby Micki2000 » Thu Jun 02, 2016 7:39 am

Hi,
I will try in the evening.
But I tried delete all viena from application support, tried replace only the db.
When I tried repair the db as it is shown in this topic first part I received the same error.

viewtopic.php?t=26313
When I replaced message.db with the oldest one, I am seeing the feends which I am receiving as bbcworld etc. bu when I tried go to the articles it is empty, despite it is showing, that I am having 500 unread articles. Reindex in this case didn't helped.

Micki2000
Harmless
Posts: 3
Joined: Wed Jun 01, 2016 8:40 am

Re: crashed database

Postby Micki2000 » Fri Jun 03, 2016 9:59 am

Hi I sent a link.

nulls
Harmless
Posts: 1
Joined: Fri Jun 03, 2016 10:01 pm

Re: crashed database

Postby nulls » Fri Jun 03, 2016 10:26 pm

In the past i have this problem. I found this solution to repair messages.db
1) backup the file messages.db
2) from home folder

Code: Select all

cd Library/Application\ Support/Vienna
echo '.dump' | sqlite3 messages.db | grep rss_folders | grep INSERT | awk -F, '{print $2}'
echo '.dump' | sqlite3 messages.db | sqlite3 new_messages.db

3) delete messages.db and rename new_messages.db to messages.db

barijaona
Vienna Team
Posts: 589
Joined: Sat Nov 12, 2011 11:10 am
Contact:

Re: crashed database

Postby barijaona » Sat Jun 04, 2016 12:20 am

@Micki2000 : I tried @nulls suggestion on your database and it seems to work great.

Thanks to @nulls !
I contribute to Vienna RSS as a developer.
Please, don't forget those tips for writing a good bug report

kornea
Harmless
Posts: 1
Joined: Sun Oct 30, 2016 9:24 pm

Re: crashed database

Postby kornea » Sun Oct 30, 2016 9:26 pm

Thanks a lot ! These command lines save my database, too !!!

BIG thanks :-)


Return to “Vienna”

Who is online

Users browsing this forum: No registered users