Forum OpenACS Development: Re: Minor Error in Survey Package after upgrading
The problem at hand is a pg8/9 incompatibility. pg9 is closer to the standard and does not allow "return" as output column name. The error message from pg is suboptimal.
In case you have still the error.log from the upgrade, i would check, what upgrade scripts were executed and where the upgrade stopped. Then run the missing upgrade scripts manually.
If you don't have the log file anymore, go through the upgrade scripts and check in the database, if these were executed (i.e. pick e.g. a sql function from the file and check, whether you have it in the db).
Thanks!, it worked (I run the upgrade function manually).
I've lost error.log (at least I didn't find it) so I'll check this scripts to see if db has all functions in kernel upgrade scripts.
I've been checking some upgrade scripts and I'm a bit confused. It seems that what I find in DB it's differect form upgrade script BUT I don't find big errors (only a few).
So, I'm not completely sure what upgrade scripts has been failed. Without that error.log, how can I know that?
Can I do a "manual upgrade" of each file? I suppose BD might be messed up, right?
In general it is desirable to have scripts that can be run multiple times without doing harm. i hope, that all upgrade scripts of the kernel have this property. so, i would recommend to make a backup first before running the missing upgrade scripts.
Take care to run the upgrade scripts in the right order.
Another Idea could be stop (or prevent) upgrade but I think that's why error.log exists .
My problem now (as a whatever regular user at this point) is that I'm not completely sure about what upgrade script succeed. So I'll try to do it "manual" in my dev server and check if there is some problem.