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

[JPP]

Hi Ivan...

Nice product. Thank you!

You say that patch should have been in the beta6 version? I had just 
downloaded that version off the site today. And it looks like 
part_export.cgi suffers from the same malady.

I will wait until you figure out what went on there and re-download the 
corrected version. I prefer to not play with CVS versions too much, but 
in this case I may have no choice since I am using PG V.7.3.

Thanks again - at least I know I am not nuts (not in this matter at least).

Jerome


ivan at 420.am wrote:

> 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
>>
>>
>