Ir al contenido
Menú
Se marcó esta pregunta
5 Respuestas
32533 Vistas

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.

Avatar
Descartar
Mejor respuesta

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  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.env.cr.commit()

Avatar
Descartar
Mejor respuesta

The following code works for me in Odoo v11.0:

self.env['stock.location']._parent_store_compute()
self.env.cr.commit()

Avatar
Descartar
Mejor respuesta

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

Avatar
Descartar
Autor Mejor respuesta

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.

Avatar
Descartar
Mejor respuesta

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.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
may 25
825
3
mar 25
1096
1
may 24
1944
2
dic 22
14187
5
abr 20
4803