Guten Tag,
wenn ich mein Dolibarr von 20.0.2 update auf irgendetwas Neueres (Egal ob 20.0.3, 20.0.4 oder 21.0.0) habe ich folgenden Feler wenn ich eine Leistung hinzufügen möchte (Produkt hinzufügen geht problemlos!)
Hat einer einen Rat?
Fehler : Cannot add or update a child row: a foreign key constraint fails (dolibarrBaCoS
.llx_product
, CONSTRAINT fk_product_finished
FOREIGN KEY (finished
) REFERENCES llx_c_product_nature
(code
)) - UPDATE llx_product SET label = ‚ss‘, ref = ‚D00019‘, ref_ext = null, default_vat_code = null, tva_tx = 19, recuperableonly = 0, localtax1_tx = 0, localtax2_tx = 0, localtax1_type = ‚0‘, localtax2_type = ‚0‘, barcode = null, fk_barcode_type = null, tosell = 1, tobuy = 1, tobatch = 0, sell_or_eat_by_mandatory = 0, batch_mask = ‚‘, finished = 0, fk_default_bom = null, net_measure = null, net_measure_units = null, weight = null, weight_units = null, length = null, length_units = null, width= null, width_units = null, height = null, height_units = null, surface = null, surface_units = null, volume = null, volume_units = null, fk_default_warehouse = null, fk_default_workstation = null, seuil_stock_alerte = 0, description = ‚‘, url = null, customcode = ‚‘, fk_country = null, fk_state = null, lifetime = null, qc_frequency = null, note = ‚‘, note_public = null, duration = ‚h‘, accountancy_code_buy = ‚‘, accountancy_code_buy_intra = ‚‘, accountancy_code_buy_export = ‚‘, accountancy_code_sell= ‚‘, accountancy_code_sell_intra= ‚‘, accountancy_code_sell_export= ‚‘, desiredstock = 0, cost_price = null, fk_unit= NULL, price_autogen = 0, fk_price_expression = NULL, fk_user_modif = 1, mandatory_period = 0 WHERE rowid = 479