Hello,
I am trying to upgrade an application built for OpenAcs 5.5 to the 5.8 release. It is quite a big leap, and I am facing some expected issue.
The first is something I think had slipped through in upgrade scripts: /acs-kernel/sql/postgresql/upgrade/upgrade-5.7.0d8-5.7.0d9.sql seems to contain a syntax error (due to super quoting, I guess).
I have fixed it for me by replacing definition into the script with those found into /acs-kernel/sql/postgresql/postgresql.sql. Is there any problem with this solution? If not I can commit the change.
The second is more subtle and I can't figure out easily what to do: into ref_language::apm::after_upgrade, the system checks for new languages to add. In my database the Hebrew language already exists, with language id "iw". The upgrade tries to enter another row for Hebrew language with id "he".
As the two ids are different, checks for language uniqueness fail to see that this language already exists. The problem is that we have a unique constraint also on the 'name' column, so the upgrade throws an error.
I could not verify whether this bogus language was put into the database by hand or comes from the standard installation... if was put in there by "us", I could just remove the row. If this is not the case we need to put some code in there to handle the issue. Can someone give hints on this?
