Help with Add a new service and Add a new export... they do not work

JPP jpp at frws.com
Sun Jan 12 16:35:50 PST 2003


Greetings!!

We have been fighting these errors and even tried installing the Newest 
Beta6 version of Freeside, but the results are the same. The errors are 
as follows:
The problem is in the Configuration menus, in the SysAdmin section - I 
cannot add anything using the:
Add a new export
OR
Add a new service definition
(Will not even list that there is nothing there!)

I searched through the list as best I can and I did not see a resolution 
to this problem. Looks like an Apache::ASP problem, perhaps. But I am 
really not sure.

System Configuration is:
RedHat Linux 7.3, latest Kernel Patches
Freeside Version is: 1.4.1beta6
PostgreSQL: Newest version, just installed v.7.3
Apache::ASP: 2.49 - Newest version installed through CPAN
DBI: 1.32 - CPAN
DBD-Pg: 1.13 - CPAN
Perl: V5.8.0 (just installed, older version did the same thing)
Mod_Perl: v.1.27 - Fresh Installation
Apache: 1.3.27 - Fresh Installation
All Other Perl modules you listed as being required were installed today 
using CPAN without any errors that I could see.

We get the following errors when we try to:
Add a new export
1.  Error executing "SELECT * FROM part_export_option WHERE ( exportnum 
IS NULL OR exportnum = '' ) AND optionname = ?": ERROR: pg_atoi: 
zero-length string at /home/httpd/html/freeside/edit/part_export.cgi 
line 51 , /usr/lib/perl5/site_perl/5.6.0/Apache/ASP.pm line 1489

Apache error_log entry is the same...

Add a new  service definition
1.  Error executing "SELECT * FROM part_svc_column WHERE ( svcpart IS 
NULL OR svcpart = '' ) AND columnname = ?": ERROR: pg_atoi: zero-length 
string at /home/httpd/html/freeside/edit/part_svc.cgi line 176 , 
/usr/lib/perl5/site_perl/5.6.0/Apache/ASP.pm line 1489

Apache error_log:
[FS::Conf] SET invoice_from
DBD::Pg::st execute failed: ERROR:  pg_atoi: zero-length string at 
/usr/lib/perl5/site_perl/5.6.0//FS/Record.pm line 268.

[Sun Jan 12 17:02:54 2003] [error] [asp] [12730] [error] Error executing 
"SELECT * FROM part_export_option WHERE ( exportnum IS NULL OR exportnum 
= '' ) AND optionname = ?": ERROR:  pg_atoi: zero-length string at 
/home/httpd/html/cheapsites/edit/part_export.cgi line 51 <--> , 
/usr/lib/perl5/site_perl/5.6.0/Apache/ASP.pm line 1489
DBD::Pg::st execute failed: ERROR:  pg_atoi: zero-length string at 
/usr/lib/perl5/site_perl/5.6.0//FS/Record.pm line 268.

[Sun Jan 12 17:04:57 2003] [error] [asp] [12730] [error] Error executing 
"SELECT * FROM part_svc_column WHERE ( svcpart IS NULL OR svcpart = '' ) 
AND columnname = ?": ERROR:  pg_atoi: zero-length string at 
/home/httpd/html/cheapsites/edit/part_svc.cgi line 176 <--> , 
/usr/lib/perl5/site_perl/5.6.0/Apache/ASP.pm line 1489

 From a layman's point of view it looks like a Database was not 
populated or some other error ocurred.

Any suggestions would be greatly appreciated! Tried making several new 
databases, and followed the installation instructions to the letter 
several times. The results are the same.

Thanks!

Jerome




More information about the freeside-users mailing list