This question has been flagged
4 Replies
4256 Views

Hi, the survey function is fantastic and I can see Odoo uses it even for the online test. One of my surveys worked well previously but yesterday when I tried to click the button View Results, it returned 500: Internal Server Error:


Traceback (most recent call last):

File "/opt/odoo/odoo-server/addons/website/models/ir_http.py", line 160, in _handle_exception

response = super(ir_http, self)._handle_exception(exception)

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_http.py", line 95, in _handle_exception

return request._handle_exception(exception)

File "/opt/odoo/odoo-server/openerp/http.py", line 544, in _handle_exception

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

File "/opt/odoo/odoo-server/openerp/addons/base/ir/ir_http.py", line 121, in _dispatch

result = request.dispatch()

File "/opt/odoo/odoo-server/openerp/http.py", line 562, in dispatch

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

File "/opt/odoo/odoo-server/openerp/http.py", line 297, in _call_function

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

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

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

File "/opt/odoo/odoo-server/openerp/http.py", line 294, in checked_call

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

File "/opt/odoo/odoo-server/openerp/http.py", line 677, in __call__

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

File "/opt/odoo/odoo-server/openerp/http.py", line 346, in response_wrap

response = f(*args, **kw)

File "/opt/odoo/odoo-server/addons/survey/controllers/main.py", line 318, in survey_reporting

'survey_dict': self.prepare_result_dict(survey, current_filters),

File "/opt/odoo/odoo-server/addons/survey/controllers/main.py", line 369, in prepare_result_dict

question_dict = {'question':question, 'input_summary':survey_obj.get_input_summary(request.cr, request.uid, question, current_filters, context=request.context), 'prepare_result':survey_obj.prepare_result(request.cr, request.uid, question, current_filters, context=request.context), 'graph_data': self.get_graph_data(question, current_filters)}

File "/opt/odoo/odoo-server/addons/survey/survey.py", line 368, in prepare_result

res[(input_line.value_suggested_row.id, input_line.value_suggested.id)] += 1

KeyError: (False, 44)



What are these codes indicating? How to fix it?

I'm looking for quick replies.

Cheers,

August

Avatar
Discard

I consider this to be helpful for other users, would you mind to convert your comment to an answer?

Author

Sorry Ermin I don't have enough karmma to do that.

Author Best Answer

The reason for this issue is that after created the survey and got response from test users, some of the questions have been changed. Normally a survey won't be changed after it publishes, so it won't bring any further issue. But I would rather leave this here for anyone who can perfect the mechanism inside Odoo.

Avatar
Discard