Database Structure errors #39
Description
Steps to reproduce the issue
Install https://update.joomla.org/tuftest/Joomla_5.4.103-Stable-Full_Package.zip
BEFORE going to the admin go to the database and change the value for version_id in the #__schemas table to a lower number eg 5.3.0-2025-05-10
(This is to trigger a database structure mismatch in system>database)
Log in
Observe that it says Automated Updates are enabled
Wait ten minutes to see if Joomla is updated
Check the joomla_update logs
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update The current database version (schema) is 5.3.0-2025-05-10.
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Ran query from file 5.4.0-2025-04-23. Query text: INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, .
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Ran query from file 5.4.0-2025-05-09. Query text: UPDATE `#__update_sites` SET `type` = 'tuf', `location` = 'https://update.joomla.
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Ran query from file 5.4.0-2025-05-10. Query text: INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, .
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Ran query from file 5.4.0-2025-05-10. Query text: INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, .
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Ran query from file 5.4.0-2025-05-10. Query text: INSERT INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subjec.
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update JInstaller: :Install: Error SQL Duplicate entry 'com_joomlaupdate.update.success-' for key 'PRIMARY'
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update End of SQL updates - INCOMPLETE.
2025-05-15T17:52:13+00:00 WARNING 3.141.31.142 jerror JInstaller: :Install: Error SQL Duplicate entry 'com_joomlaupdate.update.success-' for key 'PRIMARY'
2025-05-15T17:52:13+00:00 ERROR 3.141.31.142 update An error has occurred while running "installer::parseSchemaUpdates". Code: 0. Message: installer::parseSchemaUpdates finished with "false" result..
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Cleaning up after installation.
2025-05-15T17:52:13+00:00 INFO 3.141.31.142 update Update to version 5.4.104 is complete.
Check System>Database - still says database structure is incorrect
Additional comments
The problem would not occur with a manual joomla update as the database schema error prevents you from updating Joomla until it is fixed
Expected Behaviour
Automated Update does not take place because of the schema problem
Email is sent saying that there is a new version of joomla available but it could not be installed because of ...