[freeside] Error in cust_main.cgi

[ivan]

On Thu, Jan 31, 2002 at 08:01:54PM -0600, Edward Shabotinsky wrote:
> I see...
> yes i do using mysql, but it's fine it's only a metter of syntax error :-)

It's not a syntax error, it's MySQL lack of support for subqueries.  If
the MySQL community doesn't step forward soon and contribute support to
work around MySQL's lack of standard SQL features, Freeside 1.4.0 will not
support MySQL.

See http://www.sisd.com/freeside/list-archive/msg02482.html for the exact
SQL queries.

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

-- 
_ivan