Skip to content

vt7: Recent Foreign Key changes can't save a Product to a Quote.

Tue May 16 14:44:36 2017,117 [21465] DEBUG VT - Prepared sql query being executed : INSERT INTO vtiger_inventoryproductrel(id, productid, sequence_no, quantity, listprice, comment, description, purchase_cost, margin) VALUES(?,?,?,?,?,?,?,?,?) Tue May 16 14:44:36 2017,117 [21465] DEBUG VT - Prepared sql query parameters : [240,243,1,1,100.00,,,0,100] Tue May 16 14:44:36 2017,143 [21465] INFO VT - PearDatabase ->ADODB error Query Failed:INSERT INTO vtiger_inventoryproductrel(id, productid, sequence_no, quantity, listprice, comment, description, purchase_cost, margin) VALUES(?,?,?,?,?,?,?,?,?)::->[1452]Cannot add or update a child row: a foreign key constraint fails (vtiger_inventoryproductrel, CONSTRAINT fk_invoiceid_vtiger_inventoryproductrel FOREIGN KEY (id) REFERENCES vtiger_invoice (invoiceid) ON DELETE CASCADE)