[12.0] Can't uninstall Smile Audit

[SommelierOdoo]

We keep on encountering an error when uninstalling:

` Error: Odoo Server Error

Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/tools/cache.py", line 88, in lookup r = d[key] File "/home/odoo/src/odoo/odoo/tools/func.py", line 69, in wrapper return func(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/tools/lru.py", line 44, in getitem a = self.d[obj].me KeyError: ('audit.rule', <function AuditRule._check_audit_rule at 0x7f7a840e9510>)

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/odoo/src/odoo/odoo/http.py", line 656, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/odoo/src/odoo/odoo/http.py", line 314, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/home/odoo/src/odoo/odoo/tools/pycompat.py", line 87, in reraise raise value File "/home/odoo/src/odoo/odoo/http.py", line 698, in dispatch result = self._call_function(self.params) File "/home/odoo/src/odoo/odoo/http.py", line 346, in _call_function return checked_call(self.db, *args, *kwargs) File "/home/odoo/src/odoo/odoo/service/model.py", line 98, in wrapper return f(dbname, args, kwargs) File "/home/odoo/src/odoo/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, kw) File "/home/odoo/src/odoo/odoo/http.py", line 941, in call return self.method(*args, *kw) File "/home/odoo/src/odoo/odoo/http.py", line 519, in response_wrap response = f(args, kw) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 966, in call_button action = self._call_kw(model, method, args, {}) File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 954, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 759, in call_kw return _call_kw_multi(method, model, args, kwargs) File "/home/odoo/src/odoo/odoo/api.py", line 746, in _call_kw_multi result = method(recs, *args, kwargs) File "/home/odoo/src/odoo/odoo/addons/base/wizard/base_module_uninstall.py", line 60, in action_uninstall return modules.button_immediate_uninstall() File "", line 2, in button_immediate_uninstall File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 74, in check_and_log return method(self, *args, *kwargs) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 586, in button_immediate_uninstall return self._button_immediate_function(type(self).button_uninstall) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 561, in _button_immediate_function modules.registry.Registry.new(self._cr.dbname, update_module=True) File "/home/odoo/src/odoo/odoo/modules/registry.py", line 86, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/odoo/src/odoo/odoo/modules/loading.py", line 494, in load_modules Module.browse(modules_to_remove.values()).module_uninstall() File "", line 2, in module_uninstall File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 74, in check_and_log return method(self, args, kwargs) File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 463, in module_uninstall self.with_context(prefetch_fields=False).write({'state': 'uninstalled', 'latest_version': False}) File "/home/odoo/src/odoo/addons/website_theme_install/models/ir_module_module.py", line 94, in write return super(IrModuleModule, self).write(vals) File "/home/odoo/src/user/smile_audit/models/base.py", line 105, in write if not self._get_audit_rule('write'): File "/home/odoo/src/user/smile_audit/models/base.py", line 59, in _get_audit_rule rule_id = AuditRule._check_audit_rule(group_ids).get( File "", line 2, in _check_audit_rule File "/home/odoo/src/odoo/odoo/tools/cache.py", line 93, in lookup value = d[key] = self.method(*args, **kwargs)

File "/home/odoo/src/user/smile_audit/models/audit_rule.py", line 86, in _check_audit_rule ('group_id', 'in', group_ids), File "/home/odoo/src/odoo/odoo/models.py", line 1581, in search res = self._search(args, offset=offset, limit=limit, order=order, count=count) File "/home/odoo/src/odoo/odoo/models.py", line 4150, in _search self._cr.execute(query_str, where_clause_params) File "/home/odoo/src/odoo/odoo/sql_db.py", line 148, in wrapper return f(self, *args, **kwargs) File "/home/odoo/src/odoo/odoo/sql_db.py", line 225, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: column audit_rule.active does not exist LINE 1: SELECT "audit_rule".id FROM "audit_rule" WHERE (("audit_rule... ... `

We are trying to migrate from Odoo V12 to V13. For rarely to non used apps, we want to uninstall them to make the migration easier.

Thanks for the help.

[D0nmoses]

I am having the same issue in Odoo v13. smile_audit seems to affect the functionality of other modules with groups associated to them, rendering them useless.

Any help would be greatly appreciated.

Traceback:

Error: Odoo Server Error

Traceback (most recent call last): File "/home/vaell/odoo13/odoo/tools/cache.py", line 85, in lookup r = d[key] File "/home/vaell/odoo13/odoo/tools/func.py", line 69, in wrapper return func(self, *args, **kwargs) File "/home/vaell/odoo13/odoo/tools/lru.py", line 44, in getitem a = self.d[obj].me KeyError: ('audit.rule', <function AuditRule._check_audit_rule at 0x7f3cd04d72f0>)

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/vaell/odoo13/odoo/http.py", line 624, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/home/vaell/odoo13/odoo/http.py", line 310, in _handle_exception raise pycompat.reraise(type(exception), exception, sys.exc_info()[2]) File "/home/vaell/odoo13/odoo/tools/pycompat.py", line 14, in reraise raise value File "/home/vaell/odoo13/odoo/http.py", line 669, in dispatch result = self._call_function(self.params) File "/home/vaell/odoo13/odoo/http.py", line 350, in _call_function return checked_call(self.db, *args, *kwargs) File "/home/vaell/odoo13/odoo/service/model.py", line 94, in wrapper return f(dbname, args, kwargs) File "/home/vaell/odoo13/odoo/http.py", line 339, in checked_call result = self.endpoint(*a, kw) File "/home/vaell/odoo13/odoo/http.py", line 915, in call return self.method(*args, *kw) File "/home/vaell/odoo13/odoo/http.py", line 515, in response_wrap response = f(args, kw) File "/home/vaell/odoo13/addons/web/controllers/main.py", line 1326, in call_button action = self._call_kw(model, method, args, kwargs) File "/home/vaell/odoo13/addons/web/controllers/main.py", line 1314, in _call_kw return call_kw(request.env[model], method, args, kwargs) File "/home/vaell/odoo13/odoo/api.py", line 387, in call_kw result = _call_kw_multi(method, model, args, kwargs) File "/home/vaell/odoo13/odoo/api.py", line 374, in _call_kw_multi result = method(recs, *args, kwargs) File "/home/vaell/odoo13/odoo/addons/base/wizard/base_module_uninstall.py", line 59, in action_uninstall return modules.button_immediate_uninstall() File "", line 2, in button_immediate_uninstall File "/home/vaell/odoo13/odoo/addons/base/models/ir_module.py", line 72, in check_and_log return method(self, *args, *kwargs) File "/home/vaell/odoo13/odoo/addons/base/models/ir_module.py", line 597, in button_immediate_uninstall return self._button_immediate_function(type(self).button_uninstall) File "/home/vaell/odoo13/odoo/addons/base/models/ir_module.py", line 573, in _button_immediate_function modules.registry.Registry.new(self._cr.dbname, update_module=True) File "/home/vaell/odoo13/odoo/modules/registry.py", line 86, in new odoo.modules.load_modules(registry._db, force_demo, status, update_module) File "/home/vaell/odoo13/odoo/modules/loading.py", line 494, in load_modules Module.browse(modules_to_remove.values()).module_uninstall() File "", line 2, in module_uninstall File "/home/vaell/odoo13/odoo/addons/base/models/ir_module.py", line 72, in check_and_log return method(self, args, kwargs) File "/home/vaell/odoo13/odoo/addons/base/models/ir_module.py", line 479, in module_uninstall self.with_context(prefetch_fields=False).write({'state': 'uninstalled', 'latest_version': False}) File "/home/vaell/odoo13/addons/website_theme_install/models/ir_module_module.py", line 92, in write return super(IrModuleModule, self).write(vals) File "/home/vaell/odoo13-custom-addons/smile_audit/models/base.py", line 104, in write if not self._get_audit_rule('write'): File "/home/vaell/odoo13-custom-addons/smile_audit/models/base.py", line 59, in _get_audit_rule rule_id = AuditRule._check_audit_rule(group_ids).get( File "", line 2, in _check_audit_rule File "/home/vaell/odoo13/odoo/tools/cache.py", line 90, in lookup value = d[key] = self.method(*args, *kwargs) File "/home/vaell/odoo13-custom-addons/smile_audit/models/audit_rule.py", line 81, in _check_audit_rule ('group_id', 'in', group_ids), File "/home/vaell/odoo13/odoo/models.py", line 1643, in search res = self._search(args, offset=offset, limit=limit, order=order, count=count) File "/home/vaell/odoo13/odoo/models.py", line 4460, in _search self._cr.execute(query_str, where_clause_params) File "/home/vaell/odoo13/odoo/sql_db.py", line 168, in wrapper return f(self, args, **kwargs) File "/home/vaell/odoo13/odoo/sql_db.py", line 245, in execute res = self._obj.execute(query, params) psycopg2.ProgrammingError: relation "audit_rule" does not exist LINE 1: SELECT "audit_rule".id FROM "audit_rule" WHERE (("audit_rule... ^

[hrahuu]

I am having the same issue in Odoo v13. smile_audit seems to affect the functionality of other modules with groups associated to them, rendering them useless.

Any help would be greatly appreciated.

Traceback:

Error: Odoo Server Error ...

Facing this very same problem with Odoo v13 smile_audit when trying to uninstall it. In addition when I tried to use it - it jammed whole Odoo server when creating a audit rule.

[Androbas]

Hi, just faced the same problem I had to delete some content from models/base.py, just left import datetime from odoo import api, fields, models from odoo.tools.safe_eval import safe_eval

class Base(models.AbstractModel): _inherit = "base"

then update the module, and uninstall. the problem is that this inherits the base model (meaning ALL models), and when uninstall it tries to check the rules for the records written, but some fields of audt rule doesn't exist anymore

[sgrotz-UT]

Thanks a lot @Androbas - that just saved me...