If you are having problems with your Joomla site and need to manually uninstall the Zap Calendar component, use these commands in phpMyAdmin. A backup is HIGHLY RECOMMENDED prior to running these commands. In addition, the folders "components/com_zcalendar" and "administrator/components/com_zcalendar" need to be removed from your Joomla site.
There are two groups of commands listed here: one to remove the Zap Calendar component and the other to remove the Zap Calendar data. You can run the first group of commands only and the event data will still be available after a re-install of Zap Calendar. You will need to change "#" in the commands to the Joomla prefix for your site. Also, this procedure does not remove any of the Zap Calendar modules or plugins.
For Joomla 3 / Zap Calendar 4
-- Caution: For experts only -- For Joomla 3 / Zap Calendar 4 Databases -- ** WARNING: This will delete Zap Calendar component data -- Change '#' to your Joomla prefix ( i.e. #_extensions -> jos_extensions ) DELETE FROM `#_schemas` WHERE `extension_id` = (SELECT `extension_id` FROM `#_extensions` WHERE `type` = 'component' AND `name` = 'com_zcalendar'); DELETE FROM `#_extensions` WHERE `name` = 'com_zcalendar'; DELETE FROM `#_assets` WHERE `name` LIKE 'com_zcalendar%'; DELETE FROM `#_menu` WHERE `type` = 'component' AND `title` LIKE '%com_zcalendar%'; DELETE FROM `#_session` WHERE `data` LIKE '%com_zcalendar%';
Use these commands to remove the data (all events, categories, locations and calendars)
-- Caution: For experts only -- For Joomla 3 / Zap Calendar 4 Databases -- ** WARNING: This will delete Zap Calendar event data -- Change '#' to your Joomla prefix ( i.e. #_extensions -> jos_extensions ) DELETE FROM `#_assets` WHERE `name` LIKE 'com_zcalendar%'; DROP TABLE `#_zcalendar_calendars`; DROP TABLE `#_zcalendar_event_categories`; DROP TABLE `#_zcalendar_events`; DROP TABLE `#_zcalendar_categories`; DROP TABLE `#_zcalendar_locations`; DROP TABLE `#_zcalendar_guests`;
For Joomla 2.5 / Zap Calendar 3
-- Caution: For experts only -- For Joomla 2.5 / Zap Calendar 3 Databases -- ** WARNING: This will delete Zap Calendar component data -- Change '#' to your Joomla prefix ( i.e. #_extensions -> jos_extensions ) DELETE FROM `#_schemas` WHERE `extension_id` = (SELECT `extension_id` FROM `#_extensions` WHERE `type` = 'component' AND `name` = 'com_zcalendar'); DELETE FROM `#_extensions` WHERE `name` = 'com_zcalendar'; DELETE FROM `#_assets` WHERE `name` = 'com_zcalendar'; DELETE FROM `#_menu` WHERE `type` = 'component' AND `title` LIKE '%com_zcalendar%'; DELETE FROM `#_session` WHERE `data` LIKE '%com_zcalendar%';
Use these commands to remove the data (all events, categories, locations and calendars)
-- Caution: For experts only -- For Joomla 2.5 / Zap Calendar 3 Databases -- ** WARNING: This will delete Zap Calendar event data -- Change '#' to your Joomla prefix ( i.e. #_extensions -> jos_extensions ) DELETE FROM `#_assets` WHERE `name` LIKE 'com_zcalendar%'; DROP TABLE `#_zcalendar_views`; DROP TABLE `#_zcalendar_event_categories`; DROP TABLE `#_zcalendar_events`; DROP TABLE `#_zcalendar_categories`; DROP TABLE `#_zcalendar_locations`; DROP TABLE `#_zcalendar_guests`;
DROP TABLE `#_zcalendar_config`;