ODOO: remove from database a deleted module
Stuck with a ghost module installed in odoo database, but removed from addons directories? Here’s the solution
Published in
1 min readMar 5, 2020
- read the id of your module from
ir_module_module
```
SELECT id
FROM ir_module_module
WHERE name=’your_module_name’;
``` - trying to delete the module from
ir_module_module
directly:
```DELETE FROM ir_module_module WHERE id=your_module_id;``` - in case of constraints error, delete the same module id from the specified tables, for example:
- error:
```CONTEXT: SQL statement “UPDATE ONLY “public”.”ir_model_constraint” SET “module” = NULL WHERE $1 OPERATOR(pg_catalog.=) “module””```
- solution:
```DELETE FROM ir_model_constraint WHERE module=your_module_id;```
- error:
```CONTEXT: SQL statement “UPDATE ONLY “public”.”base_module_uninstall” SET “module_id” = NULL WHERE $1 OPERATOR(pg_catalog.=) “module_id””```
- solution:
```DELETE FROM base_module_uninstall WHERE module_id=your_module_id;```