Install SQL problem with Invoices

[gdavis at bigskynetwork.com]

Hi all.  I have just installed Freeside 1.4.0. Here are my Specs:

Linux 2.4.18 on a i686
Mysql 2.23.48 (-Max-Log)
Apache::ASP
Perl 5.6.1
All the packages from CPAN installed as per the instructions in the Freeside 
Docs.

I a able to create Customers, create bills, and create payments, but whenever I 
click on any of the invoice reports I get the following error:

Errors Output 
Error executing "SELECT COUNT(*), sum(charged), sum(charged - ( select coalesce
(sum(amount),0) from cust_bill_pay where cust_bill_pay.invnum = 
cust_bill.invnum ) - ( select coalesce(sum(amount),0) from cust_credit_bill 
where cust_credit_bill.invnum = cust_bill.invnum )) FROM cust_bill WHERE 0 != 
charged - ( select coalesce(sum(amount),0) from cust_bill_pay where 
cust_bill_pay.invnum = cust_bill.invnum ) - ( select coalesce(sum(amount),0) 
from cust_credit_bill where cust_credit_bill.invnum = cust_bill.invnum )": You 
have an error in your SQL syntax near 'select coalesce(sum(amount),0) from 
cust_bill_pay wher' at line 1 at cust_bill.cgi line 
39. , /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1423 
Debug Output 
Error executing "SELECT COUNT(*), sum(charged), sum(charged - ( select coalesce
(sum(amount),0) from cust_bill_pay where cust_bill_pay.invnum = 
cust_bill.invnum ) - ( select coalesce(sum(amount),0) from cust_credit_bill 
where cust_credit_bill.invnum = cust_bill.invnum )) FROM cust_bill WHERE 0 != 
charged - ( select coalesce(sum(amount),0) from cust_bill_pay where 
cust_bill_pay.invnum = cust_bill.invnum ) - ( select coalesce(sum(amount),0) 
from cust_credit_bill where cust_credit_bill.invnum = cust_bill.invnum )": You 
have an error in your SQL syntax near 'select coalesce(sum(amount),0) from 
cust_bill_pay wher' at line 1 at cust_bill.cgi line 
39. , /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1423

Did I miss something in the setup I am not aware of, or is this something 
dealing with using MySQL instead of postgresql?

Any help here would be great.  

Thanx!

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/