[freeside-devel] mysql 5

[Jason Thomas]

Hi all,

Here's a couple of patches to get freeside working with mysql 5.

This works but I'm not 100% sure its the right solution.


--- select-state.html.orig	2006-08-18 14:17:01.000000000 +1000
+++ select-state.html	2006-08-18 14:17:56.000000000 +1000
@@ -14,7 +14,8 @@
 %     map { $_->state }
 %     qsearch( 'cust_main_county',
 %              { 'country' => $opt{'country'} },
-%              'DISTINCT ON ( state ) *',
+%              '*',
+%              'GROUP BY state',
 %            )
 %   ) {
 %



--- select-country.html.orig	2006-08-18 14:29:08.000000000 +1000
+++ select-country.html	2006-08-18 14:30:28.000000000 +1000
@@ -60,7 +60,7 @@
 % foreach my $country (
 %     sort { ($b eq $countrydefault) <=> ($a eq $countrydefault) or $a cmp $b }
 %     map { $_->country }
-%     qsearch( 'cust_main_county',{}, 'DISTINCT ON ( country ) *', )
+%     qsearch( 'cust_main_county',{}, '*', 'GROUP BY country', )
 %   ) {
 %
 

-- 
Jason Thomas
Link Innovations - 02 9634 0400
http://www.linkinnovations.com/