OJS网站升级错误的解决办法

随着OJS官方的更新，我们再使用过程中也需要同步更新，升级操作很容易出现以下错误提示：

[pre–install] [load: upgrade.xml] [version: 3.3.0.8] [code: Installer Installer::checkPhpVersion] [data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml] [data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml (skipped)] [data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml] [data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml] [data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml] [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] ERROR: Upgrade failed: DB: SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘submission_galley_settings’ already exists (SQL: CREATE TABLE submission_galley_settings AS SELECT * FROM article_galley_settings WHERE setting_name <> ‘excludeDoi’ AND setting_name <> ‘excludeURN’)

解决方法：

第一步：从 3.0.2.0 更新到 3.1.1.2

第二步：从3.1.1.2更新到3.2.1-4

第三步：从3.2.1-4更新到3.3.0.8

注意：不要忘记备份网站！