Odoo Help


ODOO v8 problem installing CRM module

Nebojsa Joncic
on 3/16/16, 3:18 PM 760 views


I wanted to install CRM module in ODOO v8 and got the following ODOO Server Error:

Odoo Server Error

Traceback (most recent call last):

File "/opt/odoo/openerp/http.py", line 537, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/opt/odoo/openerp/http.py", line 574, in dispatch

result = self._call_function(**self.params)

File "/opt/odoo/openerp/http.py", line 310, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/opt/odoo/openerp/service/model.py", line 113, in wrapper

return f(dbname, *args, **kwargs)

File "/opt/odoo/openerp/http.py", line 307, in checked_call

return self.endpoint(*a, **kw)

File "/opt/odoo/openerp/http.py", line 803, in __call__

return self.method(*args, **kw)

File "/opt/odoo/openerp/http.py", line 403, in response_wrap

response = f(*args, **kw)

File "/opt/odoo/addons/web/controllers/main.py", line 1259, in run

[action_id], request.context)

File "/opt/odoo/openerp/http.py", line 908, in proxy

result = meth(cr, request.uid, *args, **kw)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/ir/ir_actions.py", line 1002, in run

res = func(cr, uid, action, eval_context=eval_context, context=run_context)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/website/models/ir_actions.py", line 62, in run_action_code_multi

res = super(actions_server, self).run_action_code_multi(cr, uid, action, eval_context, context)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/ir/ir_actions.py", line 836, in run_action_code_multi

eval(action.code.strip(), eval_context, mode="exec", nocopy=True) # nocopy allows to return 'action'

File "/opt/odoo/openerp/tools/safe_eval.py", line 314, in safe_eval

return eval(c, globals_dict, locals_dict)

File "", line 1, in <module>

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/module/module.py", line 446, in button_immediate_install

return self._button_immediate_function(cr, uid, ids, self.button_install, context=context)

File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/openerp/addons/base/module/module.py", line 494, in _button_immediate_function

registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)

File "/opt/odoo/openerp/modules/registry.py", line 370, in new

openerp.modules.load_modules(registry._db, force_demo, status, update_module)

File "/opt/odoo/openerp/modules/loading.py", line 355, in load_modules

loaded_modules, update_module)

File "/opt/odoo/openerp/modules/loading.py", line 255, in load_marked_modules

loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

File "/opt/odoo/openerp/modules/loading.py", line 157, in load_module_graph

init_module_models(cr, package.name, models)

File "/opt/odoo/openerp/modules/module.py", line 290, in init_module_models


File "/opt/odoo/openerp/api.py", line 241, in wrapper

return old_api(self, *args, **kwargs)

File "/opt/odoo/addons/crm/report/crm_lead_report.py", line 105, in init


File "/opt/odoo/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/opt/odoo/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ValueError: "column "c.date_deadline" must appear in the GROUP BY clause or be used in an aggregate function

LINE 5: c.date_deadline,


" while evaluating

u"self.button_immediate_install(cr, uid, context.get('active_ids', []), context=context)"

The server is hosted by Siteground and I do not have access to the root folder.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/16/16, 3:18 PM
Seen: 760 times
Last updated: 3/16/16, 4:44 PM