Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

Overriding route for /web/login path produces ValueError: Expected singleton: res.users()

2 Replies

5772 Views

AGILE BUSINESS TECHNOLOGIES

We are trying to override the default controller for the /web/login route in odoo/addons/web/controllers/main.py

The custom code is as follows:

from odoo import http
from odoo.addons.web.controllers.main import Home


class ProductivityCardHome(Home):

    @http.route('/web/login', type='http', auth="none")
    def web_login(self, redirect=None, **kw):
        res = super(ProductivityCardHome, self).web_login(redirect=redirect, kw=kw)
        return res

Unfortunately, the code above results in the following errors that we don't know what is the cause.



Traceback (most recent call last):
  File "/project/src/odoo/odoo/models.py", line 5199, in ensure_one
    _id, = self._ids
ValueError: not enough values to unpack (expected 1, got 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 5, in template_1741
  File "/project/src/odoo/addons/website_sale_stock/models/website.py", line 28, in sale_get_order
    so = super().sale_get_order(force_create=force_create, code=code, update_pricelist=update_pricelist, force_pricelist=force_pricelist)
  File "/project/src/odoo/addons/website_sale/models/website.py", line 250, in sale_get_order
    if not sale_order_id and not self.env.user._is_public():
  File "/project/src/odoo/odoo/addons/base/models/res_users.py", line 905, in _is_public
    self.ensure_one()
  File "/project/src/odoo/odoo/models.py", line 5202, in ensure_one
    raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: res.users()

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/project/src/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/project/src/odoo/odoo/http.py", line 810, in dispatch
    r = self._call_function(**self.params)
  File "/project/src/odoo/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/project/src/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/project/src/odoo/odoo/http.py", line 351, in checked_call
    result.flatten()
  File "/project/src/odoo/odoo/http.py", line 1277, in flatten
    self.response.append(self.render())
  File "/project/src/odoo/odoo/http.py", line 1270, in render
    return env["ir.ui.view"]._render_template(self.template, self.qcontext)
  File "/project/src/odoo/odoo/addons/base/models/ir_ui_view.py", line 1980, in _render_template
    return self.browse(self.get_view_id(template))._render(values, engine)
  File "/project/src/odoo/addons/website/models/ir_ui_view.py", line 433, in _render
    return super(View, self)._render(values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/project/src/odoo/addons/web_editor/models/ir_ui_view.py", line 29, in _render
    return super(IrUiView, self)._render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/project/src/odoo/odoo/addons/base/models/ir_ui_view.py", line 1988, in _render
    return self.env[engine]._render(self.id, qcontext)
  File "/project/src/odoo/odoo/tools/profiler.py", line 289, in _tracked_method_render
    return method_render(self, template, values, **options)
  File "/project/src/odoo/odoo/addons/base/models/ir_qweb.py", line 76, in _render
    result = super()._render(template, values=values, **compile_options)
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 134, in _render
    result = ''.join(rendering)
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 186, in template_190
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 29, in template_189
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 1222, in template_1388
  File "", line 1157, in t_call_content
  File "", line 1109, in t_call_content
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 223, in render_template
    raise QWebException("Error when render the template", self, options,
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/project/src/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/project/src/odoo/odoo/http.py", line 810, in dispatch
    r = self._call_function(**self.params)
  File "/project/src/odoo/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/project/src/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/project/src/odoo/odoo/http.py", line 351, in checked_call
    result.flatten()
  File "/project/src/odoo/odoo/http.py", line 1277, in flatten
    self.response.append(self.render())
  File "/project/src/odoo/odoo/http.py", line 1270, in render
    return env["ir.ui.view"]._render_template(self.template, self.qcontext)
  File "/project/src/odoo/odoo/addons/base/models/ir_ui_view.py", line 1980, in _render_template
    return self.browse(self.get_view_id(template))._render(values, engine)
  File "/project/src/odoo/addons/website/models/ir_ui_view.py", line 433, in _render
    return super(View, self)._render(values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/project/src/odoo/addons/web_editor/models/ir_ui_view.py", line 29, in _render
    return super(IrUiView, self)._render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "/project/src/odoo/odoo/addons/base/models/ir_ui_view.py", line 1988, in _render
    return self.env[engine]._render(self.id, qcontext)
  File "/project/src/odoo/odoo/tools/profiler.py", line 289, in _tracked_method_render
    return method_render(self, template, values, **options)
  File "/project/src/odoo/odoo/addons/base/models/ir_qweb.py", line 76, in _render
    result = super()._render(template, values=values, **compile_options)
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 134, in _render
    result = ''.join(rendering)
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 186, in template_190
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 29, in template_189
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 221, in render_template
    raise e
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 1222, in template_1388
  File "", line 1157, in t_call_content
  File "", line 1109, in t_call_content
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 223, in render_template
    raise QWebException("Error when render the template", self, options,
odoo.addons.base.models.qweb.QWebException: Expected singleton: res.users()
Traceback (most recent call last):
  File "/project/src/odoo/odoo/models.py", line 5199, in ensure_one
    _id, = self._ids
ValueError: not enough values to unpack (expected 1, got 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/project/src/odoo/odoo/addons/base/models/qweb.py", line 219, in render_template
    yield from compiled_fn(self, values, log)
  File "", line 5, in template_1741
  File "/project/src/odoo/addons/website_sale_stock/models/website.py", line 28, in sale_get_order
    so = super().sale_get_order(force_create=force_create, code=code, update_pricelist=update_pricelist, force_pricelist=force_pricelist)
  File "/project/src/odoo/addons/website_sale/models/website.py", line 250, in sale_get_order
    if not sale_order_id and not self.env.user._is_public():
  File "/project/src/odoo/odoo/addons/base/models/res_users.py", line 905, in _is_public
    self.ensure_one()
  File "/project/src/odoo/odoo/models.py", line 5202, in ensure_one
    raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: res.users()

Error when render the template
ValueError: Expected singleton: res.users()
Template: website_sale.header_cart_link
Path: /t/t[1]
Node:

AGILE BUSINESS TECHNOLOGIES

Author Best Answer

We figured it out. The working code is:

# -*- coding: utf-8 -*-
from odoo import http
from odoo.addons.web.controllers import main


class Home(main.Home):

    @http.route('/web/login')
    def web_login(self, *args, **kw):
        return super().web_login(*args, **kw)

Apparently, the web_login method was also modified in the website module to add some options to the http.route decorator for public access purposes which makes sense when you have the website module installed.
The cause of the error we are getting is that we undid the changes made by the website module by re-setting the options of the http.route decorator in our custom code. As noticed in the working code above, we removed those options.

Waleed Ali Mohsen

Try the below:

 @http.route('/web/login', type='http', auth="none")
    def web_login(self, redirect=None, **kw):
        res = super(ProductivityCardHome, self).web_login(redirect=redirect, **kw)
        return res

AGILE BUSINESS TECHNOLOGIES

Author

Hi @Waleed. Thank you for taking the time to answer our question. We updated the code as you suggested but still getting the same error.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Related Posts	Replies	Views
log in controller with react login controllers	0 Nov 23	2279
Controller ignoring args Solved controllers arguments http.route	2 Dec 22	8814
Properly inherit web controller and overwrite web_login method Solved inheritance login controllers	3 May 21	14945
Force authentication of a web page login controllers odoo	1 Nov 20	7409
Controller giving 404 Error controllers	2 Aug 25	3596

This question has been flagged

Enjoying the discussion? Don't just read, join in!