version 1.2.0 release - Can't call method "table"...

Tue Apr 13 21:41:13 PDT 1999

Sorry about this one guys; this is a bug, but it is masked if you're using
mod_perl (as I have been for the past few months).

It is fixed in the current CVS tree.  I'll make a 1.2.1 release shortly
with this and assorted other (hopefully less problematic) fixes.

A complete copy of a fixed htdocs/edit/cust_pkg.cgi is attached (too small
to bother with a diff).

On Tue, Apr 13, 1999 at 10:38:05AM -0700, Aaron L. Meehan wrote:
> I have no pointers, but I must comfirm that I'm experiencing the same
> phenomenon here.  I have a service and package definition created and
> after adding a new customer, I see the same error message when
> attempting to add the package to their account.  I did run fs-setup
> and dbdef-create.  I ran an older version for testing previously but I
> basically just started from scratch with 1.2.0 since freeside isn't in
> active use here atm.
> 
> My apache error log says the same:
> 
> [Tue Apr 13 10:25:51 1999] cust_pkg.cgi: Can't call method "table" on
> an undefined value at /usr/local/lib/site_perl/FS/Record.pm line 737.
> 
> We're running perl 5.00502, DBI-1.06 and Msql-Mysql-modules-1.2014.
> 
> Aaron
> 
> Quoting Jerry Allen (solarix at daphnis.com):
> > 
> > Greetings,
> > 
> > I am new to freeside. I have looked through the archive and have not been
> > able to solve this new install problem...
> > 
> > When trying to ( Order and cancel packages ) from the Customer View Screen
> > I get the following error:
> > ----
> > Software error:
> > 
> > Can't call method "table" on an undefined value at
> > /usr/lib/perl5/site_perl/FS/Record.pm line 737.
> > ----
> > 
> > Any pointers
> > 
> > 
> 
> -- 
> Aaron L. Meehan         aaron at coinet.com

-- 
Ivan Kohler <ivan at sisd.com> - finger for PGP key - <moc.dsis at navi> Relhok Navi
Open-source billing and administration for ISPs - http://www.sisd.com/freeside
20 4,16 * * * saytime # please don't be surprised if you find me dreaming too
-------------- next part --------------
#!/usr/bin/perl -Tw
#
# $Id: cust_pkg.cgi,v 1.7 1999/04/14 01:03:01 ivan Exp $
#
# this is for changing packages around, not editing things within the package
#
# Usage: cust_pkg.cgi custnum
#        http://server.name/path/cust_pkg.cgi?custnum
#
# started with /sales/add/cust_pkg.cgi, which added packages
# ivan at voicenet.com 97-jan-5, 97-mar-21
#
# Rewrote for new API
# ivan at voicenet.com 97-jul-7
#
# FS::Search is no more, &cgisuidsetup needs $cgi, ivan at sisd.com 98-mar-7 
#
# Changes to allow page to work at a relative position in server
# Changed to display packages 2-wide in a table
#       bmccane at maxbaud.net     98-apr-3
#
# fixed a pretty cool bug from above which caused a visual glitch ivan at sisd.com
# 98-jun-1
#
# $Log: cust_pkg.cgi,v $
# Revision 1.7  1999/04/14 01:03:01  ivan
# oops, in 1.2 tree, can't do searches until [cgi|admin]suidsetup,
# bug is hidden by mod_perl persistance
#
# Revision 1.6  1999/02/28 00:03:36  ivan
# removed misleading comments
#
# Revision 1.5  1999/02/07 09:59:18  ivan
# more mod_perl fixes, and bugfixes Peter Wemm sent via email
#
# Revision 1.4  1999/01/19 05:13:38  ivan
# for mod_perl: no more top-level my() variables; use vars instead
# also the last s/create/new/;
#
# Revision 1.3  1999/01/18 09:41:28  ivan
# all $cgi->header calls now include ( '-expires' => 'now' ) for mod_perl
# (good idea anyway)
#
# Revision 1.2  1998/12/17 06:17:04  ivan
# fix double // in relative URLs, s/CGI::Base/CGI/;
#

use strict;
use vars qw( $cgi %pkg %comment $custnum $p1 @cust_pkg 
             $cust_main $agent $type_pkgs $count %remove_pkg );
use CGI;
use CGI::Carp qw(fatalsToBrowser);
use FS::UID qw(cgisuidsetup);
use FS::Record qw(qsearch qsearchs);
use FS::CGI qw(header popurl);
use FS::part_pkg;
use FS::type_pkgs;

$cgi = new CGI;
&cgisuidsetup($cgi);

%pkg = ();
%comment = ();
foreach (qsearch('part_pkg', {})) {
  $pkg{ $_ -> getfield('pkgpart') } = $_->getfield('pkg');
  $comment{ $_ -> getfield('pkgpart') } = $_->getfield('comment');
}

if ( $cgi->param('error') ) {
  $custnum = $cgi->param('custnum');
  %remove_pkg = map { $_ => 1 } $cgi->param('remove_pkg');
} else {
  my($query) = $cgi->keywords;
  $query =~ /^(\d+)$/;
  $custnum = $1;
  undef %remove_pkg;
}

$p1 = popurl(1);
print $cgi->header( '-expires' => 'now' ), header("Add/Edit Packages", '');

print qq!<FONT SIZE="+1" COLOR="#ff0000">Error: !, $cgi->param('error'),
      "</FONT>"
  if $cgi->param('error');

print qq!<FORM ACTION="${p1}process/cust_pkg.cgi" METHOD=POST>!;

print qq!<INPUT TYPE="hidden" NAME="custnum" VALUE="$custnum">!;

#current packages
@cust_pkg = qsearch('cust_pkg',{ 'custnum' => $custnum, 'cancel' => '' } );

if (@cust_pkg) {
  print <<END;
Current packages - select to remove (services are moved to a new package below)
<BR><BR>
END

  my ($count) = 0 ;
  print qq!<TABLE>! ;
  foreach (@cust_pkg) {
    print '<TR>' if $count == 0;
    my($pkgnum,$pkgpart)=( $_->getfield('pkgnum'), $_->getfield('pkgpart') );
    print qq!<TD><INPUT TYPE="checkbox" NAME="remove_pkg" VALUE="$pkgnum"!;
    print " CHECKED" if $remove_pkg{$pkgnum};
    print qq!>$pkgnum: $pkg{$pkgpart} - $comment{$pkgpart}</TD>\n!;
    $count ++ ;
    if ($count == 2)
    {
      $count = 0 ;
      print qq!</TR>\n! ;
    }
  }
  print qq!</TABLE><BR><BR>!;
}

print <<END;
Order new packages<BR><BR>
END

$cust_main = qsearchs('cust_main',{'custnum'=>$custnum});
$agent = qsearchs('agent',{'agentnum'=> $cust_main->agentnum });

$count = 0 ;
print qq!<TABLE>! ;
foreach $type_pkgs ( qsearch('type_pkgs',{'typenum'=> $agent->typenum }) ) {
  my($pkgpart)=$type_pkgs->pkgpart;
  print qq!<TR>! if ($count == 0) ;
  my $value = $cgi->param("pkg$pkgpart") || 0;
  print <<END;
  <TD>
  <INPUT TYPE="text" NAME="pkg$pkgpart" VALUE="$value" SIZE="2" MAXLENGTH="2">
  $pkgpart: $pkg{$pkgpart} - $comment{$pkgpart}</TD>\n
END
  $count ++ ;
  if ($count == 2)
  {
    print qq!</TR>\n! ;
    $count = 0 ;
  }
}
print qq!</TABLE>! ;

#submit
print qq!<P><INPUT TYPE="submit" VALUE="Order">\n!;

print <<END;
    </FORM>
  </BODY>
</HTML>
END