[freeside] Error in cust_main.cgi

[Kristian Hoffmann]

It looks like you're using MySQL with 1.4.0pre-something.  Last I heard
MySQL support was still broken in 1.4.0 and Ivan wasn't planning on fixing
it.  It's probably just as well.  As it stands, you'll need to use
PostgreSQL instead of MySQL if you want to use freeside 1.4.0.

-Kristian

On Thu, 31 Jan 2002, Edward Shabotinsky wrote:

> Hi, all
> Does any one had error like this before?
> Looks like bad syntax.
> [Thu Jan 31 19:16:26 2002] null: DBD::mysql::st execute failed: You have an
> error in your SQL syntax near 'SELECT
>  count(*) FROM pkg_svc
> [Thu Jan 31 19:16:26 2002] null:           WHERE pkg_svc.pkgpart =
> cust_pkg.pkgpart
> [Thu Jan 31 19:16:26 2002] null: ' at line 3 at cust_pkg.cgi line 85.
> [Thu Jan 31 19:16:26 2002] [error] [asp] [248] [error] Error executing
> "SELECT COUNT(*) FROM cust_pkg  <-->     W
> HERE 0 < <-->       ( SELECT count(*) FROM pkg_svc <-->           WHERE
> pkg_svc.pkgpart = cust_pkg.pkgpart <-->
>            AND pkg_svc.quantity > ( SELECT count(*) FROM cust_svc <-->
> WHE
> RE cust_svc.pkgnum = cust_pkg.pkgnum <-->
> AND cust_svc.svcpart = pkg_svc
> .svcpart <-->                                    ) <-->       ) <-->   ":
> You have an error in your SQL syntax ne
> ar 'SELECT count(*) FROM pkg_svc <-->           WHERE pkg_svc.pkgpart =
> cust_pkg.pkgpart <--> ' at line 3 at cust
> _pkg.cgi line 85. <--> , /usr/local/lib/perl5/site_perl/5.005/Apache/ASP.pm
> line 1545
>
> Thanks.
> Edward Shabotinsky
> System Engineer
> BritesiteINet Inc.
> ---------------------------------
> www.bsinet.net
> lanshark at bsinet.net
>
>
>