[freeside] 1.4.0pre6

Shane Chrisp shane at 2000cn.com.au
Mon Dec 17 10:07:29 PST 2001


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




More information about the freeside-users mailing list