You are viewing the PKP Support Forum | PKP Home Wiki

Database errors when upgrading to OCS 2.3.5

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

Database errors when upgrading to OCS 2.3.5

Postby derekp » Mon Jul 16, 2012 4:13 pm

I encountered two errors when upgrading OCS 2.1.2 to 2.3.5. The database is PostgreSQL 9.0.

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).
Posts: 16
Joined: Wed Oct 10, 2007 12:45 am
Location: University of British Columbia

Return to OCS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 1 guest