[freeside] error adding service definition

[Tony Carter]

Randall,
At the bottom I did indicate that I'm running freeside-1.4.0. Is 1.4.1 (RC5)
stable? Is anyone else on the list using it in production?

-Tony

> -----Original Message-----
> From: Randall Lucas [mailto:rlucas at tercent.net]
> Sent: Thursday, July 24, 2003 5:49 PM
> To: ivan-freeside at sisd.com
> Subject: Re: [freeside] error adding service definition
>
>
>
> Tony,
>
> Are you running the very latest 1.4.1 (RC5)?  A fix was put in during
> the release candidate testing cycle for at least one of these pg 7.3
> fubars.
>
> If you are running the latest, report it in RT -- else upgrade...
>
> Best,
>
> Randall
>
>
> On Thursday, July 24, 2003, at 04:16 PM, Tony Carter wrote:
>
> > Ivan, After researching an "adding service definition" error , I came
> > across
> > your reply to someone else having the same problem  (
> > http://www.sisd.com/freeside/list-archive/msg03265.html ). I think I
> > may
> > have found a bug.
> >
> > The offending SQL statement is SELECT * FROM part_svc_column WHERE (
> > svcpart
> > IS NULL OR svcpart = '' )...
> >
> > The field type of part_svc_column.svcpart is an integer but part of
> > the sql
> > statement  performs a comparison valid only for a *string* field type.
> > The
> > problem part of the statement is "OR svcpart = ''".
> >
> > I can't move back to any db prior to 7.3.3 because of the boat load of
> > security issues. Would you recommend a fix for this.
> >
> > Thanks,
> > Tony
> >
> >
> > My info
> > ------------------------
> >
> > "View/Edit service definitions" and click "Add a new service
> > definition", I
> > get the following error.
> >
> > Error executing "SELECT * FROM part_svc_column WHERE ( svcpart IS NULL
> > OR
> > svcpart = '' )
> > AND columnname = ?": ERROR: pg_atoi: zero-length string at
> > /var/www/html/edit/part_svc.cgi line 173 ,
> > /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1488
> >
> > environment: freeside-1.4.0, Linux RH 7.3., psql 7.3.3
> >
> >
> > SELECT * FROM part_svc_column WHERE ( svcpart IS NULL OR svcpart = ''
> > ) AND
> > columnname = ?;
> >
>
>