[freeside] Install SQL problem with Invoices

[ivan at 420.am]

> Mysql 2.23.48 (-Max-Log)

(probably 3.23.48)

> Did I miss something in the setup I am not aware of, or is this something 
> dealing with using MySQL instead of postgresql?
> 
The installation instructions said:

  MySQL versions before 4.1 do not support standard SQL subqueries and are 
  NOT SUPPORTED. If you are a developer who wishes to contribute MySQL 
  3.x/4.0 support, see ticket #438 in the bug-tracking system and ask on 
  the -devel mailing list. 

Please read the fine manual before bothering the mailing list.

-- 
_ivan


On Fri, Aug 23, 2002 at 08:35:50AM -0600, gdavis at bigskynetwork.com wrote:
> 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/

-- 
_ivan