ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "info@agentur-m3.de" <i...@agentur-m3.de>
Subject Re: delete product
Date Sun, 01 Feb 2015 10:15:19 GMT
Hi Anahita,

thanks, yes that is useful for me.
I try to work with product-configurations
as simple as possible!

Kind regards

Ralf


Am 01.02.2015 um 06:47 schrieb Anahita Goljahani:
> Hi,
> 
>   just so you know, you may prevent the automatic creation of keywords by
> setting "autoCreateKeywords" to "N" in Product entity.
> 
> Kind regards
> 
> Anahita
> 
> 2015-01-30 9:16 GMT+01:00 info@agentur-m3.de <info@agentur-m3.de>:
> 
>> Hi All,
>>
>> I tried to create some test products (just product_id
>> and description and a user defined PRODUCT_TYPE_ID
>> "FLEAMARKETITEM")  using  a simple method.
>>
>> ofbiz now gives me an error when deleting them.
>>
>> Pressing delete-button the data engine says:
>>
>> Delete failed (write error): org.ofbiz.entity.GenericEntityException:
>> org.ofbiz.entity.GenericDataSourceException: Exception while deleting
>> the following entity:
>> [GenericEntity:Product][productId,fleamarket(java.lang.String)] (SQL
>> Exception while executing the following:DELETE FROM OFBIZ.PRODUCT WHERE
>> PRODUCT_ID=? (DELETE on table 'PRODUCT' caused a violation of foreign
>> key constraint 'PROD_KWD_PROD_NEW' for key (fleamarket). The statement
>> has been rolled back.)) (Exception while deleting the following entity:
>> [GenericEntity:Product][productId,fleamarket(java.lang.String)] (SQL
>> Exception while executing the following:DELETE FROM OFBIZ.PRODUCT WHERE
>> PRODUCT_ID=? (DELETE on table 'PRODUCT' caused a violation of foreign
>> key constraint 'PROD_KWD_PROD_NEW' for key (fleamarket). The statement
>> has been rolled back.)))
>>
>> Also I tried with SQL:
>>
>> SQL Exception while executing the following:DELETE FROM PRODUCT WHERE
>> PRODUCT_TYPE_ID = 'FLEAMARKETITEM' (DELETE on table 'PRODUCT' caused a
>> violation of foreign key constraint 'PROD_KWD_PROD_NEW' for key
>> (fleamarket). The statement has been rolled back.)
>>
>>
>> So it seems I can't delete these items. What is going wrong?
>> How can I reset the entity state to correct relations?
>>
>>
>> Thank you!
>>
> 


Mime
View raw message