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

CRM
e-Commerce
Účetnictví
Sklad
PoS
Projekty
MRP

All apps

All Posts Lidé Odznaky

Štítky (View all)

odoo accounting v14 pos v15

O tomto fóru

Pomoc

res.users create

create res.users odoo8.0 odoo9

1 Odpovědět

13242 Zobrazení

Gavin Yap

Hi All,

I would like to create 2 sets of user, whenever a form is signup. Hence I cannot use the "auth_signup" module.

I tried to test create a user from the console using the below code:

env['res.users'].sudo().create({
            'name': 'testa',
            'login': 'testa',
        })

But I was not able to create a new user. Instead I got this error.

2016-01-25 00:57:51,435 13091 INFO elm openerp.sql_db: bad query:  SELECT "res_users"."id" as "id","res_users"."company_id" as "company_id" FROM "res_users" LEFT JOIN "res_partner" as "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id")
                        WHERE "res_users".id IN (1)  ORDER BY "res_users__partner_id"."name" ,"res_users"."login"  
Traceback (most recent call last):
  File "<console>", line 1, in <module>
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 248, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 490, in new_api
    result = method(self._model, cr, uid, *args, **old_kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 845, in create
    return super(users_view, self).create(cr, uid, values, context)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 643, in create
    user_id = super(users_implied, self).create(cr, uid, values, context)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 336, in create
    user_id = super(res_users, self).create(cr, uid, vals, context=context)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 354, in old_api
    result = method(recs, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 4112, in create
    vals = self._add_missing_default_values(vals)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 248, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 490, in new_api
    result = method(self._model, cr, uid, *args, **old_kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 1775, in _add_missing_default_values
    defaults = self.default_get(cr, uid, list(missing_defaults), context)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 875, in default_get
    values = super(users_view, self).default_get(cr, uid, fields1, context)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 354, in old_api
    result = method(recs, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 1326, in default_get
    defaults[name] = field.default(self)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/fields.py", line 75, in <lambda>
    value(model._model, model._cr, model._uid, model._context),
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 254, in _get_company
    context=context, load='_classic_write')
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 908, in read
    res = super(users_view, self).read(cr, uid, ids, other_fields, context=context, load=load)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/addons/base/res/res_users.py", line 307, in read
    result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 250, in wrapper
    return old_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 3175, in read
    result = BaseModel.read(records, fields, load=load)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 248, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 3210, in read
    self._read_from_database(stored, inherited)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/api.py", line 248, in wrapper
    return new_api(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/models.py", line 3348, in _read_from_database
    cr.execute(query_str, params)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/sql_db.py", line 139, in wrapper
    return f(self, *args, **kwargs)
  File "/home/gavinyap/Documents/git/fusionbrm9/openerp/sql_db.py", line 218, in execute
    res = self._obj.execute(query, params)
InternalError: current transaction is aborted, commands ignored until end of transaction block

The error does not make sense as I can cut, paste and run the SQL in postgres and it yield results.

What is wrong here and what can I do to create a new User?

Note: I'm using Odoo8 or 9

Thanh Loyal

Nejlepší odpověď

Can you run that code (with a little modification as bellow) in a web controller?:

class ApiController(http.Controller):    @http.route(route='/create_user', auth='public')
    def create_user(self, **kwargs): 
        http.request.env['res.users'].sudo().create({
            'name': 'testa',
            'login': 'testa',
        })

My code is pretty the same as yours and it works well in a controller.

Gavin Yap

Autor

Thanks. Odoo framework is relatively weird. In the console. if I use self.env it works but not env alone.

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

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

Přihlásit se

Related Posts	Odpovědi	Zobrazení
How to properly create a large amount of users? create res.users	2 lis 21	5230
Odoo 10: Change datetime picker options for a field Vyřešeno odoo8.0 odoo9 odoo10	1 kvě 21	11312
Customer Invoice and Payment in odoo 8 and 9 accounting odoo8.0 odoo9	0 říj 16	5670
How to check whether two many2many fields are exactly equal or not in odoo9? odoo odoo8.0 odoo9	1 zář 16	8200
write and create function Vyřešeno function create write odoo8.0	2 čvn 25	91656

This question has been flagged

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