Hi,
We are encountering the following error during the update:
php tools/upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.2.0.1]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::migrateSubmissionCoverImages]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning_articleGalleySettings.xml (skipped)]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml]
[schema: lib/pkp/xml/schema/common.xml]
^[[B[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/categories.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: lib/pkp/xml/schema/navigationMenus.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]
[code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 66, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 66, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 3, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 3, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
ā¦
[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
[code: Installer Installer::migrateUserAndAuthorNames (skipped)]
[data: dbscripts/xml/upgrade/3.2.0_stylesheet.xml]
[data: dbscripts/xml/upgrade/3.2.0_archiving_settings.xml]
[data: dbscripts/xml/upgrade/3.2.0_update.xml]
[data: dbscripts/xml/upgrade/3.2.0_navigation_menu_items_locale_change.xml]
[code: Installer Installer::migrateSiteLocales]
[code: Installer Installer::migrateSidebarBlocks]
[code: Installer Installer::migrateSiteStylesheet]
[code: Installer Installer::migrateMetadataSettings]
PHP Fatal error: Uncaught Exception: DB Error: ERROR: null value in column āsetting_typeā violates not-null constraint
DETALHE: Failing row contains (7, , coverage, request, null). Query:
INSERT INTO journal_settings (
journal_id,
locale,
setting_name,
setting_value
) VALUES (?, ?, ?, ?) in /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_postgres8), ā\n\t\t\t\t\t\tINSERT Iā¦ā)
#1 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(941): DAO->update(ā\n\t\t\t\t\t\tINSERT Iā¦ā, Array)
#2 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(417): Installer->migrateMetadataSettings(Object(Upgrade), Array)
#3 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#4 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /var/www/ojs-3.2.0-1/lib/pkp/classes/cliTool/ in /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php on line 703
You have new mail in /var/spool/mail/root
We use postegres 7
could you help us?