Yesterday I attempted to upgrade my institution’s OJS installation to version 3.4.0.3 (from 3.3-something), and the upgrade failed. I tried to get help from our ITS Systems Administrator, and with help from the PKP forum he was able to figure out fixes to some of the error messages we were getting, but we are getting stuck at one error message in particular. Here are the steps that he is taking:
• Signed into https://www.wittprojects.net:2083/cpanel
• Selected Backup
• Under Download a MySQL Database Backup, selecte wittproj_ojs873
• Saved the download as wittproj_ojs873-20231109-1130.sql.gz
• Clicked CPanel to go back to the CPanel main screen
• Selected File Manager
• Navigated to public_html / ojs
• Highlighted config.inc.php
• Selected Edit
• Updated the following entry
• Clicked Save Changes
• Clicked Close
• Selected MySQL(R) Databases
• Under Current Databases found wittproj_ojs873
• clicked the Delete button to its right
• Clicked Delete Database
• Clicked Go Backup
• Under Create New Database, entered in wittproj_ ojs873
• Clicked Create Database
• Clicked Go back when it was finished
• Under Add User to Database, set User to wittproj_ojs873
• Set Database to wittproj_ojs873
• Clicked Add
• Checked All Privileges
• Clicked Make changes
• Clicked CPanel to go back to the cpanel main page
• Selected Backup
• under Restore a MySQL Database Backup clicked Choose file
• uploaded the wittproj_ojs873-20231109-1130.sql.gz
• Clicked Upload
• Clicked CPanel to go back to the cpanel main page
• Selected PhpMyAdmin to bring up the phpmyadmin page
• Navigated to wittproj_ojs873 / email_template_settings / columns
• Clicked Change next to locale
• Checked the box to allow Null
• Clicked Save
• Navigated to wittproj_ojs873 / user_settings
• Located the ROW that was user_id 1, en, familyName, blank
• Clicked the delete button to remove that line
• Navigated to wittproj_ojs873 / journal_settings
• Located submissionChecklist
• Clicked Edit and set it from
to
• Repeated for the other two submissionChecklist
• Opened the web page https://wittprojects.net/ojs/index.php/index/install/installUpgrade
• clicked Upgrade Open Journal Systems
It goes to a blank screen, and when we reload it and click the upgrade button again it gives us the error:
Additionally, I just saw that a new error message is showing up today:
Errors occurred during installation:
• A database error has occurred: There are unprocessed log files from more than 1 day ago in the directory /home/wittproj/ojsdata/usageStats/usageEventLogs/. This happens when the scheduled task to process usage stats logs is not being run daily. All logs in this directory older than 20231109 must be processed or removed before the upgrade can continue.
Thank you in advance for any help you can provide!