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)