Löschen der alten Daten


#1

Hallo,

wenn ich versuche per SQL Befehl die alten Produkte und Produktgruppen zu löschen, bekomme ich folgenden Fehler. Bitte um Hilfe:

Failed to execute SQL :

SQL truncate m_product_category_trl; update public.m_product_category set ad_client_id = 99 where m_product_category_id= 2001602; update public.m_product_category set ad_client_id = 99 where m_product_category_id= 2001599; delete from public.m_product_category where m_product_category_id= 2001594; delete from public.m_product_category where m_product_category_id= 2001603; delete from public.m_product_category where m_product_category_id= 2001579; delete from public.m_product_category where m_product_category_id= 2001586; delete from public.m_product_category where m_product_category_id= 2001585; delete from public.m_product_category where m_product_category_id= 2001593; delete from public.m_product_category where m_product_category_id= 2001581; delete from public.m_product_category where m_product_category_id= 2001575; delete from public.m_product_category where m_product_category_id= 2001588; delete from public.m_product_category where m_product_category_id= 2001578; delete from public.m_product_category where m_product_category_id= 2001592; delete from public.m_product_category where m_product_category_id= 2001582; delete from public.m_product_category where m_product_category_id= 2001590; delete from public.m_product_category where m_product_category_id= 2001595; delete from public.m_product_category where m_product_category_id= 2001583; delete from public.m_product_category where m_product_category_id= 2001574; delete from public.m_product_category where m_product_category_id= 2001601; delete from public.m_product_category where m_product_category_id= 2001576; delete from public.m_product_category where m_product_category_id= 2001587; delete from public.m_product_category where m_product_category_id= 2001591; delete from public.m_product_category where m_product_category_id= 2001589; delete from public.m_product_category where m_product_category_id= 2001596; delete from public.m_product_category where m_product_category_id= 2001584; delete from public.m_product_category where m_product_category_id= 2001577; delete from public.m_product_category where m_product_category_id= 2001580; delete from public.m_product_category where m_product_category_id= 2001598; delete from public.m_product_category where m_product_category_id= 2001597; delete from public.m_product_category where m_product_category_id= 2001600; delete from public.m_product_category where m_product_category_id= 2001604;

failed : update or delete on table “m_product_category” violates foreign key constraint “mproduct_mproductcategory” on table “m_product”


#2

Hallo,
ich habe es selber hinbekommen. Schuld war webmin.
Danke trotzdem