The Issue:
I attempt to upgrade my OJS installation from version 3.2.0.2 to version 3.3.0.15 through Softaculous. After the upgrade, the OJS site is not coming up anymore. The error log in the error_log file shows the following error:
PHP Fatal error: Uncaught Exception: DB Error: Unknown column ‘nsf.revision’ in ‘on clause’ Query: SELECT sf., g.
** FROM publication_galleys g**
** INNER JOIN publications p ON (g.publication_id = p.publication_id)**
** LEFT JOIN submission_files sf ON (g.file_id = sf.file_id)**
** LEFT JOIN submission_files nsf ON (nsf.file_id = g.file_id AND nsf.revision > sf.revision)**
** LEFT JOIN submissions s ON (s.submission_id = p.submission_id)WHERE g.publication_id = ?**
** AND nsf.file_id IS NULL AND s.context_id = ? ORDER BY g.seq in /home/slujstco/public_html/lib/pkp/classes/db/DAO.inc.php:703**
Stack trace:
#0 /home/slujstco/public_html/lib/pkp/classes/db/DAO.inc.php(103): DAO->handleError(Object(ADODB_mysqli), ‘SELECT sf.*, g…’)
#1 /home/slujstco/public_html/classes/article/ArticleGalleyDAO.inc.php(118): DAO->retrieve(‘SELECT sf.*, g…’, Array)
#2 /home/slujstco/public_html/classes/submission/Submission.inc.php(267): ArticleGalleyDAO->getByPublicationId(219, 1)
#3 /home/slujstco/public_html/cache/t_compile/00a0a0910209607c in /home/slujstco/public_html/lib/pkp/classes/db/DAO.inc.php on line 703
[03-Sep-2023 17:01:31 Africa/Lagos] Incorrect table definition; there can be only one auto column and it must be defined as a key
[04-Sep-2023 07:57:55 Africa/Lagos] Incorrect table definition; there can be only one auto column and it must be defined as a key.
Please, what can I do to get this error addressed and get the OJS site up and running again.