Hi, thank you!
There is en entire output - is it ok?
$ php tools/upgrade.php upgrade
2024-05-31 13:16:54 [pre-install]
2024-05-31 13:16:54 [load: upgrade.xml]
2024-05-31 13:16:54 [version: 3.4.0.5]
2024-05-31 13:16:54 [code: Installer Installer::checkPhpVersion]
2024-05-31 13:16:54 [code: Installer Installer::installDefaultNavigationMenus]
WARNING: The NavigationMenu (ContextId: 5, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 5, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 10, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 10, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 9, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 9, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 6, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 6, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 7, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 7, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 4, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 4, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
WARNING: The NavigationMenu (ContextId: 0, Title: User Navigation Menu, Area: user) will be skipped because the specified area has already a NavigationMenu attached.
2024-05-31 13:16:54 [code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
2024-05-31 13:16:54 [migration: APP\migration\upgrade\v3_4_0\PreflightCheckMigration]
2024-05-31 13:16:55 [Removing orphaned entries from “submissions” with an invalid value for the required column “current_publication_id”. The following IDs do not exist at the reference table “publ ications”:
1, 311]
2024-05-31 13:16:55 [3 entries removed]
2024-05-31 13:16:55 [Removing orphaned entries from “submission_files” with an invalid value for the required column “submission_id”. The following IDs do not exist at the reference table “submissi ons”:
26, 27, 492]
2024-05-31 13:16:55 [3 entries removed]
2024-05-31 13:16:55 [Cleaning orphaned entries from “submission_files” with an invalid value for the column “source_submission_file_id”. The following IDs do not exist at the reference table “submi ssion_files” and will be reset to NULL:
195196414, 195196430, 195196379, 195196415, 195196419, 195196428, 195196398, 195196399, 195196432, 195196454, 195196473, 195196447, 195196475, 195196465, 195196483, 121, 101, 93, 89, 129, 125, 105, 97, 567, 559, 555, 551, 547, 539, 520, 512, 485, 477, 473, 461, 457, 453, 449, 445, 441, 437, 433, 429, 425, 421, 417, 413, 409, 405, 401, 397, 393, 321, 317, 313, 304, 300, 246, 242, 234, 214, 20 6, 202, 186, 166, 150, 146, 61, 57, 44, 915, 903, 899, 389, 385, 381, 377, 373, 355, 351, 347, 343, 339, 335, 331, 1146, 1142, 1138, 1134, 1130, 195195290, 195196036, 195196051, 195196022, 19519605 5, 195196050, 195196061, 195195965, 195196029, 195196038, 195196500, 195196516, 195196343, 195196344, 195196363, 195196326, 195196338, 195196358, 195196332, 195196333, 195196365, 195196321, 1951963 49, 195196324, 195196356, 195196262, 195196284, 195196267, 195196268, 195196290, 195196251, 195196274, 195196230, 195196276, 195196278]
2024-05-31 13:16:55 [148 entries updated]
2024-05-31 13:16:55 [Cleaning orphaned entries from “submission_files” with an invalid value for the column “genre_id”. The following IDs do not exist at the reference table “genres” and will be re set to NULL:
0]
2024-05-31 13:16:55 [13 entries updated]
2024-05-31 13:16:55 [Removing orphaned entries from “submission_file_settings” with an invalid value for the required column “submission_file_id”. The following IDs do not exist at the reference ta ble “submission_files”:
41, 42, 1494]
2024-05-31 13:16:55 [9 entries removed]
2024-05-31 13:16:55 [Removing orphaned entries from “submission_file_revisions” with an invalid value for the required column “submission_file_id”. The following IDs do not exist at the reference t able “submission_files”:
41, 42, 1494]
2024-05-31 13:16:55 [3 entries removed]
2024-05-31 13:16:55 [Cleaning orphaned entries from “publications” with an invalid value for the column “primary_contact_id”. The following IDs do not exist at the reference table “authors” and wil l be reset to NULL:
0]
2024-05-31 13:16:55 [4 entries updated]
2024-05-31 13:16:55 [The publication ID (10) for the submission ID 10 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (11) for the submission ID 11 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (14) for the submission ID 14 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (15) for the submission ID 15 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (19) for the submission ID 19 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (20) for the submission ID 20 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (22) for the submission ID 15 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (23) for the submission ID 14 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [The publication ID (26) for the submission ID 23 is assigned to an invalid issue ID “0”, its value will be updated to NULL]
2024-05-31 13:16:55 [Removing orphaned entries from “stage_assignments” with an invalid value for the required column “user_group_id”. The following IDs do not exist at the reference table “user_gr oups”:
2, 36, 48]
2024-05-31 13:16:55 [7 entries removed]
2024-05-31 13:16:55 [Removing orphaned entries from “stage_assignments” with an invalid value for the required column “submission_id”. The following IDs do not exist at the reference table “submiss ions”:
13, 28, 30, 31, 32, 33, 34, 36, 37, 39, 40, 41, 43, 45, 46, 69, 76, 567]
2024-05-31 13:16:55 [18 entries removed]
2024-05-31 13:16:55 [Cleaning orphaned entries from “sections” with an invalid value for the column “review_form_id”. The following IDs do not exist at the reference table “review_forms” and will b e reset to NULL:
0, 8]
2024-05-31 13:16:55 [13 entries updated]
2024-05-31 13:16:55 [Removing orphaned entries from “notifications” with an invalid value for the column “context_id”. The following IDs do not exist at the reference table “journals”:
8]
2024-05-31 13:16:55 [14 entries removed]
2024-05-31 13:16:55 [Removing orphaned entries from “notification_settings” with an invalid value for the required column “notification_id”. The following IDs do not exist at the reference table “n otifications”:
901, 912, 919, 940, 953, 1080, 1090, 1186, 1441, 1451, 1466, 1478, 1563, 1572]
2024-05-31 13:16:55 [14 entries removed]
2024-05-31 13:16:55 [Removing orphaned entries from “email_log_users” with an invalid value for the required column “email_log_id”. The following IDs do not exist at the reference table “email_log” :
1, 2, 3, 13, 14, 20, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 41, 64, 65, 87, 88, 89]
2024-05-31 13:16:55 [28 entries removed]
2024-05-31 13:16:55 [migration: PKP\migration\upgrade\v3_4_0\I8060_UpdateUserLocalesDefaultToEmptyArrayFromNull]
2024-05-31 13:16:55 [migration: PKP\migration\upgrade\v3_4_0\I7245_UpdateUserLocaleStringToParsableJsonString]
2024-05-31 13:16:56 [migration: APP\migration\upgrade\v3_4_0\I7129_IssueEntityDAORefactor]
2024-05-31 13:16:56 [migration: APP\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces]
2024-05-31 13:16:56 [migration: APP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys]
2024-05-31 13:17:00 [migration: APP\migration\upgrade\v3_4_0\I6093_AddForeignKeys]
2024-05-31 13:17:06 [migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2024-05-31 13:17:08 [migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2024-05-31 13:17:08 [migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2024-05-31 13:17:08 [migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2024-05-31 13:17:08 [migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2024-05-31 13:17:08 [migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2024-05-31 13:17:08 [migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2024-05-31 13:17:08 [migration: APP\migration\upgrade\v3_4_0\I7014_DoiMigration]
2024-05-31 13:17:09 [migration: APP\migration\upgrade\v3_4_0\I7265_EditorialDecisions]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I7624_StrftimeDeprecation]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I7592_RemoveUnusedEmailTemplates]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I7126_Galleys]
2024-05-31 13:17:09 [migration: APP\migration\upgrade\v3_4_0\I7190_RemoveOrphanFilters]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I7190_UpdateFilters]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I6895_CreateNewInstitutionsTables]
2024-05-31 13:17:09 [migration: PKP\migration\upgrade\v3_4_0\I8073_RemoveNotesWithoutQueriesAndRelatedObjects]
2024-05-31 13:17:09 [Removing orphaned note entry ID 9 with nonexistent query 8]
2024-05-31 13:17:09 [Removing orphaned note entry ID 10 with nonexistent query 9]
2024-05-31 13:17:09 [Removing orphaned note entry ID 13 with nonexistent query 12]
2024-05-31 13:17:09 [Removing orphaned note entry ID 14 with nonexistent query 13]
2024-05-31 13:17:09 [Removing orphaned note entry ID 17 with nonexistent query 16]
2024-05-31 13:17:09 [Removing orphaned note entry ID 18 with nonexistent query 17]
2024-05-31 13:17:09 [Removing orphaned note entry ID 19 with nonexistent query 18]
2024-05-31 13:17:09 [Removing orphaned note entry ID 20 with nonexistent query 19]
2024-05-31 13:17:09 [Removing orphaned note entry ID 21 with nonexistent query 20]
2024-05-31 13:17:09 [Removing orphaned note entry ID 22 with nonexistent query 21]
2024-05-31 13:17:09 [Removing orphaned note entry ID 35 with nonexistent query 31]
2024-05-31 13:17:09 [Removing orphaned note entry ID 36 with nonexistent query 32]
2024-05-31 13:17:09 [Removing orphaned note entry ID 37 with nonexistent query 33]
2024-05-31 13:17:09 [Removing orphaned note entry ID 38 with nonexistent query 34]
2024-05-31 13:17:09 [Removing orphaned note entry ID 39 with nonexistent query 35]
2024-05-31 13:17:09 [Removing orphaned note entry ID 48 with nonexistent query 41]
2024-05-31 13:17:09 [Removing orphaned note entry ID 66 with nonexistent query 52]
2024-05-31 13:17:09 [migration: APP\migration\upgrade\v3_4_0\I6895_Institutions]
2024-05-31 13:17:10 [migration: APP\migration\upgrade\v3_4_0\I6782_OrphanedMetrics]
2024-05-31 13:17:10 [Removing stats for context 1 because no context with that ID could be found.]
2024-05-31 13:17:10 [Removing stats for context 3 because no context with that ID could be found.]
2024-05-31 13:17:10 [Removing stats for context 8 because no context with that ID could be found.]
2024-05-31 13:17:10 [migration: PKP\migration\upgrade\v3_4_0\I6782_UsageStatsSettings]
2024-05-31 13:17:10 [migration: APP\migration\upgrade\v3_4_0\I6782_CreateNewMetricsTables]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsContext]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsIssue]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsSubmission]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsGeo]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_CleanOldMetrics]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I6782_RemovePlugins]
2024-05-31 13:17:11 [migration: PKP\migration\upgrade\v3_4_0\I7286_BatchesMigration]
2024-05-31 13:17:11 [migration: APP\migration\upgrade\v3_4_0\I8151_ExtendSettingValues]
2024-05-31 13:17:11 [migration: PKP\migration\upgrade\v3_4_0\I8151_ExtendSettingValues]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I2890_EmailTemplatesVarcharLengthUpdate]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I2890_AddSetNullForOnDeleteToReviewRoundIdForeign]
2024-05-31 13:17:13 [migration: APP\migration\upgrade\v3_4_0\I7901_Duplicate_OAI_IDs]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I7366_UpdateUserAPIKeySettings]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I8093_UpdateUserGroupRelationTablesFK]
2024-05-31 13:17:13 [migration: APP\migration\upgrade\v3_4_0\I7725_DecisionConstantsUpdate]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I4789_AddReviewerRequestResentColumns]
2024-05-31 13:17:13 [migration: APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema]
2024-05-31 13:17:13 [migration: PKP\migration\upgrade\v3_4_0\I7287_RemoveEmailTemplatesDefault]
2024-05-31 13:17:13 [migration: APP\migration\upgrade\v3_4_0\I5716_EmailTemplateAssignments]
PHP Warning: Attempt to read property “primary_locale” on null in /home/hostinglib/domains/journals-test.lib.vutbr.cz/public_html/lib/pkp/classes/migration/upgrade/v3_4_0/I5716_EmailTemplateAssign ments.php on line 461
2024-05-31 13:17:14 [revert migration: PKP\migration\upgrade\v3_4_0\I7287_RemoveEmailTemplatesDefault]
2024-05-31 13:17:15 [revert migration: APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema]
2024-05-31 13:17:15 [downgrade for “APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘locale’ cannot be null (SQL: insert into email_templates_settings
(email_id
, locale
, setting_name
, setting_value
) values (1, ?, name, COPYEDIT REQUEST), (2, ?, name, LAYOUT REQUEST), (3, ?, name, LAYOUT COMPLETE), (19, ?, name, EDITOR ASSIGN SUBMISSION), (25, ?, name, EDITOR ASSIGN REVIEW), (31 , ?, name, EDITOR ASSIGN PRODUCTION))