@alikon To me it seems that you are checking the database not only for the core but also for 3rd party extensions because you are using the complete changeset here: https://github.com/joomla/joomla-cms/pull/40468/files#diff-a88763fd45c8c476369964c9857883558ccbe56672b2304d651f9a583225cc20R418

But for the pre-update check only the core shall be checked. Therefore it filters for the extension if of the core (joomla files) and then uses only the first element of the changesets araay here:

You have to do it in the same way.

@alikon P.S.: You can easily check that by installing a 3rd party extension which has update SQL scripts and then modify one of these scripts so it causes an error for that extension in the database checker. Your code here will report this as a schema error and block the update, the pre-update checker in the update component will not do that (as long as the schema check for the CMS core is ok).

I have tested this item ✅ successfully on 922dcb3

I've successfully tested that this PR adds a check for database schema errors of the CMS to the cli updater which works the same way as the check for the database schema in the pre-update check of the Joomla Update component in the required settings part.

For testing I have added the following SQL to one of the core's update SQL scripts:

CREATE TABLE IF NOT EXISTS `#__foobar` (
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;

And I have done the same but with a different table name with the update SQL script 4.0.0.sql of the patchtester.

Then I have patched the Version.php file so that an update was found, and then I have run the CLI core updater.

Result: The CLI updater reports the schema errors for the CMS but not for the Patchterster, and the update is refused.

Then I have fixed the database error for the core and run again the CLI updater.

Result: The update succeeded, the database schema errors of the Patchtester has been ignored like it should be.

I don't know if the way how the error messages are shown or some language strings need improvement. Maybe @brianteeman can have a look.

I have tested this item ✅ successfully on 9f07bb3

Tested on Joomla 4.3.4 @localhost PBF 2023

RTC

Thanks Nicola @alikon for the PR