The first error was a violation of the NOT NULL constraint on the assoc_type column of the announcement_types table. My workaround for that was to comment out the <NOTNULL/> for the assoc_type field in lib/pkp/xml/schema/announcements.xml, then manually execute
- Code: Select all
ALTER TABLE announcement_types ALTER COLUMN assoc_type SET NOT NULL
The second error came when trying to execute dbscripts/xml/upgrade/2.3.4_update.xml. The SQL statements are in <query driver="postgres"> elements; they should be <query driver="postgres7"> instead. As a result, Installer::executeAction() finds no SQL statements in 2.3.4_update.xml to execute and aborts with an error message installer.installParseDBFileError (lib/pkp/classes/install/Installer.inc.php line 393).