Database upgrade?

An RSS/Atom newsreader with features comparable to commercial newsreaders.
unklee
Harmless
Posts: 9
Joined: Thu Jan 23, 2020 12:47 am

Database upgrade?

Postby unklee » Thu Jan 23, 2020 1:03 am

I have been using Vienna for years now, and found it excellent. But recently I upgraded to the latest version, and I was told my database needed upgrading. I pressed the required button but nothing happened. I even waited a few days, but still, when I closed down and opened up again, I got the same message.

The link information is still there, because if I double click on any of my subscriptions the appropriate blog opens, but I am not getting any new feeds in.

I tried trashing the latest version and re-installing the previous version from Tima Machine, and I no longer get the database upgrade message, but I still don't get any feeds, and I can't subscribe to new ones.

I suspect the problem might be that I recently purchased a new Mac, and the transfer of the old files to my new Mac was stuffed up in some way, and I don't have access to all my old files (it thinks I am a different user, and won't give me permission to read them). I have tried getting advice from Apple Support, and will be trying again, but so far I have no solution to that.

Could that be the problem? Could Vienna be searching for a DB that wasn't carried across, or is under another user?

Is there some way I can uninstall not just Vienna but its database, and do a completely new install and manually re-enter my feeds? Or any other advice anyone can give me please?

Thanks

ashbake
Harmless
Posts: 1
Joined: Sat Jan 25, 2020 4:15 am

Re: Database upgrade?

Postby ashbake » Sat Jan 25, 2020 4:33 am

This worked for me. Sorry if you're not Terminal/shell-savvy.

Open Terminal. In Terminal paste or type these commands, with all the backslashes and quotes shown:

Code: Select all

cd ~/Library/Application\ Support/Vienna
cp messages.db messages-bak.db
echo 'pragma main.user_version = 20;' | sqlite3 messages.db
Explanation:
  • Change the current directory to Vienna's.
  • Copy Vienna's database to a backup.
  • Change the database's version to 20.
If you run into problems and want to restore the old backed-up database:

Code: Select all

cd ~/Library/Application\ Support/Vienna
rm messages.db
mv messages-bak.db messages.db
(rm removes the newer database. mv renames the backup.)

unklee
Harmless
Posts: 9
Joined: Thu Jan 23, 2020 12:47 am

Re: Database upgrade?

Postby unklee » Sun Jan 26, 2020 8:37 pm

Thanks, I think I am Terminal-savvy enough (just!) to do this. I'll give it a try.

unklee
Harmless
Posts: 9
Joined: Thu Jan 23, 2020 12:47 am

Re: Database upgrade?

Postby unklee » Mon Feb 10, 2020 8:35 am

I finally got around to trying this out (I had some other urgent things to do, so was delayed).

The first two steps were fine, but the third step led to this error message:

"Error: near line 1: attempt to write a readonly database"

Do you have a workaround for that please? Is there a command I can use to change the DB so I can write to it? (I am familiar with CHMOD to change file permissions, but I'm unsure if DB permissions are changed like that.)

Thanks.

unklee
Harmless
Posts: 9
Joined: Thu Jan 23, 2020 12:47 am

Re: Database upgrade?

Postby unklee » Sat Feb 15, 2020 10:36 pm

Can anyone help me with this please?

philmur
Harmless
Posts: 1
Joined: Sun Feb 16, 2020 4:52 am

Re: Database upgrade?

Postby philmur » Sun Feb 16, 2020 5:16 am

unklee wrote:"Error: near line 1: attempt to write a readonly database"

Do you have a workaround for that please? Is there a command I can use to change the DB so I can write to it? (I am familiar with CHMOD to change file permissions, but I'm unsure if DB permissions are changed like that.)
At this point, we're shooting in the dark.

Make sure Vienna is not running. (Though in my tests, this didn't matter.)
Check that your username has write permission:

Code: Select all

cd ~/Library/Application\ Support/Vienna
ls -l messages.db

You should see something like:

-rw-r--r--@ 1 yourusername staff 40960 Feb 15 23:47 messages.db

The important part is: -rw-r--r--
(which means user (you) can read and write, group can read, others can read)

If you see something else, try

Code: Select all

chmod 644 messages.db

In the unlikely event yourusername is not your user name, you can try

Code: Select all

sudo chown yourusername messages.db

Then try the sqlite3 command again. Good luck!

unklee
Harmless
Posts: 9
Joined: Thu Jan 23, 2020 12:47 am

Re: Database upgrade?

Postby unklee » Sun Feb 16, 2020 9:52 am

Thanks so much to you and ashbake. You may have been shooting in the dark, but you were spot on.

The database was listed under a different user, just a number, so once I changed it to my username, I could run the command and when I loaded Vienna again, a whole bunch of feeds started loading.

Thanks heaps. I understand what was happening, but I couldn't ever have done it myself.


Return to “Vienna”

Who is online

Users browsing this forum: Google Feedfetcher