Hi! While trying to update OJS I have the following errors:
root@jlm:/var/www/ojs-3.2.0-1# ls
api classes config.TEMPLATE.inc.php cypress.json docs index.php lib pages public registry schemas templates
cache config.inc.php controllers dbscripts favicon.ico js locale plugins README.md robots.txt styles tools
root@jlm:/var/www/ojs-3.2.0-1# php tools/upgrade.php upgrade
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Creating default object from empty value in /var/www/ojs-3.2.0-1/classes/plugins/PubObjectsExportPlugin.inc.php on line 62
[pre-install]
[load: upgrade.xml]
[version: 3.2.0.1]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml (skipped)]
[code: Installer Installer::removeReviewEntries]
WARNING: Unable to find a match for â70-278-1-RV.pdfâ in â/var/www/files//journals/1//articles/70/â. Skipping this file.
WARNING: Unable to find a match for â76-379-1-RV.pdfâ in â/var/www/files//journals/1//articles/76/â. Skipping this file.
WARNING: Unable to find a match for â99-545-1-RV.pdfâ in â/var/www/files//journals/1//articles/99/â. Skipping this file.
WARNING: Unable to find a match for â110-668-1-RV.pdfâ in â/var/www/files//journals/1//articles/110/â. Skipping this file.
WARNING: Unable to find a match for â116-716-1-RV.docxâ in â/var/www/files//journals/1//articles/116/â. Skipping this file.
WARNING: Unable to find a match for â118-740-1-RV.pdfâ in â/var/www/files//journals/1//articles/118/â. Skipping this file.
WARNING: Unable to find a match for â123-776-1-RV.pdfâ in â/var/www/files//journals/1//articles/123/â. Skipping this file.
WARNING: Unable to find a match for â127-855-1-RV.pdfâ in â/var/www/files//journals/1//articles/127/â. Skipping this file.
WARNING: Unable to find a match for â128-866-1-RV.pdfâ in â/var/www/files//journals/1//articles/128/â. Skipping this file.
WARNING: Unable to find a match for â134-932-1-RV.pdfâ in â/var/www/files//journals/1//articles/134/â. Skipping this file.
WARNING: Unable to find a match for â156-1045-1-RV.pdfâ in â/var/www/files//journals/1//articles/156/â. Skipping this file.
WARNING: Unable to find a match for â170-1108-1-RV.pdfâ in â/var/www/files//journals/1//articles/170/â. Skipping this file.
WARNING: Unable to find a match for â170-1108-2-RV.pdfâ in â/var/www/files//journals/1//articles/170/â. Skipping this file.
WARNING: Unable to find a match for â181-1169-1-RV.pdfâ in â/var/www/files//journals/1//articles/181/â. Skipping this file.
WARNING: Unable to find a match for â188-1232-1-RV.docxâ in â/var/www/files//journals/1//articles/188/â. Skipping this file.
WARNING: Unable to find a match for â194-1323-1-RV.docxâ in â/var/www/files//journals/1//articles/194/â. Skipping this file.
WARNING: Unable to find a match for â198-1348-1-RV.pdfâ in â/var/www/files//journals/1//articles/198/â. Skipping this file.
WARNING: Unable to find a match for â208-1423-1-RV.pdfâ in â/var/www/files//journals/1//articles/208/â. Skipping this file.
WARNING: Unable to find a match for â236-1648-1-RV.pdfâ in â/var/www/files//journals/1//articles/236/â. Skipping this file.
WARNING: Unable to find a match for â237-1668-1-RV.pdfâ in â/var/www/files//journals/1//articles/237/â. Skipping this file.
WARNING: Unable to find a match for â246-1751-1-RV.pdfâ in â/var/www/files//journals/1//articles/246/â. Skipping this file.
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml]
ERROR: Upgrade failed: DB: Table âarticle_galleys_migrationâ already exists
root@jlm:/var/www/ojs-3.2.0-1#
Again:
root@jlm:/var/www/ojs-3.2.0-1# php tools/upgrade.php upgrade
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Creating default object from empty value in /var/www/ojs-3.2.0-1/classes/plugins/PubObjectsExportPlugin.inc.php on line 62
[pre-install]
[load: upgrade.xml]
[version: 3.2.0.1]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::syncSeriesAssocType]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_preupdate_usageStatistics2.xml (skipped)]
[code: Installer Installer::removeReviewEntries]
[data: dbscripts/xml/upgrade/3.0.0_preupdate.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptTimedViews.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_adaptReferrals.xml]
[data: dbscripts/xml/upgrade/3.0.0_adaptBooksForReview.xml]
[data: dbscripts/xml/upgrade/remove_timed_views_bots.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_preupdate_commentsToEditor.xml (skipped)]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
ERROR: Upgrade failed: DB: Table âreview_assignments_tmpâ already exists
root@jlm:/var/www/ojs-3.2.0-1#
When I DROP This TABLES:
mysql> DROP TABLE notes_tmp, review_assignments_tmp, users_tmp, submission_galley_settings;
Query OK, 0 rows affected (0.04 sec)
Finally I have:
root@jlm:/var/www/ojs-3.2.0-1# php tools/upgrade.php upgrade
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed âSCHEMA_PUBLICATIONâ (this will throw an Error in a future version of PHP) in /var/www/ojs-3.2.0-1/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Creating default object from empty value in /var/www/ojs-3.2.0-1/classes/plugins/PubObjectsExportPlugin.inc.php on line 62
[pre-install]
[load: upgrade.xml]
[version: 3.2.0.1]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::syncSeriesAssocType]
PHP Fatal error: Uncaught Exception: DB Error: Unknown column âassoc_typeâ in âwhere clauseâ Query: UPDATE email_templates SET assoc_type = 530 WHERE assoc_type = â526â in /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php:703
Stack trace:
#0 /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), âUPDATE email_teâŠâ)
#1 /var/www/ojs-3.2.0-1/classes/install/Upgrade.inc.php(731): DAO->update(âUPDATE email_teâŠâ)
#2 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(417): Upgrade->syncSeriesAssocType(Object(Upgrade), Array)
#3 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(263): Installer->executeAction(Array)
#4 /var/www/ojs-3.2.0-1/lib/pkp/classes/install/Installer.inc.php(186): Installer->executeInstaller()
#5 /var/www/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc.php(88): Installer->execute()
#6 /var/www/ojs-3.2.0-1/lib/pkp/classes/cliTool/UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 /var/www/ojs-3.2.0-1/tools/upgrade.php(22): UpgradeTool->e in /var/www/ojs-3.2.0-1/lib/pkp/classes/db/DAO.inc.php on line 703
root@jlm:/var/www/ojs-3.2.0-1#
What to do next? I only have one copy of the database. The existing one.