c2c-oerpscenario team mailing list archive

[Sikiwawa <802526@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I tried to create a new product of type stockable
The real stock was set by clicking on the update button next to it
however, the apply button opens a new webpage where it shows that the product was directly edited
problem is that this unwanted and still-yet-to-be-edited instance cannot be deleted giving the following error:

ERROR:db.cursor:bad query: delete from product_template where id IN (4)
Traceback (most recent call last):
  File "/usr/local/openerp-server-6.0.2/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
IntegrityError: null value in column "product_id" violates not-null constraint
CONTEXT:  SQL statement "UPDATE ONLY "public"."stock_move" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""

Kindly note that the inventory entry corresponding to this undesired
product instance can be successfully deleted

platform: ubuntu
version used: 6.0.2

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/802526

Title:
  update button in new product page->real stock value creates directly a
  product which cannot be deleted

Status in OpenERP Server:
  New

Bug description:
  I tried to create a new product of type stockable
  The real stock was set by clicking on the update button next to it
  however, the apply button opens a new webpage where it shows that the product was directly edited
  problem is that this unwanted and still-yet-to-be-edited instance cannot be deleted giving the following error:

  ERROR:db.cursor:bad query: delete from product_template where id IN (4)
  Traceback (most recent call last):
    File "/usr/local/openerp-server-6.0.2/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  IntegrityError: null value in column "product_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."stock_move" SET "product_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "product_id""

  Kindly note that the inventory entry corresponding to this undesired
  product instance can be successfully deleted

  platform: ubuntu
  version used: 6.0.2

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-server/+bug/802526/+subscriptions