Ticket #323 (closed defect: worksforme)
Invoice Recur Errors
| Reported by: | scottm@… | Owned by: | brieb |
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | phpbms | Version: | 0.96 |
| Keywords: | Cc: |
Description
Following error in my logs.... Invoices will NOT recur...
Mysql 5.0.51a php 5.2.6 On Fedora 10
Error in phpbms system log
ERROR cron.php -420: Database Error 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 't forget to Protect you Data with OPENRSM CloudBackup? - http://cloudbackup.openr' at line 1<br /><br />Statement: INSERT INTO invoices (clientid, type, statusid, statusdate, assignedtoid, readytopost, ponumber, orderdate, invoicedate, requireddate, leadsource, address1, address2, city, state, postalcode, country, weborder, webconfirmationno, discountid, discountamount, totaltni, taxareaid, taxpercentage, totaltaxable, tax, shippingmethodid, totalweight, trackingno, shipping, totalcost, totalti, amountpaid, paymentmethodid, ccexpiration, ccnumber, ccverification, bankname, checkno, routingnumber, accountnumber, transactionid, printedinstructions, specialinstructions, shiptoname, shiptoaddress1, shiptoaddress2, shiptocity, shiptostate, shiptopostalcode, shiptocountry, billingaddressid, shiptoaddressid, shiptosameasbilling, createdby,creationdate) VALUES ('6', 'Order', '4', '2009-04-01', '0', '0', 'voice', '2009-04-01', NULL, '2008-09-15', 'Friend', '25505 Colburn Road', NULL, 'Lees Summit', 'MO', '64086', 'US', NULL, NULL, '0', '0', '50', '0', '0', '0', '0', '0', '0', NULL, '0', '0', '50', '0', '8', NULL, '**', NULL, NULL, NULL, NULL, NULL, NULL, 'Don't forget to Protect you Data with OPENRSM CloudBackup? - http://cloudbackup.openrsm.com/index.php', NULL, NULL, '25505 Colburn Road', NULL, 'Lees Summit', 'MO', '64086', 'US', '6', '6', '0', -3, NOW());
