1.4.0pre6

[ivan]

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