Problem when updating from Joomla 3.10.11 to 4.4.8

[mastalnise]

hello
I encountered a problem when updating from Joomla 3.10.11 to 4.4.8.

warning
JInstaller: :installation: Error SQL Field 'extra_params' doesn't have a default value
x
danger
Table 'ahan.tp655_history' does not exist
Table 'ahan.tp655_workflows' does not exist
Table 'ahan.tp655_workflow_stages' doesn't exist
Table 'ahan.tp655_workflow_transitions' doesn't exist
Table 'ahan.tp655_mail_templates' does not exist
Table 'ahan.tp655_guidedtours' doesn't exist
Table 'ahan.tp655_user_mfa' doesn't exist
Update status of Joomla version
Attention The update completed with errors. Please examine the update logs C:/xampp/htdocs/ahan/administrator/logs/joomla_update.php for more details.
It is recommended to restore the site from backup, fix the issues that caused the update failure and try to update again.
You can always ask for help on Joomla! forum https://forum.joomla.org/
Back to control panel

Brief list of captured errors
installer::parseSchemaUpdates finished with "false" result.

The content of the logs/joomla_update.php file

#
#
#<?php die('Forbidden.'); ?>
#Date: 2024-08-28 06:09:41 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: datetime priority clientip category message
2024-08-28T06:09:41+00:00 INFO ::1 update The installation of the new version has started.
2024-08-28T06:10:56+00:00 INFO ::1 update The installation is finished.
2024-08-28T06:10:56+00:00 INFO ::1 update Start of SQL updates.
2024-08-28T06:10:56+00:00 INFO ::1 update The current database version (schema) is 3.10.7-2022-03-18.
2024-08-28T06:10:56+00:00 INFO ::1 update Query execution from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__extensions` DROP COLUMN `system_data` ;.
2024-08-28T06:10:56+00:00 INFO ::1 update Query execution from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `.
2024-08-28T06:10:56+00:00 INFO ::1 update JInstaller: :installation: error SQL Field 'extra_params' doesn't have a default value
2024-08-28T06:10:56+00:00 INFO ::1 update End of SQL updates - INCOMPLETE.
2024-08-28T06:10:56+00:00 WARNING ::1 jerror JInstaller: :installation: Error SQL Field 'extra_params' doesn't have a default value
2024-08-28T06:10:56+00:00 ERROR ::1 update An error has occurred while running "installer::parseSchemaUpdates". Code: 0. Message: installer::parseSchemaUpdates finished with "false" result..
2024-08-28T06:10:57+00:00 INFO ::1 update Clean after installation.
2024-08-28T06:10:57+00:00 INFO ::1 update The update to version 4.4.8 is complete.

[AMurray]

try updating from 3.10.12 - the latest 3.10.x release.

Did you ensure everything as per the upgrade check was up to date - e.g. extensions, templates and so forth?

[mastalnise]

It still gives the same error message

[gws]

Did you restore a backup?

[mastalnise]

Hi
yes I have a backup. Easily updated from 3.10.1 to 3.10.12. But when I migrate to version 4.8, it gives this error message.
I tried the migration several times to different versions of Joomla 4. But the result is the same.

[gws]

Do you know you have to empty the joomla root of files and empty the database before you restore a backup?

[mastalnise]

My problem is not restore. My problem is migrating to Joomla 4 and 5.
I have a website on Joomla 3 and I want to migrate first to Joomla 4 and then to Joomla 5.
I know that I need to disable all third-party (non-Joomla) extensions for migration. I have migrated many websites, but I have a problem with this one.

[gws]

Your problem may well be restore. After a failed update you can NOT restore a site if you do not empty the joomla directory and empty the database. If you have done this then the problem is not restore.

[Webdongle]

+1 @gws

[AMurray]

+1 @gws

Also, what PHP are you running on XAMPP? Joomla 3.10 only works up to PHP 8 or 8.1 possibly. If you're using 8.2. or 8.3 it may cause problems.

I would recommend WAMPServer, rather than XAMPP because you're tied to the one shipped version of PHP with XAMPP where WAMPServer allows you to install multiple versions of PHP and switch them easily. Install WAMPServer (https://wampserver.aviatechno.net/?lang=en) and install for example PHP 8.0 and 8.1 (it should come with 8.3), and then you can switch as you need to. The module downloads are on the same page as the main WAMPServer application.

The same with MySQL or Maria DB - you can ensure you have at least the minimum required versions, and then perhaps test with later versions (which will then depend on what your host offers).

[mastalnise]

The PHP version is 7.4 and I previously migrated other websites with the same specifications from Joomla 3 to Joomla 4.