Problem Adding New Customer

[Ivan Kohler]

On Sun, Dec 27, 1998 at 06:49:36PM -0500, Bao C. Ha wrote:
> 
> I have just installed Freeside 1.1.6.  When I tried to add a new
> customers, I got the following error message,
> 
> Your update did not occur because of the following error: 
> Unknown state/county/country 
> Hit the Back button in your web browser, correct this mistake, and submit
> the form again.   

My bad.  I made this change on the development tree a while back.  A patch
is attached; this will become 1.1.7 shortly.

> It turns out that I have added two counties of GA to the tax tables.
> How do I remove the counties, and just use GA?  I don't have any
> thing that are taxable yet.

You can use the text client that comes with your SQL database (`mysql' for
MySQL, `psql' for PostgreSQL).  The graphical front ends are also nice if
you have X running.  I'm aware of `xmysql' for MySQL and `pgaccess' and
`gtksql' for PostgreSQL. 

-- 
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 --------------
# This is a patch for fs-1.1.6/site_perl/Record.pm to update it to fs-1.1.7/site_perl/Record.pm.
# It was generated by makepatch 1.93 (2.0BETA) on Tue Dec 29 00:56:14 1998.
#
# To apply this patch, chdir to source directory fs-1.1.6/site_perl/Record.pm and enter
#
#     patch -p1 -N < <this-file>

exit
# End of preamble.

# Patch input follows.
__DATA__
Index: fs-1.1.7/site_perl/Record.pm
#######  => 
*** fs-1.1.6/site_perl/Record.pm	Sat Nov  7 00:17:18 1998
--- fs-1.1.7/site_perl/Record.pm	Tue Dec 29 00:41:54 1998
***************
*** 166,174 ****
    my($sth);
    my($statement) = "SELECT * FROM $table". ( @fields
      ? " WHERE ". join(' AND ',
!         map("$_ = ". _quote($record->{$_},$table,$_), @fields)
!       )
!     : ''
    );
    $sth=$dbh->prepare($statement)
      or croak $dbh->errstr; #is that a little too harsh?  hmm.
--- 166,177 ----
    my($sth);
    my($statement) = "SELECT * FROM $table". ( @fields
      ? " WHERE ". join(' AND ',
!       map {
!         $record->{$_} eq ''
!           ? "$_ IS NULL"
!           : "$_ = ". _quote($record->{$_},$table,$_)
!       } @fields
!     ) : ''
    );
    $sth=$dbh->prepare($statement)
      or croak $dbh->errstr; #is that a little too harsh?  hmm.


End of Patch.