Upgrade quit without an error

upgradeing from 2.4.8 to 3.2.1-4
OS: RHEL 7.9
PHP 7.3
MariaDB
EC2 connect to RDS DB. (remote DB)

Always stops at [code: Installer Installer::convertEditorDecisionNotes]

then no error shown, upgrade stopped.

Been run the same upgrade on a ubuntu server with mysql 5.7 , php 7.4 without an error. This one uses a local DB

Details logs here:

[pre-install]
[load: upgrade.xml]
[version: 3.2.1.4]

[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]
[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]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_review_assignments.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_notes.xml]
[data: dbscripts/xml/upgrade/3.1.0_preupdate_payments.xml]
[data: dbscripts/xml/upgrade/3.1.1_preupdate_citations.xml]
[data: dbscripts/xml/upgrade/3.1.2_preupdate_user_author_names.xml]

[code: Installer Installer::migrateSubmissionCoverImages]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_email_templates.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning_articleGalleySettings.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_versioning.xml]
[data: dbscripts/xml/upgrade/3.2.0_preupdate_last_activity.xml]
[data: dbscripts/xml/upgrade/3.2.1_preupdate_subeditor_categories.xml]
[schema: lib/pkp/xml/schema/common.xml]
[schema: lib/pkp/xml/schema/log.xml]
[schema: lib/pkp/xml/schema/announcements.xml]
[schema: lib/pkp/xml/schema/scheduledTasks.xml]
[schema: lib/pkp/xml/schema/temporaryFiles.xml]
[schema: lib/pkp/xml/schema/metadata.xml]
[schema: lib/pkp/xml/schema/reviews.xml]
[schema: lib/pkp/xml/schema/reviewForms.xml]
[schema: lib/pkp/xml/schema/controlledVocab.xml]
[schema: lib/pkp/xml/schema/submissions.xml]
[schema: lib/pkp/xml/schema/submissionFiles.xml]
[schema: lib/pkp/xml/schema/categories.xml]
[schema: lib/pkp/xml/schema/notes.xml]
[schema: lib/pkp/xml/schema/genres.xml]
[schema: lib/pkp/xml/schema/tombstone.xml]
[schema: lib/pkp/xml/schema/rolesAndUserGroups.xml]
[schema: lib/pkp/xml/schema/metrics.xml]
[schema: lib/pkp/xml/schema/views.xml]
[schema: lib/pkp/xml/schema/libraryFiles.xml]
[schema: lib/pkp/xml/schema/navigationMenus.xml]
[schema: dbscripts/xml/ojs_schema.xml]
[data: dbscripts/xml/indexes.xml]

[code: Installer Installer::installDefaultNavigationMenus]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::migrateSRLocale]

[code: Installer Installer::migrateUserAndAuthorNames]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::concatenateIntoAbout]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Warning: Cannot use a scalar value as an array in /var/www/html/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
PHP Notice: unserialize(): Error at offset 86 of 120 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 92 of 9164 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 6314 of 10467 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 80 of 1066 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 68 of 2408 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 449 of 451 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Warning: Cannot use a scalar value as an array in /var/www/html/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 57 of 2188 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 71 of 118 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 8464 of 8507 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 81 of 1023 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 81 of 1080 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 67 of 262 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 61 of 911 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::concatenateIntoMasthead]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Warning: Cannot use a scalar value as an array in /var/www/html/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
PHP Notice: unserialize(): Error at offset 86 of 120 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 92 of 9164 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 6314 of 10467 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 80 of 1066 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 68 of 2408 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 449 of 451 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Warning: Cannot use a scalar value as an array in /var/www/html/lib/pkp/classes/db/SettingsDAO.inc.php on line 35
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 57 of 2188 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 71 of 118 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 8464 of 8507 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 81 of 1023 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 81 of 1080 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 67 of 262 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 61 of 911 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::migrateCounterPluginUsageStatistics (skipped)]

[code: Installer Installer::migrateTimedViewsUsageStatistics (skipped)]

[code: Installer Installer::migrateDefaultUsageStatistics (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postUsageStatsMigration2.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postCounterMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/2.4.0_postTimedViewsMigration.xml (skipped)]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type.xml]
[data: dbscripts/xml/upgrade/3.0.0_change_assoc_type_metrics.xml]
[data: dbscripts/xml/upgrade/3.0.0_settings.xml]

[code: Installer Installer::installDefaultGenres]

[code: Installer Installer::migrateArticleMetadata]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
[data: dbscripts/xml/upgrade/3.0.0_update.xml]

[code: Installer Installer::clearDataCache]

[code: Installer Installer::migrateUserRoles]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::fixReviewForms]
PHP Notice: unserialize(): Error at offset 159 of 304 bytes in /var/www/html/classes/install/Upgrade.inc.php on line 763
PHP Warning: Invalid argument supplied for foreach() in /var/www/html/classes/install/Upgrade.inc.php on line 765
PHP Notice: unserialize(): Error at offset 159 of 304 bytes in /var/www/html/classes/install/Upgrade.inc.php on line 763
PHP Warning: Invalid argument supplied for foreach() in /var/www/html/classes/install/Upgrade.inc.php on line 765

[code: Installer Installer::htmlifyEmailTemplates]
[note: docs/release-notes/README-BEACON]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]

[code: Installer Installer::installEmailTemplate]
[data: dbscripts/xml/upgrade/3.0.0_scheduledTasks.xml]

[code: Installer Installer::localizeCustomBlockSettings]
PHP Notice: unserialize(): Error at offset 593 of 1037 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 625 of 1555 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1064 of 1240 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 324 of 1477 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 1028 of 2278 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 208 of 2392 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357
PHP Notice: unserialize(): Error at offset 40 of 214 bytes in /var/www/html/lib/pkp/classes/db/DAO.inc.php on line 357

[code: Installer Installer::convertEditorDecisionNotes]

hi @mapress888 ,
I am currently migrating 2.4.x to 3.2x and have found a few things that I identified, corrected and have never had a problem again:

  • The name of the custom blocks must be without spaces or special characters, preferably a single word
  • The above also applies to custom page names, form names, etc.
  • In my case, I had to change the database collation to uft8_general_ci because that unserialize() errors breaks the installation. (maybe this is something you have to check)
  • In the case of the Editor’s decisions, a magazine had inconsistencies (a reviewer that never answered, unrealized confirmations, expired decisions, etc) I just corrected those records and that’s it, it no longer showed an error.

I hope something useful.

Thanks for the help @dagosalas . Can you kindly tell me how can you achieve “correct those records of Editor’s decisions” from the database? i am not able to login to editor panel anymore.

Well, I didn’t do it from the database, I did it from the original site (updates I do first as tests before touching the original site). And with the Editor account I finalized some omissions that the original editor left incomplete.
And basically I checked the table review_assignments, listed the elements with the recommendation field with NULL value, and those records were the ones I corrected.
That was in my case.

good luck

Thanks for your reply. i’ve tried all three but seems not working. but still thanks for sharing.

this is very odd as i do not see other people posting anything like this - upgrade exit without throw a php error. i now end up with migrate from current environment to a complete new - we have 800gb files to transfer!

Hi @mapress888,

If the upgrade stops cold, without an error message, make sure a message hasn’t been logged somewhere else. The most common place will be your PHP error log, but it could also be your system error log (if e.g. there was a system wide out-of-memory error), etc. Unfortunately the details will depend on your system so it’s hard to give more concrete instructions.

Regards,
Alec Smecher
Public Knowledge Project Team

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