[freeside] Help with Add a new service and Add a new export... they do not work
ivan at 420.am
ivan at 420.am
Sun Jan 12 22:21:05 PST 2003
hmm, this fix for Pg 7.3 was supposed to have made it into 1.4.1beta6
===================================================================
RCS file: /home/cvs/cvsroot/freeside/httemplate/edit/part_svc.cgi,v
retrieving revision 1.32
retrieving revision 1.33
diff -u -r1.32 -r1.33
--- freeside/httemplate/edit/part_svc.cgi 2002/10/25 13:39:02 1.32
+++ freeside/httemplate/edit/part_svc.cgi 2002/12/16 21:52:01 1.33
@@ -160,7 +160,8 @@
$html .= '<TD><INPUT TYPE="checkbox"'.
' NAME="exportnum'. $part_export->exportnum. '" VALUE="1" ';
$html .= 'CHECKED'
- if qsearchs( 'export_svc', {
+ if ( $clone || $part_svc->svcpart ) #null svcpart search causing error
+ && qsearchs( 'export_svc', {
exportnum => $part_export->exportnum,
svcpart => $clone || $part_svc->svcpart });
$html .= '>'. $part_export->exportnum. ': '. $part_export->exporttype.
On Sun, Jan 12, 2003 at 05:35:08PM -0700, JPP wrote:
> 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
>
--
_ivan
More information about the freeside-users
mailing list