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 سبتمبر 25	2195
Multiple barcodes for the same product تم الحل warehouse	3 مارس 25	1998
~ closed warehouse	1 مايو 24	9796
Transit Location for Inter-Companies Transfers warehouse	2 ديسمبر 22	15836
Warehouse to Warehouse Transfer in Odoo v13 تم الحل warehouse	5 أبريل 20	5472

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!