[freeside] Error in cust_main.cgi

[Dave Burgess]

I was going to try and fix it, but I got wrapped up in a Corporate Merger and
haven't had time to reverse engineer it.

The problem is the sub-query (there are a few of them).  Basically, we (the
MySQL users) need to work out how to return an equivalent dataset compared to
the one these queries return from PostgreSQL.  I kind of fixed one of them (some
of the field names were over-qualified, so it isn't a complete fix) but the rest
exceeded my available time.

Dave

Edward Shabotinsky wrote:

> I see...
> yes i do using mysql, but it's fine it's only a metter of syntax error :-)
> i thought some one allready fixed that :-)
> so i guess i have to do that, ohh.
>
> Edward Shabotinsky
> System Engineer
> BritesiteINet Inc.
> ---------------------------------
> www.bsinet.net
> lanshark at bsinet.net
> ----------------------------------
> ----- Original Message -----
> From: "Kristian Hoffmann" <khoff at pc-intouch.com>
> To: <ivan-freeside at sisd.com>
> Sent: Thursday, January 31, 2002 7:49 PM
> Subject: Re: [freeside] Error in cust_main.cgi
>
> > 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
> > >
> > >
> > >
> >