Re: DATABASE ERROR

null@example.com (seahawk) — Fri, 16 Aug 2013 06:49:34 +0000

Thank You.

Re: DATABASE ERROR

null@example.com (itronics) — Thu, 15 Aug 2013 16:24:54 +0000

This is MySQL bug, which is avoided in latest FA 2.3.17. You can also fix it manually in your sources removing the space between ABS and parethesis (line 44 in file rep108.php).
Janusz

DATABASE ERROR

null@example.com (seahawk) — Wed, 14 Aug 2013 11:11:29 +0000

I have entered new client, did direct invoice, received and allocated payment. When I want to print statement for client on outstanding amount I get the following message if I do not select Yes to "show also allocated". If I select Yes, the statement disappears.

DATABASE ERROR : No transactions were returned
error code : 1305
error message : FUNCTION aquilla1_Front.ABS does not exist
sql that failed was : SELECT 0_debtor_trans.*, (0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) AS TotalAmount, 0_debtor_trans.alloc AS Allocated, ((0_debtor_trans.type = 10) AND 0_debtor_trans.due_date < '2013-08-14') AS OverDue FROM 0_debtor_trans WHERE 0_debtor_trans.tran_date <= '2013-08-14' AND 0_debtor_trans.debtor_no = '48' AND 0_debtor_trans.type <> 13 AND ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) > 1e-6 AND ABS (ABS(0_debtor_trans.ov_amount + 0_debtor_trans.ov_gst + 0_debtor_trans.ov_freight + 0_debtor_trans.ov_freight_tax + 0_debtor_trans.ov_discount) - alloc) > 1e-6 ORDER BY 0_debtor_trans.tran_date

If I try and email the statement it gives me a message:

You have no email selected for this customer, but I just emailed the invoice to the customer.

any assistance would e valued.

regards

Wynand

FrontAccounting forum — DATABASE ERROR

Re: DATABASE ERROR

Re: DATABASE ERROR

DATABASE ERROR