[freeside] Error in cust_main.cgi

[Edward Shabotinsky]

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