Forum OpenACS Development: Response to Current short-term happenings...

Collapse
Posted by Don Baccus on
Yes, it is based on ACS 4.2.  The problem I ran into was that someone split acs-mail-create.sql into three pieces, each named "*-create.sql".  As distributed, two were tagged as being "data_model" and only acs-mail-create.sql was tagged as being "data_model_create".

Therefore only acs-mail-create.sql was loaded by the APM at install time.

However, we're moving datamodel files into sql/oracle and sql/postgresql subdirectories.  I moved acs-mail/sql/*.sql into sql/oracle, told the APM to remove the old files and add the new files.  Then trashed my test Oracle user and re-installed.  Then got errors as acs-mail-packages-create.sql was being run by the installer,  as well as acs-mail-create.sql.  The package create failed of course as the tables weren't defined.

  acs-mail-create.sql also ran acs-mail-package-create.sql so the end result was a proper install, but I figured I must've screwed up the APM somehow causing it to misidentify data_model_create files.

Not at all ... the screw-up was there in 4.2beta.

The fix is easy, I'll just rename the files...