I’m working on upgrading my OJS version from 3.1.2.0 to the latest 3.3.0.6 as you can see below
$ php tools/upgrade.php check
Code version: 3.3.0.6
Database version: 3.1.2.0
Latest version: 3.3.0.6
Database version is older than code version
Run "tools/upgrade.php upgrade" to update
However, I do receive this error consistently
[pre-install]
[load: upgrade.xml]
[version: 3.3.0.6]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::migrateSubmissionCoverImages]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found:
1054 Unknown column 'etd.email_id' in 'field list'
(SQL: UPDATE email_templates_data etd LEFT JOIN email_templates et ON
(etd.email_key = et.email_key
AND etd.assoc_type = et.assoc_type
AND etd.assoc_id = et.assoc_id
)
SET etd.email_id = et.email_id)
I checked my DB, and I only have the column email_key
in that table. The SQL query mentioned above seems a bit wrong.
Any advice or help?