It is quite long ! The system doesn’t allowed me to post entire file. I only able to post the last hundred lines or so. If you want to see the entire output, I can send you the file
thanks
===================================
-----
(mysqli): UPDATE submission_files sf, article_galleys_migration agm SET sf.assoc_type = 515, sf.assoc_id = agm.file_id WHERE sf.file_id = agm.style_file_id
-----
-----
(mysqli): UPDATE announcement_type_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE announcement_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE user_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE notification_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE email_templates_default_data SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE email_templates_data SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE controlled_vocab_entry_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE citation_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE metadata_description_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE filter_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE review_form_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE review_form_element_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE user_group_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submission_file_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE author_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE data_object_tombstone_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE journal_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE section_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE issue_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE issue_galleys SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE issue_galley_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submissions SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submission_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submission_galleys SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submission_galley_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE rt_versions SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE subscription_type_settings SET locale=‘nb_NO’ WHERE locale=‘no_NO’
-----
-----
(mysqli): UPDATE submissions SET status=4 WHERE status=0
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$submissionCopyeditingUrl}’, ‘{$submissionUrl}’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$submissionCopyeditingUrl}’, ‘{$submissionUrl}’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$layoutEditorName}’, ‘{$participantName}’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$layoutEditorName}’, ‘{$participantName}’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$layoutEditorUsername}’, ‘{$participantUsername}’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$layoutEditorUsername}’, ‘{$participantUsername}’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$copyeditorName}’, ‘{$participantName}’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$copyeditorName}’, ‘{$participantName}’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$copyeditorUsername}’, ‘{$participantUsername}’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$copyeditorUsername}’, ‘{$participantUsername}’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editors’) WHERE locale = ‘en_US’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editors’) WHERE locale = ‘en_US’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Herausgeber/innen’) WHERE locale = ‘de_DE’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Herausgeber/innen’) WHERE locale = ‘de_DE’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Επιμελητές’) WHERE locale = ‘el_GR’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Επιμελητές’) WHERE locale = ‘el_GR’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editores’) WHERE locale = ‘es_ES’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editores’) WHERE locale = ‘es_ES’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Éditeurs’) WHERE locale = ‘fr_CA’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Éditeurs’) WHERE locale = ‘fr_CA’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_default_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editores’) WHERE locale = ‘pt_BR’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): UPDATE email_templates_data SET body=REPLACE(body, ‘{$editorialContactName}’, ‘Editores’) WHERE locale = ‘pt_BR’ AND email_key IN (‘REVIEW_CONFIRM’, ‘REVIEW_DECLINE’)
-----
-----
(mysqli): INSERT INTO plugin_settings (plugin_name, setting_name, setting_value, setting_type, context_id) VALUES (‘defaultthemeplugin’, ‘enabled’, ‘1’, ‘bool’, 0)
-----
-----
(mysqli): INSERT INTO plugin_settings (plugin_name, setting_name, setting_value, setting_type, context_id) SELECT ‘defaultthemeplugin’, ‘enabled’, ‘1’, ‘bool’, journal_id FROM journals
-----
-----
(mysqli): INSERT INTO site_settings (setting_name, setting_value, setting_type) VALUES (‘themePluginPath’, ‘default’, ‘string’)
-----
-----
(mysqli): INSERT INTO journal_settings (setting_name, setting_value, setting_type, journal_id) SELECT ‘themePluginPath’, ‘default’, ‘string’, journal_id FROM journals
-----
-----
(mysqli): UPDATE event_log SET message=‘submission.event.submissionSubmitted’ WHERE message=‘log.author.submitted’
-----
-----
(mysqli): UPDATE submissions SET stage_id=3 WHERE submission_id IN (SELECT DISTINCT submission_id FROM review_assignments)
-----
-----
(mysqli): UPDATE submissions SET stage_id=3 WHERE stage_id = 1 AND submission_id IN (SELECT DISTINCT submission_id FROM review_rounds)
-----
-----
(mysqli): UPDATE submissions SET stage_id=4 WHERE submission_id IN (SELECT e1.submission_id FROM edit_decisions e1 LEFT JOIN edit_decisions e2 ON (e2.edit_decision_id > e1.edit_decision_id AND e2.submission_id = e1.submission_id) WHERE e2.edit_decision_id IS NULL AND e1.decision = 1)
-----
-----
(mysqli): UPDATE review_rounds SET stage_id=3
-----
-----
(mysqli): UPDATE review_assignments SET stage_id=3
-----
-----
(mysqli): UPDATE review_assignments ra, review_rounds rr SET ra.review_round_id = rr.review_round_id WHERE ra.submission_id = rr.submission_id AND ra.round = rr.round
-----
-----
(mysqli): INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_round_id, 3, afm.file_id, afm.revision FROM article_files_migration afm, articles_migration am, review_rounds rr WHERE am.review_file_id = afm.file_id AND rr.submission_id = afm.article_id AND rr.round = afm.round
-----
Query: INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_round_id, 3, afm.file_id, afm.revision FROM article_files_migration afm, articles_migration am, review_rounds rr WHERE am.review_file_id = afm.file_id AND rr.submission_id = afm.article_id AND rr.round = afm.round failed. Duplicate entry ‘1-1-3-1’ for key ‘review_round_files_pkey’
1062: Duplicate entry ‘1-1-3-1’ for key ‘review_round_files_pkey’
ADOConnection._Execute(INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_ro…, false)% line 1051, file: /opt/rh/httpd24/ojs/lib/pkp/lib/adodb/adodb.inc.php
ADOConnection.Execute(INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_ro…)% line 440, file: /opt/rh/httpd24/ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(INSERT INTO review_round_files (submission_id, review_round_id, stage_id, file_id, revision) SELECT afm.article_id, rr.review_ro…)% line 435, file: /opt/rh/httpd24/ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeSQL(Array[111])% line 396, file: /opt/rh/httpd24/ojs/lib/pkp/classes/install/Installer.inc.php
Installer.executeAction(Array[3])% line 265, file: /opt/rh/httpd24/ojs/lib/pkp/classes/install/Installer.inc.php
ERROR: Upgrade failed: DB: Duplicate entry ‘1-1-3-1’ for key ‘review_round_files_pkey’