This question has been flagged
9 Replies
3767 Views

Hello 

I'm still in a major problem.

Only my admin user can see products in the the web shop. Before, all was ok. We don't know why it doesn't work now.

All other user than admin, including public user, get an error. But error is not the same according to computer...

MAGIC : ERROR IS NOT THE SAME ON TWO DIFFERENT COMPUTERS !!!!

Here is the error I get from ONE computer :

Traceback

Traceback (most recent call last): File "/home/odoo-test/addons/website/models/ir_http.py", line 204, in _handle_exception response = super(ir_http, self)._handle_exception(exception) File "/home/odoo-test/openerp/addons/base/ir/ir_http.py", line 100, in _handle_exception return request._handle_exception(exception) File "/home/odoo-test/openerp/http.py", line 659, in _handle_exception return super(HttpRequest, self)._handle_exception(exception) File "/home/odoo-test/openerp/http.py", line 1358, in get_response result.flatten() File "/home/odoo-test/openerp/http.py", line 1231, in flatten self.response.append(self.render()) File "/home/odoo-test/openerp/http.py", line 1225, in render context=request.context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/addons/website/models/ir_ui_view.py", line 172, in render return super(view, self).render(cr, uid, id_or_xml_id, values=values, engine=engine, context=context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/openerp/addons/base/ir/ir_ui_view.py", line 1029, in render return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 259, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 434, in render_tag_call d[0] = self.render_element(element, template_attributes, generated_attributes, d) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_foreach ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_foreach ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 429, in render_tag_if return self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 443, in render_tag_call return self.render(cr, uid, template, d) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 259, in render return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 429, in render_tag_if return self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node result = self.render_element(element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element g_inner.append(self.render_node(current_node, qwebcontext)) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 428, in render_tag_if if self.eval_bool(template_attributes["if"], qwebcontext): File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 234, in eval_bool return int(bool(self.eval(expr, qwebcontext))) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 203, in eval raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 200, in eval return qwebcontext.safe_eval(expr) File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 86, in safe_eval return eval(expr, None, locals_dict, nocopy=True, locals_builtins=True) File "/home/odoo-test/openerp/tools/safe_eval.py", line 314, in safe_eval return eval(c, globals_dict, locals_dict) File "", line 1, in <module> File "/home/odoo-test/addons/website_sale/controllers/main.py", line 212, in <lambda> compute_currency = lambda price: pool['res.currency']._compute(cr, uid, from_currency, to_currency, price, context=context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/openerp/addons/base/res/res_currency.py", line 242, in _compute rate = self._get_conversion_rate(cr, uid, from_currency, to_currency, context=context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/addons/account/res_currency.py", line 31, in _get_conversion_rate rate = super(res_currency_account, self)._get_conversion_rate(cr, uid, from_currency, to_currency, context=context) File "/home/odoo-test/openerp/api.py", line 241, in wrapper return old_api(self, *args, **kwargs) File "/home/odoo-test/openerp/addons/base/res/res_currency.py", line 232, in _get_conversion_rate 'at the date: %s') % (currency_symbol, date)) QWebException: (u'Error', u'No rate found \nfor the currency: False \nat the date: 2015-03-05')

 

Here is the error I get on the SECOND computer :

Traceback

2015-03-05 21:57:39,341 16990 WARNING test openerp.addons.website.models.ir_http: 403 Forbidden:

Traceback (most recent call last):
  File "/home/odoo-test/addons/website/models/ir_http.py", line 204, in _handle_exception
    response = super(ir_http, self)._handle_exception(exception)
  File "/home/odoo-test/openerp/addons/base/ir/ir_http.py", line 100, in _handle_exception
    return request._handle_exception(exception)
  File "/home/odoo-test/openerp/http.py", line 659, in _handle_exception
    return super(HttpRequest, self)._handle_exception(exception)
  File "/home/odoo-test/openerp/http.py", line 1358, in get_response
    result.flatten()
  File "/home/odoo-test/openerp/http.py", line 1231, in flatten
    self.response.append(self.render())
  File "/home/odoo-test/openerp/http.py", line 1225, in render
    context=request.context)
  File "/home/odoo-test/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo-test/addons/website/models/ir_ui_view.py", line 172, in render
    return super(view, self).render(cr, uid, id_or_xml_id, values=values, engine=engine, context=context)
  File "/home/odoo-test/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo-test/openerp/addons/base/ir/ir_ui_view.py", line 1029, in render
    return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context)
  File "/home/odoo-test/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 259, in render
    return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 434, in render_tag_call
    d[0] = self.render_element(element, template_attributes, generated_attributes, d)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_foreach
    ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 420, in render_tag_foreach
    ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 429, in render_tag_if
    return self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 443, in render_tag_call
    return self.render(cr, uid, template, d)
  File "/home/odoo-test/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 259, in render
    return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 429, in render_tag_if
    return self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 319, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 296, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 428, in render_tag_if
    if self.eval_bool(template_attributes["if"], qwebcontext):
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 234, in eval_bool
    return int(bool(self.eval(expr, qwebcontext)))
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 203, in eval
    raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 200, in eval
    return qwebcontext.safe_eval(expr)
  File "/home/odoo-test/openerp/addons/base/ir/ir_qweb.py", line 86, in safe_eval
    return eval(expr, None, locals_dict, nocopy=True, locals_builtins=True)
  File "/home/odoo-test/openerp/tools/safe_eval.py", line 314, in safe_eval
    return eval(c, globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/home/odoo-test/openerp/fields.py", line 771, in __get__
    return record._cache[self]
  File "/home/odoo-test/openerp/models.py", line 5911, in __getitem__
    return value.get() if isinstance(value, SpecialValue) else value
  File "/home/odoo-test/openerp/fields.py", line 54, in get
    raise self.exception
QWebException: ('AccessError', 'No value found for product.template(1034,).price')

 

Idea? Thanks!

 

Avatar
Discard

Idea ... why currency == False?

Author

What should it be?

I do not know, is the idea :)

Best Answer

Just before the traceback, you should have an ACL (Access Control List) error in the logfile.

In settings -> technical -> Security -> Access Control Lists you should check read autorisations on product.template. You should have a rule named "product.template.public" with read access for everyone (no group).

Avatar
Discard
Best Answer

1) Check whether you have currency rate as 1 and base is true for base currency.

2) Check whether you have public pricelist defined.

3) Check whether you have changed anything in record rule for Product multi-company.

Avatar
Discard
Best Answer

I have more or less the same problem

Avatar
Discard
Author Best Answer

For the first error, I didn't have any currency with « base » at true.

Now, it's the same error anywhere (the second error!)

Avatar
Discard
Author

I execute this SQL : update product_template set website_published = FALSE Now, everybody can get the shop without error. But no product! Just categories are there.

Author

403 comes back as soon as I publish a product on website.