Joomla\CMS\Installer\InstallerScript::getInstances Unknown column 'id' in 'field list'

[svanschu]

In this method it tries to load the field 'id' from the extensions table. But there isn't any field called id in this table.

The id field for the extenions table is called extension_id

        // Select the item(s) and retrieve the id
        $query->select($db->quoteName('id'));

        if ($isModule) {
            $query->from($db->quoteName('#__modules'))
                ->where($db->quoteName('module') . ' = :extension');
        } else {
            $query->from($db->quoteName('#__extensions'))
                ->where($db->quoteName('element') . ' = :extension');
        }

It would need to look like

        // Select the item(s) and retrieve the id
       
        if ($isModule) {
            $query->select($db->quoteName('id'))
                  ->from($db->quoteName('#__modules'))
                ->where($db->quoteName('module') . ' = :extension');
        } else {
            $query->select($db->quoteName('extension_id') . ' as id')
                ->from($db->quoteName('#__extensions'))
                ->where($db->quoteName('element') . ' = :extension');
        }

[svanschu]

I'm working on it and will prepare a PR

[svanschu]

Fixed in PR #42192

[svanschu]

PR #42199