Re: Upgrade failure

Hi Bruce,

there were a few changes in the main database schema between 0.9.6 and  
0.9.8. I'm pretty sure that the FreeBSD port does not automatically  
attempt to upgrade the main database (and fails to tell you so). I'm  
not perfectly sure whether auto-updating the main database will work  
from 0.9.6, but it is worth a try.

- depending on your database engine (you have installed all of them,  
so I don't know which one you're going to use) make a backup copy  
(sqlite) or a SQL dump (MySQL, PostgreSQL) of your current main  
database (refdb), just in case.

- run refdbd -a -u <username> -w <password>. You have to provide the  
username and password of the database admin, the ones you'd use for  
refdba.

- if this results in an error message or does not have the desired  
effect, delete your existing main database (delete the file if you use  
SQLite, run "DROP DATABASE refdb" in the appropriate command-line  
client when using MySQL or PostgreSQL) and go back to the manual to  
re-create the main database. You'll have to add your citation styles  
again after this procedure.

hope this helps
Markus



Quoting Bruce Hayward <[email protected]>:

> I've just upgraded most of the software on my FreeBSD 5.5 computer.
> Refdb is now complaining about the main database:
>



-- 
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV