[freeside] 1.4.0pre6

[ivan]

I received an equivalent query for the third but it'll take a little more
work to make httemplate/search/svc_acct.cgi use it as it doesn't have a
single table in the FROM clause.

I didn't receive anything for the first two queries.

1.4.0pre7 feels like it should come out soon-ish.  It would be nice if it
had working MySQL support again.

On Tue, Dec 18, 2001 at 02:06:58AM +0800, Shane Chrisp wrote:
> Ivan,
> 
>  Have you confirmed that the SQL queries below work or are you still needing
> to confirm/rewrite them to
> suit MySQL? Im happy to give them a look if no one else has had a chance.
> 
> Shane
> 
> -----Original Message-----
> From: ivan [mailto:ivan at 420.am]
> Sent: Monday, 3 December 2001 8:49 PM
> To: ivan-freeside at sisd.com; ivan-freeside-devel at sisd.com
> Subject: [freeside] 1.4.0pre6
> 
> 
> 1.4.0pre6 is on the web site.
> 
> This release adds the "maxrecordsperpage" configuration option and paged
> browse screens.  It should perform much better with large data sets.  Try
> setting "maxrecordsperpage" to 100 or 200 or so.
> 
> No schema changes are required if upgrading from pre5, just edit the
> top-level Makefile for your document root and run `make install', then
> restart Apache and freeside-queued.
> 
> This release might be broken with MySQL (specifically the customer browse,
> account browse, and package browse pages).  Assistance testing/rewriting
> the following queries for MySQL appriciated:
> 
> SELECT * FROM cust_main
>       WHERE 0 < ( SELECT COUNT(*) FROM cust_pkg
>                     WHERE cust_pkg.custnum = cust_main.custnum
>                       AND ( cust_pkg.cancel IS NULL
>                             OR cust_pkg.cancel = 0
>                           )
>                 )
>          OR 0 = ( SELECT COUNT(*) FROM cust_pkg
>                     WHERE cust_pkg.custnum = cust_main.custnum
>                 )
> 
> 
> SELECT * FROM cust_pkg
>     WHERE 0 <
>       ( SELECT count(*) FROM pkg_svc
>           WHERE pkg_svc.pkgpart = cust_pkg.pkgpart
>             AND pkg_svc.quantity > ( SELECT count(*) FROM cust_svc
>                                        WHERE cust_svc.pkgnum =
> cust_pkg.pkgnum
>                                          AND cust_svc.svcpart =
> pkg_svc.svcpart
>                                    )
>       )
> 
> 
> SELECT * FROM svc_acct
>     WHERE 0 <
>       ( SELECT count(*) FROM cust_svc
>           WHERE cust_svc.svcnum = svc_acct.svcnum
>             AND pkgnum IS NULL
>       )
> 
> 
> --
> _ivan
> 

-- 
_ivan