Forum OpenACS Development: Re: Minor Error in Calendar after upgrading
Once again, it would have been nice to have a log in the database, what upgrade scripts were running correctly, and which are still outstanding.
Yes, as you have summarized a log audit of upgrade process would be great. Problem (at least for me) is to make sure that upgrade process goes in right order. As I understand, once it stops, it stops (don't load later versions of upgrade scripts)
Good news is that the solution is easy and working well: upgrade manual (psql -f) and IN ORDER. As I understand, I can upgrade several times so it doesn't happen anything wrong if I "repeat" some upgrade
If you would have still an old version number in the database, re-running the sql upgrade scripts in the right order would happen automatically on a second upgrade attempt (in most cases, this is safe).
Anyway, as we said before, an audit upgrade sript logtable might solve this (perhaps) rare problem