Today, learnt more things/errors that can possibly happen during the upgrade that is the submission_search_object_keywords table has corrupted records that results in an error during upgrade. The fix is easy just empty/truncate the table and re-index after migration please look at this issue for example OJS 3.1.2.1 - 3.1.2.4 - Upgrade failed due to corrupt 'submission search object keywords' table
But before you run the re-indexing command “php tools/rebuildSearchIndex.php” be sure you install Pdftotext linux filter/library https://docs.bitnami.com/oci/apps/resourcespace/configuration/install-pdftotext/
- Debian:
sudo apt-get update && sudo apt-get install -y xpdf- CentOS:
sudo yum install poppler-utils
Transferring files_dir in number 6 between servers over network, running rebuildSearchIndex.php in number 4 above and running upgrade command “php tools/upgrade.php upgrade”, these are long running process if you are working from home and your vpn times out from idling it will break the running process results in corrupted database during migration (need to re-import dbase). To solve this problem we can run processes in the background using this command for example:
[root@vmojs01 ojs]# nohup php tools/rebuildSearchIndex.php 2>&1 > output.log &
[1] 68308
[root@ivmojs01 ojs]# nohup: ignoring input and redirecting stderr to stdoutTo view your output:
[root@ivmojs01 ojs]# tail -f output.log
Make sure you transferred all necessary contents from previous ojs to new upgrade ojs before running the migration script like mentioned in this good old video https://www.youtube.com/watch?v=LY4ZBdxLKDE&t=469s especially the files_dir is very big in my case 100g worth of data files and as well public_files_dir a much smaller size.