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
Database upgrade?
Re: Database upgrade?
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:Explanation:
(rm removes the newer database. mv renames the backup.)
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
- Change the current directory to Vienna's.
- Copy Vienna's database to a backup.
- Change the database's version to 20.
Code: Select all
cd ~/Library/Application\ Support/Vienna
rm messages.db
mv messages-bak.db messages.db
Re: Database upgrade?
Thanks, I think I am Terminal-savvy enough (just!) to do this. I'll give it a try.
Re: Database upgrade?
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.
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.
Re: Database upgrade?
Can anyone help me with this please?
Re: Database upgrade?
At this point, we're shooting in the dark.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.)
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
-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
Code: Select all
sudo chown yourusername messages.db
Re: Database upgrade?
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.
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.