Done !
| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/zenit/administrator/components/com_admin/sql/updates/mysql/ |
Upload File : |
--
-- Delete the com_search package extension including its update site if no other
-- com_search extension exists
--
DELETE FROM `#__update_sites_extensions`
WHERE `update_site_id` IN (SELECT `update_site_id` FROM `#__update_sites` WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml')
AND `extension_id` IN (SELECT `extension_id` FROM `#__extensions` WHERE `element` = 'pkg_search' AND `type` = 'package')
AND (SELECT COUNT(a.`extension_id`)
FROM `#__extensions` a
WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
) = 0;
DELETE FROM `#__update_sites`
WHERE `location` = 'https://raw.githubusercontent.com/joomla-extensions/search/main/manifest.xml'
AND (SELECT COUNT(a.`extension_id`)
FROM `#__extensions` a
WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
) = 0;
DELETE FROM `#__extensions`
WHERE `type` = 'package' AND `element` = 'pkg_search'
AND (SELECT b.`count`
FROM (SELECT COUNT(a.`extension_id`) AS `count`
FROM `#__extensions` a
WHERE (a.`type` = 'component' AND a.`element` = 'com_search')
OR (a.`type` = 'module' AND a.`element` = 'mod_search' AND a.`client_id` = 0)
OR (a.`type` = 'plugin' AND a.`element` IN ('categories', 'contacts', 'content', 'newsfeeds', 'tags') AND a.`folder` = 'search')
) b
) = 0;