### Steps to reproduce the issue

• install a plugin which has it's own table in the database and uses update -> schemas
• I've created a simple plugin 'Visforms - Limit number of submissions' for this purpose, but I cannot upload the installation here, due to 'file type of zip is not allowed'. I can mail it, if you like to
• go to System >> Maintenance: Database
• Database check for the entry 'Visforms - Limit number of submissions' shows "No Problems"
• Select entry for 'Visforms - Limit number of submissions'
• Click 'Update Structure'
  I've attached some screenshots which show the problem

Expected result

Still 'No Problems' with the data table structure

Actual result

Result for 'Visforms - Limit number of submissions' shows 'One Problem'

System information (as much as possible)

Tested with php7.4 and 8.0 on different environments
Clean Joomla 4.0 and 4.1 with no additional extensions except the plugin

Additional comments

The problem is cause by by the function fixUpdateVersion in administrator/components/com_installer/src/Model/DatabaseModel.php on line 635ff which does not take into account, that the path to a plugin and it's installation manifest xml is more complex and different form components. (Same statement would be correct for modules, by the way)
As a result, the installation manifest file is not found and the value of the 'version' property in the 'manifest_cache' of the plugin in the table #__extensions is actively and wrongly set to an mpty string.

I've tested the following fix, which seems to work fine.

File: administrator/components/com_installer/src/Model/DatabaseModel.php
After Line 646: Add custom code for plugin, which store there installationXML files in subfolders and under JPATH_SITE
else if ($table->get('type') === 'plugin') {
$installationXML = InstallerHelper::getInstallationXML($table->get('element'), $table->get('type'), 0, $table->get('folder'));
$extensionVersion = (string) $installationXML->version;
}
A quick fix would be highly appreciated. A correct version value in the the 'manifest_cache' is really important and an invalid or empty value can really crash the installation/update process of extensions.