Entering sales order; SQL error, possibly due to apostrophe/single-quote

[dave@…]

Hi,

When creating a sales order I get the following SQL error. Once I remove the apostrophe/single-quote from the sales order line entry then it submits just fine. Thanks for a great product!

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 's Test', 1, 0, 4.95, 5.45, 1, 0, ' at line 20

Statement: INSERT INTO lineitems( invoiceid, productid, memo, taxable, unitweight, unitcost, unitprice, quantity, displayorder, createdby, creationdate, modifiedby, modifieddate ) VALUES ( 1019, 8, 'Premise wiring - Jack - 8P8C CAT5e: Terry's Test', 1, 0, 4.95, 5.45, 1, 0, 100, NOW(), 100, NOW() )

[brieb]

Is this still broken in v0.98?

[dave@…]

Hi, unfortunately I cannot say. I stopped using it when I started using Freshbooks. I hope to move back to phpBMS at some point, though.