Issue updating 2.4.8.5 to 3.1.2.4

HI, im upgrading OJS from 2.4.8.5 to 3.1.2.4 when goes to

[pre-install]
[load: upgrade.xml]
[version: 3.1.2.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]
[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]

[code: Installer Installer::migrateStaticPagesToNavigationMenuItems]

[code: Installer Installer::migrateSRLocale]

[code: Installer Installer::migrateUserAndAuthorNames]

[code: Installer Installer::concatenateIntoAbout]

[code: Installer Installer::concatenateIntoMasthead]

[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]
[data: dbscripts/xml/upgrade/3.0.0_update.xml]

[code: Installer Installer::clearDataCache]

[code: Installer Installer::migrateUserRoles]

[code: Installer Installer::fixReviewForms]

[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]

[code: Installer Installer::convertEditorDecisionNotes]

[code: Installer Installer::convertQueries]

[code: Installer Installer::migrateFiles]

[code: Installer Installer::convertSupplementaryFiles]

DB Error: Data too long for column 'label' at row 1

I have been editing dbscripts/xml/ojs_schema.xml as suggest OJS Upgrade failed 2.4.8-1 to 3.0.0 - #9 by asmecher but still have same error

You can use OJS 3.2.1-4 for migration from OJS 2.4. Last time I tried to upgrade and was successful. We have to use PHP7.2 for OJS 3.2.1-4.

i have try to use OJS 3.2.1-4 and get another error

[20-Dec-2022 02:51:04 UTC] PHP Fatal error:  Uncaught Exception: DB Error: Field 'file_id' doesn't have a default value Query: INSERT INTO submission_galleys (locale, submission_id, remote_url, label) VALUES (?, ?, ?, ?) in D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php:703
Stack trace:
#0 D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), 'INSERT INTO sub...')
#1 D:\unida3\jurnal_ojs_3\classes\install\Upgrade.inc.php(1096): DAO->update('INSERT INTO sub...', Array)
#2 D:\unida3\jurnal_ojs_3\lib\pkp\classes\install\Installer.inc.php(417): Upgrade->convertSupplementaryFiles(Object(Upgrade), Array)
#3 D:\unida3\jurnal_ojs_3\lib\pkp\classes\install\Installer.inc.php(263): Installer->executeAction(Array)
#4 D:\unida3\jurnal_ojs_3\lib\pkp\classes\install\Installer.inc.php(186): Installer->executeInstaller()
#5 D:\unida3\jurnal_ojs_3\lib\pkp\classes\cliTool\UpgradeTool.inc.php(88): Installer->execute()
#6 D:\unida3\jurnal_ojs_3\lib\pkp\classes\cliTool\UpgradeTool.inc.php(64): UpgradeTool->upgrade()
#7 D:\u in D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php on line 703

i fix the error by activating php gettext extention then get another error

[20-Dec-2022 05:02:17 UTC] ERROR: Reviewer files with ID 6122 from review assignment 660 could not be found in the database table submission_files
[20-Dec-2022 05:02:19 UTC] ERROR: Reviewer files with ID 7976 from review assignment 958 could not be found in the database table submission_files
[20-Dec-2022 05:02:21 UTC] ERROR: Reviewer files with ID 8960 from review assignment 1155 could not be found in the database table submission_files
[20-Dec-2022 05:02:22 UTC] ERROR: Reviewer files with ID 9630 from review assignment 1272 could not be found in the database table submission_files
[20-Dec-2022 05:02:37 UTC] ERROR: Reviewer files with ID 17241 from review assignment 2361 could not be found in the database table submission_files
[20-Dec-2022 05:05:35 UTC] PHP Fatal error:  Uncaught Exception: DB Error: Incorrect string value: '\xD9\x82\xD8\xB1\xD8\xA7...' for column 'subject' at row 1 Query: INSERT INTO email_templates_default_data
						(email_key, locale, subject, body, description)
						VALUES
						('EDITOR_DECISION_INITIAL_DECLINE', 'ar_IQ', 'قرار المحرر', '\n			{$authorName}:<br />\n<br />\nلقد توصلنا إلى قرار بشأن طلبك للنشر في {$contextName}، &quot;{$submissionTitle}&quot;.<br />\n<br />\nإن قرارنا هو: رفض النشر', 'هذه الرسالة تعنون إلى المؤلف إذا رفض المحرر طلبه بشكل مبدئي قبل الدخول في مرحلة التحكيم') in D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php:703
Stack trace:
#0 D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php(231): DAO->handleError(Object(ADODB_mysqli), 'INSERT INTO ema...')
#1 D:\unida3\jurnal_ojs_3\lib\pkp\classes\mail\EmailTemplateDAO.inc.php(270): DAO->update('INSERT INTO ema...')
#2 D:\unida3\jurnal_ojs_3\lib\pk in D:\unida3\jurnal_ojs_3\lib\pkp\classes\db\DAO.inc.php on line 703
[20-Dec-2022 05:58:54 UTC] PHP Fatal error:  Uncaught  --> Smarty: unable to write file D:\unida3\jurnal_ojs_3\cache\t_compile\13376d7934b5f251160733e5e3c8b2ff6a1e1f24^8e26d4d5b957a6848a96c58ac27d2fddb2c40f9a_0.app.installinstall.tpl.php <-- 
  thrown in D:\unida3\jurnal_ojs_3\lib\pkp\lib\vendor\smarty\smarty\libs\sysplugins\smarty_internal_runtime_writefile.php on line 90
1 Like