[freeside] error during administration: zero-length string

[ivan at 420.am]

PostgreSQL 7.3 contained changes which made it incompatible with
Freeside 1.4.0.  Use PostgreSQL 7.2.x (I think 7.2.3 is the one with the
security fixes, though lots of distros backported them) with Freeside
1.4.0, or try a 1.4.1 beta.

-- 
_ivan


On Mon, Feb 03, 2003 at 01:53:03PM +0800, Johann Vincent Paul Tagle wrote:
> I just installed Freeside 1.4.0 using Apache::ASP version 2.49 and
> Postgresql version 7.3.1.  When I start the configuration (Click "Add a
> new service definition), I get this on my browser:
> 
> Errors Output 
> Error executing "SELECT * FROM part_svc_column WHERE ( svcpart IS NULL
> OR svcpart = '' ) AND columnname = ?": ERROR: pg_atoi: zero-length
> string at /usr/local/apache/htdocs/aspdocs/edit/part_svc.cgi line 173 ,
> /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1489 
> 
> The shell where I run postgresql also reports as error:
> 
> ERROR: pg_atoi: zero-length string
> 
> In Apache error logs, I get:
> 
> DBD::Pg::st execute failed: ERROR:  pg_atoi: zero-length string at
> /usr/lib/perl5/site_perl/5.6.1//FS/Record.pm line 268.
> [Mon Feb  3 13:41:49 2003] [error] [asp] [13917] [error] Error executing
> "SELECT * FROM part_svc_column WHERE ( svcpart IS NULL OR svcpart = '' )
> AND columnname = ?": ERROR:  pg_atoi: zero-length string at
> /usr/local/apache/htdocs/aspdocs/edit/part_svc.cgi line 173 <--> ,
> /usr/lib/perl5/site_perl/5.6.1/Apache/ASP.pm line 1489
> 
> Summary of installation:
> 1.  Freeside version 1.4.0
> 2.  Apache::ASP version 2.49
> 3.  Postgresql version 7.3.1
> 4.  OS: RedHat Linux 7.3 kernel 2.4.18-3
> 5.  Perl version 5.6.1
> 6.  DBI version 1.32
> 7.  DBD::Pg version 1.21
> 
> Thanks in advance for the assistance.
> 
> Johann
> 

-- 
_ivan