So, phpMyAdmin is actually a really simple and very useful tool. Access it from your cPanel and you'll see your database(s) in the left hand side column. If you see "information_schema" etc, you're at top level, so you need to navigate to your database by clicking on it's name. If you're not sure what it is, open your /public_html/includes/configure.php and check what it says under DB_NAME.
Before you continue, go to the bottom of the post and read the important note.
Once you've opened your database, you'll see a bunch of tables on the right hand side, most likely starting with address_book, address_format etc. Now, one important thing here - check for prefix. It could start with zen_address_book, zc_address_book or anything alike - the part before address_book is your prefix. Next, click on the SQL tab above and paste the query:
Code:
SET @ZXconfig=0;
SELECT @ZXconfig:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'ZX Slideshow' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @ZXconfig;
DELETE FROM configuration_group WHERE configuration_group_id = @ZXconfig;
DELETE FROM admin_pages WHERE page_key = 'configZXSlideshow';
If, and ONLY IF, your tables have prefixes, you'd need to update the query to:
Code:
SET @ZXconfig=0;
SELECT @ZXconfig:=configuration_group_id FROM zen_configuration_group WHERE configuration_group_title= 'ZX Slideshow' LIMIT 1;
DELETE FROM zen_configuration WHERE configuration_group_id = @ZXconfig;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @ZXconfig;
DELETE FROM zen_admin_pages WHERE page_key = 'configZXSlideshow';
Of course, use the prefix that matches your tables.
Run the query and that's it.
IMPORTANT NOTE: remember to BACKUP your database before running ANY SQL patches. I take no responsibility if you don't do a proper backup and something goes wrong...
Bookmarks