verveuster commented 2 years ago

Hi I am on EE 5.4.3 and have installed SEO Lite (v2) in version 2.0.4 Want to uninstall it but get the following error - any idea how I can fix this. Thanks

Exception Caught SQLSTATE[42S02]: Base table or view not found: 1146 Table 'al7w4_ee5.exp_module_member_roles' doesn't exist: DELETE FROMexp_module_member_rolesWHEREmodule_id` = 19 ee/legacy/database/drivers/mysqli/mysqli_connection.php:117

Stack Trace: Please include when reporting this error

0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('DELETE FROM `ex...')

1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('DELETE FROM `ex...')

2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('DELETE FROM `ex...')

3 ee/legacy/database/DB_active_rec.php(1748): CI_DB_driver->query('DELETE FROM `ex...')

4 user/addons/seo_lite/upd.seo_lite.php(310): CI_DB_active_record->delete('`exp_module_mem...')

5 ee/legacy/libraries/addons/Addons_installer.php(88): Seo_lite_upd->uninstall()

6 ee/legacy/libraries/addons/Addons_installer.php(386): Addons_installer->uninstall_module('seo_lite')

7 ee/legacy/libraries/addons/Addons_installer.php(50): Addons_installer->_update_addon('seo_lite', 'module', 'uninstall', false)

8 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1551): Addons_installer->uninstall('seo_lite', 'module', false)

9 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(872): EllisLab\ExpressionEngine\Controller\Addons\Addons->uninstallModule('seo_lite')

10 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(172): EllisLab\ExpressionEngine\Controller\Addons\Addons->remove(Array)

11 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->index()

12 ee/EllisLab/ExpressionEngine/Core/Core.php(268): call_user_func_array(Array, Array)

13 ee/EllisLab/ExpressionEngine/Core/Core.php(118): EllisLab\ExpressionEngine\Core\Core->runController(Array)

14 ee/EllisLab/ExpressionEngine/Boot/boot.php(156): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))

15 admin.php(153): require_once('...')

15 admin.php(153): require_once('...')`

0to9Digital commented 2 years ago

Hi @verveuster, We're sorry you want to remove SEO Lite (v2).

It looks like the database table "module_member_groups" doesn't exist in your site (should be).

In the file upd.seo_lite.php on line 309 you can remove these codelines: $this->EE->db->where('module_id', $query->row('module_id')); $this->EE->db->delete('module_member_roles');

After saving the file, you can simply delete SEO Lite (v2)