Hi! @rcgillis @asmecher
When I run the upgrade script, it tells me this through the log:
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed ‘SCHEMA_PUBLICATION’ (this will throw an Error in a future version of PHP) in /opt/revistas/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 /opt/revistas/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Creating default object from empty value in /opt/revistas/classes/plugins/PubObjectsExportPlugin.inc.php on line 62
ERROR: Upgrade failed: DB: Table ‘revistadb.email_templates_data’ doesn’t exist
root@ojs-pruebas:/opt/revistas#
root@ojs-pruebas:/opt/revistas# php tools/upgrade.php upgrade
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘pdfjsviewerplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘driverplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘announcementfeedplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘pdfjsviewerplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘driverplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘announcementfeedplugin’ AND context_id = 0
PHP Warning: Use of undefined constant SCHEMA_PUBLICATION - assumed ‘SCHEMA_PUBLICATION’ (this will throw an Error in a future version of PHP) in /opt/revistas/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 /opt/revistas/lib/pkp/includes/functions.inc.php on line 223
PHP Warning: Creating default object from empty value in /opt/revistas/classes/plugins/PubObjectsExportPlugin.inc.php on line 62
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘doipubidplugin’ AND context_id = 0
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW COLUMNS FROM plugin_settings LIKE ‘context_id’
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ‘urnpubidplugin’ AND context_id = 0
[pre-install]
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT * FROM versions WHERE current = 1
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT * FROM versions WHERE current = 1 AND product_type = ‘core’ AND product = ‘ojs2’
[load: upgrade.xml]
[version: 3.2.0.0]
[code: Installer Installer::checkPhpVersion]
[code: Installer Installer::migrateSubmissionCoverImages]
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT * from submission_settings WHERE setting_name=“coverImage” OR setting_name=“coverImageAltText”
[data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = ‘VIEW’ THEN ‘V’ ELSE ‘T’ END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=schema()
PKP-Database-Logger 1652896891,2682: -----
(mysqli): select version()
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW INDEXES FROM email_templates
PKP-Database-Logger 1652896891,2682: -----
(mysqli): SHOW INDEXES FROM email_templates
PKP-Database-Logger 1652896891,2682: -----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’)
PKP-Database-Logger 1652896891,2682: -----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’)
PKP-Database-Logger 1652896891,2682: Query: UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’) failed. Table ‘revistadb.email_templates_data’ doesn’t exist
PKP-Database-Logger 1652896891,2682: 1146: Table ‘revistadb.email_templates_data’ doesn’t exist
ADOConnection._Execute(UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’), false)% line 1246, file: /opt/revistas/lib/pkp/lib/vendor/adodb/adodb-php/adodb.inc.php
ADOConnection.Execute(UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’))% line 442, file: /opt/revistas/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionLayoutUrl}’, ‘{$submissionUrl}’))% line 437, file: /opt/revistas/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(Array[14])% line 395, file: /opt/revistas/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 263, file: /opt/revistas/lib/pkp/classes/install/Installer.inc.php
ERROR: Upgrade failed: DB: Table ‘revistadb.email_templates_data’ doesn’t exist