Dear @asmecher
Forward system logs.
Performed basic reset and new restoration to generate fidelity in the logs
Thanks a lot
Augusto Torres
Log Apache: âBeforeâ run âphp upgrade.php upgradeâ
[Wed May 13 15:13:40.731817 2020] [php7:error] [pid 3460] [client 177.194.48.204:55150] PHP Fatal error:
Uncaught Exception: DB Error: ERROR: relation âpublicationsâ does not exist\nLINE 1: âŠ*, âpoâ.âseqâ from âsubmissionsâ as âsâ left join
"publicatiâŠ\n
^ Query: select âsâ.*, âpoâ.âseqâ from âsubmissionsâ as âsâ left join âpublicationsâ as âpoâ on âsâ.âcurrent_publication_idâ = âpoâ.âpublication_idâ
left join âpublicationsâ as âissue_pâ on âissue_pâ.âsubmission_idâ = âsâ.âsubmission_idâ left join âpublication_settingsâ as
âissue_psâ on âissue_pâ.âpublication_idâ = âissue_psâ.âpublication_idâ where âsâ.âcontext_idâ = ? and âsâ.âstatusâ in (?) and
(âissue_psâ.âsetting_nameâ = ? and âissue_psâ.âsetting_valueâ in (?)) group by âsâ.âsubmission_idâ, âpoâ.âseqâ order by âpoâ.âseqâ asc
in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/db/DAO.inc.php:703\nStack trace:\n#0 /usr/local/www/data/ojs-3.2.0-3/lib/pkp/
classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_postgres7),
âselect âsâ.*, "âŠâ)\n#1 /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/db/DAO in
/usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/db/DAO.inc.php on line 703, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
Log Apache: âAftherâ run âphp upgrade.php upgradeâ
[Wed May 13 15:20:40.302164 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: mkdir(): Permission denied in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/file/FileManager.inc.php on line 311, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.302240 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: assert(): assert(false) failed in /usr/local/www/data/ojs-3.2.0-3/plugins/generic/usageStats/UsageStatsPlugin.inc.php on line 732, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.349817 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: mkdir(): Permission denied in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/file/FileManager.inc.php on line 311, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.349851 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: assert(): assert(false) failed in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php on line 57, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.349881 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: fopen(): Filename cannot be empty in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php on line 111, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.349898 2020] [php7:warn] [pid 3433] [client 177.194.48.204:55216] PHP Warning: flock() expects parameter 1 to be resource, bool given in /usr/local/www/data/ojs-3.2.0-3/lib/pkp/classes/scheduledTask/ScheduledTask.inc.php on line 112, referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
[Wed May 13 15:20:40.349921 2020] [php7:notice] [pid 3433] [client 177.194.48.204:55216] ojs2: Couldnât lock the file., referer: https://www.cle.unicamp.br/ojs-3.2.0-3/
Results about upgrade:
php upgrade.php upgrade
[pre-install]
[load: upgrade.xml]
[version: 3.2.0.3]
[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]
[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: 7, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 7, 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.
WARNING: The NavigationMenu (ContextId: 1, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 6, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 6, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 8, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 8, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 4, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 4, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) 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]
[code: Installer Installer::createLicenseTerms]
[code: Installer Installer::installEmailTemplate]
[code: Installer Installer::changeUserRolesAndStageAssignmentsForStagePermitSubmissionEdit]
[data: dbscripts/xml/upgrade/3.2.0_versioning.xml]
[data: dbscripts/xml/upgrade/3.2.0_versioning_submissionCategories.xml]
[data: dbscripts/xml/upgrade/3.2.0_last_activity.xml]
[data: dbscripts/xml/upgrade/3.2.0_url_path.xml]
[code: Installer Installer::setStatsEmailSettings]
[code: Installer Installer::fixLibraryFiles]
[code: Installer Installer::installEmailTemplate]
[note: docs/release-notes/README-3.2.0]
[code: Installer Installer::addPluginVersions]
[post-install]
Release Notes
OJS 3.2.0-3 Release Notes
Git tag: 3_2_0-3