Problem converting Contract quotation into Order
Hi,
Please i need to resolve a problem ASAP.
I tried converting a contract quotation into an order but i get the following error (error is at DeliveryDetails.php):
Database Error : Could not insert the contract bill of materials
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<<<<<<< .mine '31-12-2037', quantity ======= ' at line 13
Database SQL Failure : The SQL that failed to update the contract status was
INSERT INTO bom (parent, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity) SELECT contractref, stockid, workcentreadded, 'LAG', '2012-05-24', <<<<<<< .mine '31-12-2037', quantity ======= '31-12-2099' >>>>>>> .r4665 FROM contractbom WHERE contractref='LASGOJO003'
does anyone have a solution to this problem?
|