[freeside-devel] 1.4.0pre6

[Dave Burgess]

ivan wrote:

> 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:
>

These subselects are not working.

I'll get back to you on the mysql syntax for these selects.



>
> 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