Error during upgrade from 3.3.0.13 to 3.4.0.1 - Unsupported assoc_type in the event log: 515

seisense · June 18, 2023, 8:07pm

I am trying a web-based upgrade from 3.3.0.13 to 3.4.0.1. The upgrade process stopped with the following message
“Errors occurred during installation:
A database error has occurred: Unsupported assoc_type in the event log: 515”

PHP error log shows the following:

[18-Jun-2023 19:55:11 UTC] WARNING: The NavigationMenu (ContextId: 1, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
[18-Jun-2023 19:55:11 UTC] WARNING: The NavigationMenu (ContextId: 2, Title: Primary Navigation Menu, Area: primary) will be skipped because the specified area has already a NavigationMenu attached.
[18-Jun-2023 19:56:30 UTC] PHP Warning: Attempt to read property “primary_locale” on null in /home/seisense/test.seisense.com/lib/pkp/classes/migration/upgrade/v3_4_0/I5716_EmailTemplateAssignments.php on line 461
[18-Jun-2023 19:56:30 UTC] PHP Warning: Attempt to read property “primary_locale” on null in /home/seisense/test.seisense.com/lib/pkp/classes/migration/upgrade/v3_4_0/I5716_EmailTemplateAssignments.php on line 461
[18-Jun-2023 19:56:56 UTC] Unsupported assoc_type in the event log: 515

What application are you using?
PHP 8.1

Looking forward to your expert solution.
Thanks
seisense

asmecher · June 19, 2023, 8:48am

Hi @seisense,

In your OJS 3.3.0-13 database, can you check to see what the results are for the following database query?

SELECT * FROM event_log WHERE assoc_type=515;

note: corrected a typo in the query above

Regards,
Alec Smecher
Public Knowledge Project Team

seisense · June 19, 2023, 8:56am

I believe 513 in your suggested query is typo. So I replace it with the 515.

Please see the screen the resulting screenshot:

Thanks
seisense

Vitaliy · June 19, 2023, 2:02pm

Hi @seisense,

If you take a look at this line of the migration script, 0x0000203 is a hexadecimal value which php converts to decimal 515. Effectively, that means that linked condition should return true (515 === 0x0000203). Have no idea why it’s false in your case.

Do you have an opportunity to debug the migration locally? One of the options could be modify the exception to give more info, something like:

throw new \Exception('Unsupported assoc_type in the event log: ' . $row->log_id . ', ' . $row->assoc_type . ', ' . gettype($row->assoc_type) . ', ' . 0x0000203 . ', ' . gettype(0x0000203));

seisense · June 19, 2023, 5:49pm

Thanks, @Vitaliy for your effort and time. Unfortunately, I am not an expert in debugging the migration.
Meanwhile, I tried my luck a second time.

First, I upgraded my OJS from 3.3.0.13 to 3.3.0.14. It worked well and there was no issue at all.

After that, I ran the upgrade from 3.3.0.14 to 3.4.0.1 and unfortunately, I encountered the same error…

seisense · June 24, 2023, 5:52pm

Hello, I have tried this time to upgrade OJS using CLI and below I am going to share the complete output of the process in my two posts as the forum does not allow me to share all the code in one post. Hope, the experts can spare some time and help me if the data below give any clue.
Post 1/2

[seisense@rs206 tools]$ php upgrade.php check
Code version: 3.4.0.1
Database version: 3.3.0.14
Latest version: 3.4.0.1
Database version is older than code version
Run “upgrade.php upgrade” to update
[seisense@rs206 tools]$ php upgrade.php upgrade
2023-06-24 17:33:57 [pre-install]
2023-06-24 17:33:57 [load: upgrade.xml]
2023-06-24 17:33:57 [version: 3.4.0.1]
2023-06-24 17:33:57 [code: Installer Installer::checkPhpVersion]
2023-06-24 17:33:57 [code: Installer Installer::installDefaultNavigationMenus]
2023-06-24 17:33:57 [code: Installer Installer::migrateStaticPagesToNavigationMe nuItems]
2023-06-24 17:33:57 [migration: APP\migration\upgrade\v3_4_0\PreflightCheckMigra tion]
2023-06-24 17:33:59 [Cleaning orphaned entries from “submission_files” with an i nvalid value for the column “source_submission_file_id”. The following IDs do no t exist at the reference table “submission_files” and will be reset to NULL:
2482]
2023-06-24 17:33:59 [1 entries updated]
2023-06-24 17:33:59 [Cleaning orphaned entries from “submission_files” with an i nvalid value for the column “genre_id”. The following IDs do not exist at the re ference table “genres” and will be reset to NULL:
0]
2023-06-24 17:33:59 [101 entries updated]
2023-06-24 17:33:59 [Removing orphaned entries from “submission_file_settings” w ith an invalid value for the required column “submission_file_id”. The following IDs do not exist at the reference table “submission_files”:
368, 452, 511, 569, 574, 613, 653, 700, 702, 764, 782, 799, 846, 847, 848, 849, 850, 851, 852, 853, 854, 875, 878, 879, 898, 930, 934, 938, 1023, 1140, 1144, 12 05, 1222, 1233, 1264, 1459, 1537, 1577, 1584, 1588, 1596, 1602, 1614, 1621, 1655 , 1662, 1720, 1721, 1777, 1781, 1785, 1786, 1787, 1788, 1789, 1790, 1791, 1880, 1884, 1909, 1928, 1931, 2010, 2011, 2038, 2101, 2107, 2116, 2121, 2134, 2150, 21 51, 2173, 2258, 2297, 2340, 2371, 2384, 2474, 2486, 2488, 2489, 2497, 2510, 2548 , 2551, 2610, 2611, 2757]
2023-06-24 17:33:59 [145 entries removed]
2023-06-24 17:33:59 [Cleaning orphaned entries from “publications” with an inval id value for the column “primary_contact_id”. The following IDs do not exist at the reference table “authors” and will be reset to NULL:
745, 790]
2023-06-24 17:33:59 [2 entries updated]
2023-06-24 17:33:59 [Cleaning orphaned entries from “sections” with an invalid v alue for the column “review_form_id”. The following IDs do not exist at the refe rence table “review_forms” and will be reset to NULL:
0]
2023-06-24 17:33:59 [5 entries updated]
2023-06-24 17:33:59 [Removing orphaned entries from “custom_section_orders” with an invalid value for the required column “section_id”. The following IDs do not exist at the reference table “sections”:
1, 6]
2023-06-24 17:33:59 [7 entries removed]
2023-06-24 17:33:59 [Cleaning orphaned entries from “announcements” with an inva lid value for the column “type_id”. The following IDs do not exist at the refere nce table “announcement_types” and will be reset to NULL:
0]
2023-06-24 17:33:59 [1 entries updated]
2023-06-24 17:33:59 [Removing orphaned entries from “email_log_users” with an in valid value for the required column “user_id”. The following IDs do not exist at the reference table “users”:
308, 563, 569]
2023-06-24 17:33:59 [15 entries removed]
2023-06-24 17:33:59 [Removing orphaned entries from “email_log_users” with an in valid value for the required column “email_log_id”. The following IDs do not exi st at the reference table “email_log”:
4, 46, 47, 80, 81, 347, 348, 349, 784, 832, 833, 834, 851, 852, 986, 1016, 1018, 1122, 1128, 1240, 1282, 1313, 1772, 2168, 2169, 2794, 3150]
2023-06-24 17:33:59 [27 entries removed]
2023-06-24 17:33:59 [Removing orphaned entries from “notification_subscription_s ettings” with an invalid value for the required column “user_id”. The following IDs do not exist at the reference table “users”:
688]
2023-06-24 17:33:59 [2 entries removed]
2023-06-24 17:33:59 [Removing orphaned entries from “query_participants” with an invalid value for the required column “user_id”. The following IDs do not exist at the reference table “users”:
563, 569]
2023-06-24 17:33:59 [8 entries removed]
2023-06-24 17:33:59 [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 “submissions”:
18, 20, 29, 39, 354]
2023-06-24 17:33:59 [5 entries removed]
2023-06-24 17:33:59 [Removing orphaned entries from “user_interests” with an inv alid value for the required column “user_id”. The following IDs do not exist at the reference table “users”:
62, 308, 489, 569, 689, 690]
2023-06-24 17:33:59 [12 entries removed]
2023-06-24 17:33:59 [Removing orphaned entries from “user_settings” with an inva lid value for the required column “user_id”. The following IDs do not exist at t he reference table “users”:
58, 62]
2023-06-24 17:33:59 [6 entries removed]
2023-06-24 17:33:59 [migration: PKP\migration\upgrade\v3_4_0\I8060_UpdateUserLocalesDefaultToEmptyArrayFromNull]
2023-06-24 17:33:59 [migration: PKP\migration\upgrade\v3_4_0\I7245_UpdateUserLocaleStringToParsableJsonString]
2023-06-24 17:34:00 [migration: APP\migration\upgrade\v3_4_0\I7129_IssueEntityDAORefactor]
2023-06-24 17:34:00 [migration: APP\migration\upgrade\v3_4_0\I6091_AddFilterNamespaces]
2023-06-24 17:34:00 [migration: APP\migration\upgrade\v3_4_0\I3573_AddPrimaryKeys]
2023-06-24 17:34:05 [migration: APP\migration\upgrade\v3_4_0\I6093_AddForeignKeys]
2023-06-24 17:34:12 [migration: APP\migration\upgrade\v3_4_0\MergeLocalesMigration]
2023-06-24 17:34:16 [migration: PKP\migration\upgrade\v3_4_0\FailedJobsMigration]
2023-06-24 17:34:16 [migration: PKP\migration\upgrade\v3_4_0\UpgradeMigration]
2023-06-24 17:34:16 [migration: APP\migration\upgrade\v3_4_0\I6807_SetLastModified]
2023-06-24 17:34:16 [migration: APP\migration\upgrade\v3_4_0\I4235_OAISetSpec]
2023-06-24 17:34:16 [migration: APP\migration\upgrade\v3_4_0\I7264_UpdateEmailTemplates]
2023-06-24 17:34:21 [migration: APP\migration\upgrade\v3_4_0\I7596_RemoveNonExpiring]
2023-06-24 17:34:21 [migration: APP\migration\upgrade\v3_4_0\I7014_DoiMigration]
2023-06-24 17:34:21 [migration: APP\migration\upgrade\v3_4_0\I7265_EditorialDecisions]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I7624_StrftimeDeprecation]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I7592_RemoveUnusedEmailTemplates]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I7126_Galleys]
2023-06-24 17:34:21 [migration: APP\migration\upgrade\v3_4_0\I7190_RemoveOrphanFilters]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I7190_UpdateFilters]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I6895_CreateNewInstitutionsTables]
2023-06-24 17:34:21 [migration: PKP\migration\upgrade\v3_4_0\I8073_RemoveNotesWithoutQueriesAndRelatedObjects]
2023-06-24 17:34:23 [Removing orphaned note entry ID 35 with nonexistent query 28]
2023-06-24 17:34:23 [Removing orphaned note entry ID 42 with nonexistent query 35]
2023-06-24 17:34:23 [Removing orphaned note entry ID 48 with nonexistent query 41]
2023-06-24 17:34:23 [Removing orphaned note entry ID 62 with nonexistent query 54]
2023-06-24 17:34:23 [Removing orphaned note entry ID 63 with nonexistent query 55]
2023-06-24 17:34:23 [Removing orphaned note entry ID 74 with nonexistent query 59]
2023-06-24 17:34:23 [Removing orphaned note entry ID 75 with nonexistent query 60]
2023-06-24 17:34:23 [Removing orphaned note entry ID 93 with nonexistent query 72]
2023-06-24 17:34:23 [Removing orphaned note entry ID 94 with nonexistent query 73]
2023-06-24 17:34:23 [Removing orphaned note entry ID 104 with nonexistent query 80]
2023-06-24 17:34:23 [Removing orphaned note entry ID 141 with nonexistent query 104]
2023-06-24 17:34:23 [Removing orphaned note entry ID 146 with nonexistent query 107]
2023-06-24 17:34:23 [Removing orphaned note entry ID 175 with nonexistent query 118]
2023-06-24 17:34:23 [Removing orphaned note entry ID 186 with nonexistent query 124]
2023-06-24 17:34:23 [Removing orphaned note entry ID 191 with nonexistent query 125]
2023-06-24 17:34:23 [Removing orphaned note entry ID 197 with nonexistent query 129]
2023-06-24 17:34:23 [Removing orphaned note entry ID 206 with nonexistent query 135]
2023-06-24 17:34:23 [Removing orphaned note entry ID 212 with nonexistent query 138]
2023-06-24 17:34:23 [Removing orphaned note entry ID 217 with nonexistent query 142]
2023-06-24 17:34:23 [Removing orphaned note entry ID 218 with nonexistent query 143]
2023-06-24 17:34:23 [Removing orphaned note entry ID 221 with nonexistent query 146]
2023-06-24 17:34:23 [Removing orphaned note entry ID 243 with nonexistent query 161]
2023-06-24 17:34:23 [Removing orphaned note entry ID 248 with nonexistent query 165]
2023-06-24 17:34:23 [Removing orphaned note entry ID 263 with nonexistent query 174]
2023-06-24 17:34:23 [Removing orphaned note entry ID 275 with nonexistent query 180]
2023-06-24 17:34:23 [Removing orphaned note entry ID 285 with nonexistent query 184]
2023-06-24 17:34:23 [Removing orphaned note entry ID 356 with nonexistent query 211]
2023-06-24 17:34:23 [Removing orphaned note entry ID 359 with nonexistent query 214]
2023-06-24 17:34:23 [Removing orphaned note entry ID 360 with nonexistent query 215]
2023-06-24 17:34:23 [Removing orphaned note entry ID 361 with nonexistent query 216]
2023-06-24 17:34:23 [Removing orphaned note entry ID 367 with nonexistent query 219]
2023-06-24 17:34:23 [Removing orphaned note entry ID 373 with nonexistent query 221]
2023-06-24 17:34:23 [Removing orphaned note entry ID 374 with nonexistent query 222]
2023-06-24 17:34:23 [Removing orphaned note entry ID 375 with nonexistent query 223]
2023-06-24 17:34:23 [Removing orphaned note entry ID 376 with nonexistent query 224]
2023-06-24 17:34:23 [Removing orphaned note entry ID 386 with nonexistent query 232]
2023-06-24 17:34:23 [Removing orphaned note entry ID 388 with nonexistent query 234]
2023-06-24 17:34:23 [Removing orphaned note entry ID 397 with nonexistent query 239]
2023-06-24 17:34:23 [Removing orphaned note entry ID 406 with nonexistent query 246]
2023-06-24 17:34:23 [Removing orphaned note entry ID 407 with nonexistent query 247]
2023-06-24 17:34:23 [Removing orphaned note entry ID 420 with nonexistent query 255]
2023-06-24 17:34:23 [Removing orphaned note entry ID 427 with nonexistent query 262]
2023-06-24 17:34:23 [Removing orphaned note entry ID 431 with nonexistent query 265]
2023-06-24 17:34:23 [Removing orphaned note entry ID 436 with nonexistent query 270]
2023-06-24 17:34:23 [Removing orphaned note entry ID 463 with nonexistent query 284]
2023-06-24 17:34:23 [Removing orphaned note entry ID 478 with nonexistent query 291]
2023-06-24 17:34:23 [Removing orphaned note entry ID 481 with nonexistent query 292]
2023-06-24 17:34:23 [Removing orphaned note entry ID 486 with nonexistent query 297]
2023-06-24 17:34:23 [Removing orphaned note entry ID 488 with nonexistent query 299]
2023-06-24 17:34:23 [Removing orphaned note entry ID 489 with nonexistent query 300]
2023-06-24 17:34:23 [Removing orphaned note entry ID 503 with nonexistent query 309]
2023-06-24 17:34:23 [Removing orphaned note entry ID 506 with nonexistent query 311]
2023-06-24 17:34:23 [Removing orphaned note entry ID 507 with nonexistent query 312]
2023-06-24 17:34:23 [Removing orphaned note entry ID 508 with nonexistent query 313]
2023-06-24 17:34:23 [Removing orphaned note entry ID 511 with nonexistent query 315]
2023-06-24 17:34:23 [Removing orphaned note entry ID 515 with nonexistent query 319]
2023-06-24 17:34:23 [Removing orphaned note entry ID 518 with nonexistent query 322]
2023-06-24 17:34:23 [Removing orphaned note entry ID 519 with nonexistent query 323]
2023-06-24 17:34:23 [Removing orphaned note entry ID 527 with nonexistent query 331]
2023-06-24 17:34:23 [Removing orphaned note entry ID 553 with nonexistent query 349]
2023-06-24 17:34:23 [Removing orphaned note entry ID 555 with nonexistent query 350]
2023-06-24 17:34:23 [Removing orphaned note entry ID 577 with nonexistent query 366]
2023-06-24 17:34:23 [Removing orphaned note entry ID 595 with nonexistent query 376]
2023-06-24 17:34:23 [Removing orphaned note entry ID 602 with nonexistent query 383]
2023-06-24 17:34:23 [Removing orphaned note entry ID 604 with nonexistent query 385]
2023-06-24 17:34:23 [Removing orphaned note entry ID 607 with nonexistent query 387]
2023-06-24 17:34:23 [Removing orphaned note entry ID 608 with nonexistent query 388]
2023-06-24 17:34:23 [Removing orphaned note entry ID 611 with nonexistent query 391]
2023-06-24 17:34:23 [Removing orphaned note entry ID 617 with nonexistent query 396]
2023-06-24 17:34:23 [Removing orphaned note entry ID 618 with nonexistent query 397]
2023-06-24 17:34:23 [Removing orphaned note entry ID 638 with nonexistent query 404]
2023-06-24 17:34:23 [Removing orphaned note entry ID 645 with nonexistent query 411]
2023-06-24 17:34:23 [Removing orphaned note entry ID 646 with nonexistent query 412]
2023-06-24 17:34:23 [Removing orphaned note entry ID 654 with nonexistent query 416]
2023-06-24 17:34:23 [Removing orphaned note entry ID 672 with nonexistent query 421]
2023-06-24 17:34:23 [Removing orphaned note entry ID 673 with nonexistent query 422]
2023-06-24 17:34:23 [Removing orphaned note entry ID 677 with nonexistent query 424]
2023-06-24 17:34:23 [Removing orphaned note entry ID 687 with nonexistent query 431]
2023-06-24 17:34:23 [Removing orphaned note entry ID 691 with nonexistent query 435]
2023-06-24 17:34:23 [Removing orphaned note entry ID 693 with nonexistent query 437]
2023-06-24 17:34:23 [Removing orphaned note entry ID 696 with nonexistent query 439]
2023-06-24 17:34:23 [Removing orphaned note entry ID 702 with nonexistent query 445]
2023-06-24 17:34:23 [Removing orphaned note entry ID 706 with nonexistent query 448]
2023-06-24 17:34:23 [Removing orphaned note entry ID 707 with nonexistent query 449]
2023-06-24 17:34:23 [Removing orphaned note entry ID 723 with nonexistent query 462]
2023-06-24 17:34:23 [Removing orphaned note entry ID 725 with nonexistent query 464]
2023-06-24 17:34:23 [Removing orphaned note entry ID 730 with nonexistent query 468]
2023-06-24 17:34:23 [Removing orphaned note entry ID 740 with nonexistent query 478]
2023-06-24 17:34:23 [Removing orphaned note entry ID 741 with nonexistent query 479]
2023-06-24 17:34:23 [Removing orphaned note entry ID 745 with nonexistent query 482]
2023-06-24 17:34:23 [Removing orphaned note entry ID 754 with nonexistent query 492]
2023-06-24 17:34:23 [Removing orphaned note entry ID 756 with nonexistent query 494]
2023-06-24 17:34:23 [Removing orphaned note entry ID 757 with nonexistent query 495]
2023-06-24 17:34:23 [Removing orphaned note entry ID 758 with nonexistent query 496]
2023-06-24 17:34:23 [Removing orphaned note entry ID 759 with nonexistent query 497]
2023-06-24 17:34:23 [Removing orphaned note entry ID 776 with nonexistent query 507]
2023-06-24 17:34:23 [Removing orphaned note entry ID 777 with nonexistent query 508]
2023-06-24 17:34:23 [Removing orphaned note entry ID 781 with nonexistent query 512]
2023-06-24 17:34:23 [Removing orphaned note entry ID 782 with nonexistent query 513]
2023-06-24 17:34:23 [Removing orphaned note entry ID 783 with nonexistent query 514]
2023-06-24 17:34:23 [Removing orphaned note entry ID 787 with nonexistent query 517]
2023-06-24 17:34:23 [Removing orphaned note entry ID 790 with nonexistent query 520]
2023-06-24 17:34:23 [Removing orphaned note entry ID 804 with nonexistent query 524]
2023-06-24 17:34:23 [Removing orphaned note entry ID 812 with nonexistent query 526]
2023-06-24 17:34:23 [Removing orphaned note entry ID 817 with nonexistent query 529]
2023-06-24 17:34:23 [Removing orphaned note entry ID 818 with nonexistent query 530]
2023-06-24 17:34:23 [Removing orphaned note entry ID 819 with nonexistent query 531]
2023-06-24 17:34:23 [Removing orphaned note entry ID 852 with nonexistent query 545]
2023-06-24 17:34:23 [Removing orphaned note entry ID 882 with nonexistent query 551]
2023-06-24 17:34:23 [Removing orphaned note entry ID 884 with nonexistent query 553]
2023-06-24 17:34:23 [Removing orphaned note entry ID 885 with nonexistent query 554]
2023-06-24 17:34:23 [Removing orphaned note entry ID 886 with nonexistent query 555]
2023-06-24 17:34:23 [Removing orphaned note entry ID 888 with nonexistent query 556]
2023-06-24 17:34:23 [Removing orphaned note entry ID 891 with nonexistent query 559]
2023-06-24 17:34:23 [Removing orphaned note entry ID 893 with nonexistent query 561]
2023-06-24 17:34:23 [Removing orphaned note entry ID 913 with nonexistent query 571]
2023-06-24 17:34:23 [Removing orphaned note entry ID 918 with nonexistent query 573]
2023-06-24 17:34:23 [Removing orphaned note entry ID 931 with nonexistent query 583]
2023-06-24 17:34:23 [Removing orphaned note entry ID 961 with nonexistent query 600]
2023-06-24 17:34:23 [Removing orphaned note entry ID 966 with nonexistent query 603]
2023-06-24 17:34:23 [Removing orphaned note entry ID 975 with nonexistent query 609]
2023-06-24 17:34:23 [Removing orphaned note entry ID 988 with nonexistent query 617]
2023-06-24 17:34:23 [Removing orphaned note entry ID 989 with nonexistent query 618]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1008 with nonexistent query 628]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1012 with nonexistent query 630]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1013 with nonexistent query 631]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1016 with nonexistent query 634]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1044 with nonexistent query 647]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1049 with nonexistent query 651]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1058 with nonexistent query 658]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1060 with nonexistent query 660]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1076 with nonexistent query 664]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1079 with nonexistent query 666]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1092 with nonexistent query 672]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1106 with nonexistent query 681]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1139 with nonexistent query 696]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1141 with nonexistent query 697]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1147 with nonexistent query 702]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1173 with nonexistent query 723]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1174 with nonexistent query 724]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1185 with nonexistent query 730]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1186 with nonexistent query 731]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1190 with nonexistent query 734]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1199 with nonexistent query 740]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1200 with nonexistent query 741]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1202 with nonexistent query 743]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1209 with nonexistent query 750]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1210 with nonexistent query 751]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1213 with nonexistent query 753]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1214 with nonexistent query 754]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1215 with nonexistent query 755]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1217 with nonexistent query 757]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1218 with nonexistent query 758]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1246 with nonexistent query 767]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1263 with nonexistent query 780]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1272 with nonexistent query 788]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1274 with nonexistent query 789]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1281 with nonexistent query 795]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1307 with nonexistent query 812]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1311 with nonexistent query 814]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1312 with nonexistent query 815]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1316 with nonexistent query 817]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1327 with nonexistent query 823]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1328 with nonexistent query 824]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1330 with nonexistent query 826]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1332 with nonexistent query 828]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1337 with nonexistent query 830]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1368 with nonexistent query 844]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1393 with nonexistent query 854]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1398 with nonexistent query 856]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1432 with nonexistent query 868]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1444 with nonexistent query 875]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1449 with nonexistent query 879]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1458 with nonexistent query 884]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1459 with nonexistent query 885]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1466 with nonexistent query 889]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1468 with nonexistent query 891]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1469 with nonexistent query 892]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1474 with nonexistent query 896]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1480 with nonexistent query 902]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1485 with nonexistent query 905]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1487 with nonexistent query 907]

seisense · June 24, 2023, 5:52pm

failed upgrade process code 2/2

2023-06-24 17:34:23 [Removing orphaned note entry ID 1491 with nonexistent query 911]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1499 with nonexistent query 918]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1501 with nonexistent query 920]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1510 with nonexistent query 925]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1514 with nonexistent query 927]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1538 with nonexistent query 942]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1551 with nonexistent query 949]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1554 with nonexistent query 952]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1555 with nonexistent query 953]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1557 with nonexistent query 955]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1593 with nonexistent query 976]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1596 with nonexistent query 979]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1597 with nonexistent query 980]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1603 with nonexistent query 985]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1604 with nonexistent query 986]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1608 with nonexistent query 990]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1609 with nonexistent query 991]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1610 with nonexistent query 992]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1611 with nonexistent query 993]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1612 with nonexistent query 994]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1613 with nonexistent query 995]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1615 with nonexistent query 997]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1618 with nonexistent query 1000]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1621 with nonexistent query 1002]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1635 with nonexistent query 1006]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1637 with nonexistent query 1008]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1640 with nonexistent query 1011]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1641 with nonexistent query 1012]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1654 with nonexistent query 1022]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1655 with nonexistent query 1023]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1659 with nonexistent query 1026]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1665 with nonexistent query 1031]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1666 with nonexistent query 1032]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1682 with nonexistent query 1037]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1693 with nonexistent query 1045]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1695 with nonexistent query 1047]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1696 with nonexistent query 1048]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1701 with nonexistent query 1050]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1706 with nonexistent query 1053]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1711 with nonexistent query 1058]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1713 with nonexistent query 1060]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1728 with nonexistent query 1071]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1730 with nonexistent query 1073]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1748 with nonexistent query 1087]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1750 with nonexistent query 1088]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1752 with nonexistent query 1089]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1753 with nonexistent query 1090]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1755 with nonexistent query 1091]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1757 with nonexistent query 1092]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1759 with nonexistent query 1093]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1765 with nonexistent query 1095]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1769 with nonexistent query 1099]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1770 with nonexistent query 1100]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1792 with nonexistent query 1112]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1793 with nonexistent query 1113]
2023-06-24 17:34:23 [Removing orphaned note entry ID 1794 with nonexistent query 1114]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1795 with nonexistent query 1115]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1796 with nonexistent query 1116]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1803 with nonexistent query 1122]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1808 with nonexistent query 1125]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1810 with nonexistent query 1126]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1812 with nonexistent query 1128]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1813 with nonexistent query 1129]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1815 with nonexistent query 1131]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1818 with nonexistent query 1133]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1822 with nonexistent query 1136]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1823 with nonexistent query 1137]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1824 with nonexistent query 1138]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1825 with nonexistent query 1139]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1828 with nonexistent query 1142]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1829 with nonexistent query 1143]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1831 with nonexistent query 1145]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1833 with nonexistent query 1147]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1834 with nonexistent query 1148]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1841 with nonexistent query 1152]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1843 with nonexistent query 1154]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1861 with nonexistent query 1164]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1876 with nonexistent query 1170]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1885 with nonexistent query 1178]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1898 with nonexistent query 1186]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1899 with nonexistent query 1187]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1902 with nonexistent query 1189]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1904 with nonexistent query 1190]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1910 with nonexistent query 1194]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1917 with nonexistent query 1198]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1927 with nonexistent query 1205]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1928 with nonexistent query 1206]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1929 with nonexistent query 1207]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1930 with nonexistent query 1208]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1932 with nonexistent query 1209]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1933 with nonexistent query 1210]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1934 with nonexistent query 1211]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1935 with nonexistent query 1212]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1940 with nonexistent query 1217]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1952 with nonexistent query 1227]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1956 with nonexistent query 1230]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1964 with nonexistent query 1237]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1966 with nonexistent query 1239]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1972 with nonexistent query 1243]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1974 with nonexistent query 1244]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1975 with nonexistent query 1245]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1985 with nonexistent query 1251]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1987 with nonexistent query 1253]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1994 with nonexistent query 1259]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1996 with nonexistent query 1261]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1997 with nonexistent query 1262]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1998 with nonexistent query 1263]
2023-06-24 17:34:24 [Removing orphaned note entry ID 1999 with nonexistent query 1264]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2004 with nonexistent query 1269]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2009 with nonexistent query 1274]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2013 with nonexistent query 1278]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2014 with nonexistent query 1279]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2026 with nonexistent query 1290]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2070 with nonexistent query 1323]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2078 with nonexistent query 1331]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2088 with nonexistent query 1336]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2089 with nonexistent query 1337]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2109 with nonexistent query 1354]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2113 with nonexistent query 1356]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2115 with nonexistent query 1358]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2118 with nonexistent query 1360]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2119 with nonexistent query 1361]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2121 with nonexistent query 1362]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2133 with nonexistent query 1369]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2137 with nonexistent query 1373]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2138 with nonexistent query 1374]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2139 with nonexistent query 1375]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2156 with nonexistent query 1384]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2161 with nonexistent query 1388]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2170 with nonexistent query 1392]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2171 with nonexistent query 1393]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2179 with nonexistent query 1400]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2189 with nonexistent query 1408]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2192 with nonexistent query 1411]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2197 with nonexistent query 1414]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2198 with nonexistent query 1415]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2199 with nonexistent query 1416]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2201 with nonexistent query 1418]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2205 with nonexistent query 1422]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2206 with nonexistent query 1423]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2210 with nonexistent query 1427]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2211 with nonexistent query 1428]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2212 with nonexistent query 1429]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2214 with nonexistent query 1431]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2216 with nonexistent query 1433]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2217 with nonexistent query 1434]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2221 with nonexistent query 1436]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2222 with nonexistent query 1437]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2224 with nonexistent query 1439]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2229 with nonexistent query 1443]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2236 with nonexistent query 1448]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2253 with nonexistent query 1458]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2258 with nonexistent query 1462]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2261 with nonexistent query 1465]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2271 with nonexistent query 1473]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2272 with nonexistent query 1474]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2273 with nonexistent query 1475]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2274 with nonexistent query 1476]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2277 with nonexistent query 1479]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2285 with nonexistent query 1484]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2289 with nonexistent query 1486]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2311 with nonexistent query 1497]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2312 with nonexistent query 1498]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2342 with nonexistent query 1521]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2345 with nonexistent query 1522]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2371 with nonexistent query 1536]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2373 with nonexistent query 1537]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2386 with nonexistent query 1549]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2389 with nonexistent query 1552]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2404 with nonexistent query 1563]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2423 with nonexistent query 1575]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2428 with nonexistent query 1578]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2434 with nonexistent query 1582]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2438 with nonexistent query 1586]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2441 with nonexistent query 1589]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2449 with nonexistent query 1594]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2462 with nonexistent query 1601]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2469 with nonexistent query 1605]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2471 with nonexistent query 1607]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2483 with nonexistent query 1613]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2489 with nonexistent query 1618]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2493 with nonexistent query 1621]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2522 with nonexistent query 1631]
2023-06-24 17:34:24 [Removing orphaned note entry ID 2524 with nonexistent query 1633]
2023-06-24 17:34:24 [migration: APP\migration\upgrade\v3_4_0\I6895_Institutions]
2023-06-24 17:34:24 [migration: APP\migration\upgrade\v3_4_0\I6782_OrphanedMetrics]
2023-06-24 17:34:28 [migration: PKP\migration\upgrade\v3_4_0\I6782_UsageStatsSettings]
2023-06-24 17:34:28 [migration: APP\migration\upgrade\v3_4_0\I6782_CreateNewMetricsTables]
2023-06-24 17:34:31 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsContext]
2023-06-24 17:34:32 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsIssue]
2023-06-24 17:34:33 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsSubmission]
2023-06-24 17:34:42 [migration: APP\migration\upgrade\v3_4_0\I6782_MetricsGeo]
2023-06-24 17:34:43 [migration: APP\migration\upgrade\v3_4_0\I6782_CleanOldMetrics]
2023-06-24 17:34:45 [migration: APP\migration\upgrade\v3_4_0\I6782_RemovePlugins]
2023-06-24 17:34:45 [migration: PKP\migration\upgrade\v3_4_0\I7286_BatchesMigration]
2023-06-24 17:34:45 [migration: APP\migration\upgrade\v3_4_0\I8151_ExtendSettingValues]
2023-06-24 17:34:45 [migration: PKP\migration\upgrade\v3_4_0\I8151_ExtendSettingValues]
2023-06-24 17:34:49 [migration: PKP\migration\upgrade\v3_4_0\I2890_EmailTemplatesVarcharLengthUpdate]
2023-06-24 17:34:50 [migration: PKP\migration\upgrade\v3_4_0\I2890_AddSetNullForOnDeleteToReviewRoundIdForeign]
2023-06-24 17:34:50 [migration: APP\migration\upgrade\v3_4_0\I7901_Duplicate_OAI_IDs]
2023-06-24 17:34:50 [migration: PKP\migration\upgrade\v3_4_0\I7366_UpdateUserAPIKeySettings]
2023-06-24 17:34:50 [migration: PKP\migration\upgrade\v3_4_0\I8093_UpdateUserGroupRelationTablesFK]
2023-06-24 17:34:50 [migration: APP\migration\upgrade\v3_4_0\I7725_DecisionConstantsUpdate]
2023-06-24 17:34:50 [migration: PKP\migration\upgrade\v3_4_0\I4789_AddReviewerRequestResentColumns]
2023-06-24 17:34:50 [migration: APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema]
2023-06-24 17:34:50 [migration: PKP\migration\upgrade\v3_4_0\I7287_RemoveEmailTemplatesDefault]
2023-06-24 17:34:50 [migration: APP\migration\upgrade\v3_4_0\I5716_EmailTemplateAssignments]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\InstallEmailTemplates]
2023-06-24 17:34:51 [migration: PKP\migration\upgrade\v3_4_0\I7874_NotificationMetadataModifiedRemove]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I7191_EditorAssignments]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I7191_InstallSubmissionHelpDefaults]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I7191_SubmissionChecklistMigration]
2023-06-24 17:34:51 [migration: PKP\migration\upgrade\v3_4_0\I7191_SubmissionProgressType]
2023-06-24 17:34:51 [migration: PKP\migration\upgrade\v3_4_0\I7191_ResubscribeSubeditors]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I8027_DoiVersioning]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I6306_EnableCategories]
2023-06-24 17:34:51 [migration: PKP\migration\upgrade\v3_4_0\I8592_SiteNotificationSubscriptions]
2023-06-24 17:34:51 [migration: APP\migration\upgrade\v3_4_0\I6241_RequiredGenres]
2023-06-24 17:34:52 [migration: APP\migration\upgrade\v3_4_0\I7128_SectionEntityDAORefactor]
2023-06-24 17:34:52 [migration: APP\migration\upgrade\v3_4_0\I7513_DoiSettings]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I7486_RenameUnconsideredColumnToConsidered]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I7486_RemoveItemViewsTable]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I8737_SectionEditorsUniqueIndexUpdate]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I8508_ConvertCurrentLogFile]
Invalid log entry at line 1.
Invalid log entry at line 2.
Invalid log entry at line 3.
Invalid log entry at line 4.
Invalid log entry at line 5.
Invalid log entry at line 6.
Invalid log entry at line 7.
Invalid log entry at line 8.
Invalid log entry at line 9.
Invalid log entry at line 10.
Invalid log entry at line 11.
Invalid log entry at line 12.
Invalid log entry at line 13.
Invalid log entry at line 14.
Invalid log entry at line 15.
Invalid log entry at line 16.
2023-06-24 17:34:52 [The old usage stats log file /home/seisense/ojsdatatest/usageStats/usageEventLogs/usage_events_20230624_old.log was successfully deleted.]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I8866_DispatchRegionCodesFixingJobs]
2023-06-24 17:34:52 [migration: APP\migration\upgrade\v3_4_0\I8992_FixEmptyUrlPaths]
2023-06-24 17:34:52 [migration: APP\migration\upgrade\v3_4_0\I9040_DropSettingType]
2023-06-24 17:34:52 [migration: PKP\migration\upgrade\v3_4_0\I9039_DropDeprecatedFields]
2023-06-24 17:34:52 [migration: APP\migration\upgrade\v3_4_0\I8933_EventLogLocalized]
2023-06-24 17:34:59 [revert migration: PKP\migration\upgrade\v3_4_0\I9039_DropDeprecatedFields]
2023-06-24 17:34:59 [downgrade for “PKP\migration\upgrade\v3_4_0\I9039_DropDeprecatedFields” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: Unsupported assoc_type in the event log: 515
[seisense@rs206 tools]$

asmecher · June 26, 2023, 3:18pm

Hi @seisense,

Would you be willing to provide us with a copy of your database for some local testing? If so, please send me a private message with details.

Regards,
Alec Smecher
Public Knowledge Project Team

D_S · June 26, 2023, 4:55pm

I can confirm that I am encountering the same error. I am upgrading from 3.3.0.14 to 3.4.0.1. Here is the error that I see

2023-06-26 16:28:49 [downgrade for "APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema" unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: Tried to install email template as an alternate to `DISCUSSION_NOTIFICATION_SUBMISSION`, but no default template exists with this key.

If I execute sudo php tools/upgrade.php upgrade again, I get the following error:

2023-06-26 16:53:56 [migration: APP\migration\upgrade\v3_4_0\PreflightCheckMigration]
2023-06-26 16:53:57 [A pre-flight check failed. The software was successfully upgraded to 3.3.9.9 but could not be upgraded further (to 3.4.0.1). Check and correct the error, then try again.]
ERROR: Upgrade failed: DB: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at.assoc_type' in 'where clause' (SQL: select distinct `at`.`type_id` from `announcement_types` as `at` left join `journals` as `c` on `at`.`assoc_id` = `c`.`journal_id` where `c`.`journal_id` is null or `at`.`assoc_type` <> 256)

asmecher · June 26, 2023, 11:43pm

Hi @D_S,

The problem @seisense is reporting comes down to this error message:

 [18-Jun-2023 19:56:56 UTC] Unsupported assoc_type in the event log: 515

I don’t see that message in your posts; it seems like you’re encountering a different problem. If so, do you mind posting this in a new topic? That’ll help keep the forum organized.

Regards,
Alec Smecher
Public Knowledge Project Team

D_S · June 27, 2023, 12:54am

Hi Alec. Sure. Thank you for taking the time to respond.

Awal_Yusoff · June 27, 2023, 8:18pm

Hello, I am also encountering the same problem

A database error has occurred: Unsupported assoc_type in the event log: 515

using PHP 8.0 if that’s any help

Kind regards
Awal

asmecher · June 27, 2023, 9:05pm

Hi all,

See Unsupported assoc_type in the event log: 515 · Issue #9121 · pkp/pkp-lib · GitHub for details and a patch. I’m not sure what combination of environments causes this, but it appears to depend on the server environment. In any case, the patch fixes it.

Regards,
Alec Smecher
Public Knowledge Project Team

Awal_Yusoff · June 28, 2023, 9:45pm

apologies, i looked at the wrong folder

Awal_Yusoff · June 29, 2023, 7:41pm

confirmed that it works

keep getting into problems afterwards but managed to get into 3.4 finally. but theres lack of plugins that we use, so reverting back to 3.3.0.14.

will keep eyeing the plugin list and thank you for your help

kind regards
Awal

asmecher · June 29, 2023, 8:19pm

Hi @Awal_Yusoff,

Glad you made it further along.

Are there any particular plugins you’re waiting for?

(By the way, there’s a public view of plugin compatibility available here.)

Thanks,
Alec Smecher
Public Knowledge Project Team

Awal_Yusoff · June 30, 2023, 9:10am

Haha yeah, its a struggle but now I know how to manipulate databases thanks to OJS

And Thank you for the link, I’ve bookmarked it.

Just waiting for PKP Pn to be compatible, as I see all the rest has

Kindest regards
Awal

Alfonso_Fernandez · July 7, 2023, 7:18am

I’m having the same problem but I cannot find the thread

2023-07-07 01:09:45 [downgrade for “APP\migration\upgrade\v3_4_0\I7796_UpdateCrossrefSchema” unsupported: Downgrade not supported]
ERROR: Upgrade failed: DB: Tried to install email template as an alternate to DISCUSSION_NOTIFICATION_SUBMISSION, but no default template exists with this key.

asmecher · July 10, 2023, 3:00pm

This topic was automatically closed after 12 days. New replies are no longer allowed.