TypeError: unsupported operand type(s) for +: 'NoneType' and 'int'

Question

Hi,
When I'm creating new warehouse, getting an error
File "/home/apagen/workspace/odoo/openerp/models.py", line 4191, in _create
cr.execute('update '+self._table+' set parent_left=%s,parent_right=%s where id=%s', (pleft+1, pleft+2, id_new))
TypeError: unsupported operand type(s) for +: 'NoneType' and 'int'
I need help asap.

Akhil P Sivan · Accepted Answer

Hi,
Does your db contain demo data? I think your db might be corrupted. Can you check with a fresh db? The "pleft" is not supposed to be empty, but due to some reason (eg: corrupted db) it is becoming null.
You can try to fix by using OCA shell addon [1]  and run the following:
1. Install the addon
2. Run odoo by command:
python odoo.py shell -d <dbname>
3. In the interactive shell run the following statements:
self.env['stock.warehouse']._parent_store_compute()    //This should return True
self

dlsuarez · Answer

The following code works for me in Odoo v11.0:
self.env['stock.location']._parent_store_compute()
self.env.cr.commit()

Orlando Malaquias · Answer

It worked for me too in v11...
Thanks @dlsuarez

Akhilesh Gupta · Answer

I have resolved this issue after waste lot of time.
I found two fields that was blank in stock.location i.e. parent_left and parent_right.
Value of both field matter on the all operations related to inventory.
Now My existing database working fine after set the values of these fields.

Tirtha Rahaman · Answer

This is for someone arriving here from search engines. I faced this error while importing data. This happened because I had the product id field mapped to Product instead of Product/External ID. So if you got this error while importing data, check whether the id fields are mapped properly.

関連投稿	返信	ビュー
Odoo 18 SH – Inventory Adjustments Pulling Stock from Raw Material Warehouse Instead of Virtual Location 解決済 warehouse	1 5月 25	924
Multiple barcodes for the same product 解決済 warehouse	3 3月 25	1176
~ closed warehouse	1 5月 24	2242
Transit Location for Inter-Companies Transfers warehouse	2 12月 22	14266
Warehouse to Warehouse Transfer in Odoo v13 解決済 warehouse	5 4月 20	4853

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！