Odoo Help


Updating modules. Bad query - null value in column "user_type"

Miguel Fernández
on 12/13/13, 7:22 AM 2,455 views


I get the error below after update modules with bazaar and update the database of OpenERP with the new modules.

Anybody knows what can I do?

2013-12-13 10:56:47,788 3658 INFO copia_gf openerp.addons.base.ir.ir_model: Deleting 2252@account.account.template
2013-12-13 10:56:47,810 3658 INFO copia_gf openerp.addons.base.ir.ir_model: Deleting 29@account.account.type
2013-12-13 10:56:47,812 3658 ERROR copia_gf openerp.sql_db: bad query: delete from account_account_type where id IN (29)
Traceback (most recent call last):
          File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
            res = self._obj.execute(query, params)
    IntegrityError: null value in column "user_type" violates not-null constraint
    CONTEXT:  SQL statement "UPDATE ONLY "public"."account_account_template" SET "user_type" = NULL WHERE $1 OPERATOR(pg_catalog.=) "user_type""

On upgrade, some code is attempting to delete record from account_account_type with id=29 but that is been referenced in account_account_template and it is mandatory.

on 12/16/13, 10:31 PM

I update modules with bazaar again and all was ok. Aparently there is a bug with the registers update during upgrade of modules.

Miguel Fernández
on 12/17/13, 5:45 AM

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: 12/13/13, 7:22 AM
Seen: 2455 times
Last updated: 3/16/15, 8:10 AM