Sometimes the native Joomla uninstaller medthod does not successfully remove all of a component’s data. If this happens, you may need to manually remove the component from your database. To avoid errors, make sure you…
Sometimes the native Joomla uninstaller medthod does not successfully remove all of a component’s data. If this happens, you may need to manually remove the component from your database. To avoid errors by doing this, make sure you understand the fundamentals of MySQL.
To remove a Joomla component’s data in MySQL, run these queries.
-- Run these queries in your phpMyAdmin -- Manual removal com_EXTENSION_NAME from Joomla! database -- Change the #__ to your Joomla! prefix, e.g. #__extensions to jos_extensions DELETE FROM `jos_schemas` WHERE `extension_id` = (SELECT `extension_id` FROM `jos_extensions` WHERE `type` = 'component' AND `name` = 'com_EXTENSION_NAME'); DELETE FROM `jos_extensions` WHERE `name` = 'com_EXTENSION_NAME'; DELETE FROM `jos_assets` WHERE `name` = 'com_EXTENSION_NAME'; DELETE FROM `jos_menu` WHERE `type` = 'component' AND `title` LIKE '%com_EXTENSION_NAME%'; DELETE FROM `jos_session` WHERE `data` LIKE '%com_EXTENSION_NAME%';
Also, it is important to check for component-specific files and folders that may remain on the server when you remove a component manually. In this case, you must manually remove these files and folders. For example, if you want to remove a component, delete these folders:
components/com_EXTENSION_NAME administrator/components/com_EXTENSION_NAME media/com_EXTENSION_NAME
And delete the following files
language/en-GB/en-GB.com_EXTENSION_NAME.ini language/en-GB/en-GB.com_EXTENSION_NAME.sys.ini administrator/language/en-GB/en-GB.com_EXTENSION_NAME.ini administrator/language/en-GB/en-GB.com_EXTENSION_NAME.sys.ini