c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <698023@xxxxxxxxxxxxxxxxxx>]

Hello everyone,

The problem here is not the fact that there is an error message in the server console, which is totally normal and in fact helps to understand the issue.
The problem is that even after deleting all products in a given category, the category cannot be deleted because the product.templates have not been deleted and still reference it.

This needs to be fixed in the product module, for example with a custom
unlink() of the product.product object, which unlink() the
product.template as well if the last product.product for this template
is being deleted. This way when all products in a category have been
deleted, the category can be deleted too.

Workaround: create a menu to open the list of product.templates and
cleanup the templates directly from there: open the product.template
object via Administration>Customization>Database structure>Objects, and
click on 'Create a menu'

** Changed in: openobject-server
       Status: Fix Released => Confirmed

** Changed in: openobject-server
     Assignee: OpenERP's Framework R&D (openerp-dev-framework) => OpenERP R&D Addons Team 1 (openerp-dev-addons1)

** Project changed: openobject-server => openobject-addons

** Changed in: openobject-addons
    Milestone: 6.0 => None

** Summary changed:

- null value in column "categ_id" violates
+ [trunk] impossible to delete a product category, even empty, if it contained products previously

** Changed in: openobject-addons
    Milestone: None => 6.0

-- 
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/698023

Title:
  [trunk] impossible to delete a product category, even empty, if it
  contained products previously

Status in OpenObject Addons Modules:
  Confirmed

Bug description:
  In product management module. Add a product, and remove it.
  but, It raise an exception when I remove the product's category.

  The Exception's text:
  null value in column "categ_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."product_template" SET "categ_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "categ_id""

  I get some information from the PostgreSQL...   the product.template
  object 's data is not be removed when the product.product object
  removed.