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

[ivan at 420.am]

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