Odoo Help


Understand the categories/public-categories

Franz Palfrader
on 8/20/14, 10:32 AM 1,858 views

I have erros while import/backup the database, see the error

2014-08-20 13:44:51,326 6065 ERROR db_name openerp.sql_db: bad query: INSERT INTO "product_public_category" ("id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_public_category_id_seq'), 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id
Traceback (most recent call last):
  File "/opt/odoo/openerp/sql_db.py", line 230, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "name" violates not-null constraint
DETAIL:  Failing row contains (999, 1, null, 2014-08-20 13:44:51.203247, null, null, null, null, 1, null, 2014-08-20 13:44:51.203247).

Here, on Runbot, I created the first two categories and export it to CSV. 

"product.Computer_all_in_one","Computer all-in-one","product.sub_computers"

On my local DB I have the db-values like these:

"__export__.product_public_category_365","Category One","website_sale.367"
"__export__.product_public_category_364","Category Two","website_sale.367"



may dirty, but that's why I use two diff. import method: - direct injection with sql - xml (this is also easy to mistake) the third one is the excel read directly, and create the orm objects. (this method is quite difficult and very slow...)

on 8/20/14, 11:16 AM
Marek Mosiewicz
On 8/26/14, 9:33 AM

The problem is that import tries to insert value into categories without name value which is required.

Maybe it tries to import these lines:


I think also the languages/translations can play an explicit or underlying role

Franz Palfrader
on 8/26/14, 10:36 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

2 follower(s)


Asked: 8/20/14, 10:32 AM
Seen: 1858 times
Last updated: 3/16/15, 8:10 AM