How to remove all tables from package during uninstall (Version 5.7)?

Jul 12, 2018

In order to remove all tables of a packet during deinstallation, there is a very simple solution without having to specify all table names individually.

Solution for Concrete5 Version 5.7.x!

The basic requirement for the solution below is that you have used your own prefix in your package for your tables. If so, you can use the following snippet in 'packages\your_package\controller.php':

public function uninstall() {
      parent::uninstall();

    //***************************************************************************
    //**Remove all tables from a package with the same, package-specific prefix
    //**DO NOT USE IF YOU HAVE NO OWN TABLES PREFIX!
    //***************************************************************************
    $tblprefix = 'TestProject'; //<- enter your package table prefix

    $db = Loader::db();
    $dbname = $db->getDatabase();

    //remove Association Mapping Many-To-Many tables, only works if you use underscores in table names (sample: TestProject_ToDos)
    $sqldrop = $db->fetchColumn("SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = '".$dbname."' AND table_name LIKE '".$tblprefix."%\_%';");
    $db->query($sqldrop);

    //remove other tables
    $sqldrop = $db->fetchColumn("SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = '".$dbname."' AND table_name LIKE '".$tblprefix."%';");
    $db->query($sqldrop);
    //***************************************************************************
}
Recent Tutorials
Updating Concrete Themes from Version 8 to Version 9
Nov 24, 2022

This tutorial covers commonly encountered issues when upgrading a Concrete CMS theme from version 8 to version 9

Transferring ownership of an add-on and a theme
Nov 15, 2022
By katzueno.

If you encounter a Concrete CMS add-on or theme that you love but not being maintained, you may want to ask the author to help or take over the add-on or theme. Here is the quick step-by-step guide of how to transfer the ownership.

How to update Add-Ons if not on the Update Add-Ons Menu item
Jul 4, 2022

How to manually download an add-on and update it when your site's core versions isn't considered compatible with the add-on version.

Generate a report with author information and form summaries in Concrete CMS.
May 9, 2022

In Concrete CMS, you can use a form to initiate contact between logged-in users and then create helpful reports. After form submissions are collected, they can be searched, sorted, and exported as a spreadsheet. This tutorial will detail how to add author information to a report using the advanced search.

How to clone and customize Atomik theme
Feb 14, 2022
By linuxoid.

How to clone and customize Atomik theme

Update jQuery to 3.5 on Concrete CMS version 8.5.x
Dec 1, 2021
By hissy.

If you have to take some time to fix your site to work with version 9 and want to update jQuery immediately, you can override it.

Was this information useful?
Thank you for your feedback.