Migrating generates an error with the database Topic is solved

[DominikReber]

Hello.
I am trying to migrate our (old) joomla installation from 3 to 4 (and then 5).
We have a lot of plugins/components, I did deactivate them all before updating.

While updating I get an error and this is the log:

Code: Select all

2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	Start of SQL updates.
2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	The current database version (schema) is 3.10.7-2022-03-18.
2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	Abfrage von Datei „4.0.0-2018-03-05“. Abfrage: „ALTER TABLE `#__extensions` DROP COLUMN `system_data` ;“.
2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	Abfrage von Datei „4.0.0-2018-03-05“. Abfrage: „INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `“.
2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	JInstaller: :Install: SQL-Fehler Field 'extra_params' doesn't have a default value
2024-12-03T10:02:01+00:00	INFO 37.203.250.49	update	End of SQL updates - INCOMPLETE.

page itself shows the
500 - Whoops, looks like something went wrong.

While searching the web I got the hint to recreate the _extension-table, which I did. but then I get an error that other (like _workflow) tables do not exist - think because the migration did not complete.

I have backups so no problem but does anyone know what to do?

Thanks

Dominik

[DominikReber]

This was the warning I got at the end of the migration:

Code: Select all

Warnung
JInstaller: :Install: SQL-Fehler Field 'extra_params' doesn't have a default value
×
danger
Table 'mydatabase.2020_history' doesn't exist
Table 'mydatabase.2020_workflows' doesn't exist
Table 'mydatabase.2020_workflow_stages' doesn't exist
Table 'mydatabase.2020_workflow_transitions' doesn't exist
Table 'mydatabase.2020_mail_templates' doesn't exist
Table 'mydatabase.2020_guidedtours' doesn't exist
Table 'mydatabase.2020_user_mfa' doesn't exist

[Per Yngve Berg]

Have you run System->Database->Repair?

[DominikReber]

Hi and thanks for your answer.

No, but I have set the default value of extra_params in _extensions and _modules to "NULL" before upgrading and that did fix it!