Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem converting Contract quotation into Order
05-24-2012, 10:33 PM
Post: #1
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?
Find all posts by this user
Quote this message in a reply
05-24-2012, 11:13 PM
Post: #2
RE: Problem converting Contract quotation into Order
Hi,

It's a version merge problem. Please replace the original files with the attachment.

Hope it's helpful.

Best regards!

Exson

(05-24-2012 10:33 PM)turpsy Wrote:  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?


Attached File(s)
.php  DeliveryDetails.php (Size: 52.07 KB / Downloads: 1)
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)