[freeside] Error: Unknown state/county/country:

[ivan]

Sounds like your cust_main_county table didn't get created.  Is there
anything in there?

  SELECT COUNT(*) from cust_main_county

The cust_main_county table should have been populated by fs-setup.

On Tue, Mar 19, 2002 at 05:14:52PM -0000, jbarnes at onsatnet.com wrote:
> Ivan,
> 
> Here is a direct copy and paste of the results:
> 
> mysql> SELECT * FROM cust_main_county WHERE state = "UT" AND country = "US";
> Empty set (0.00 sec)
> 
> mysql>
> 
> Thanks
> James
> 
> ivan <ivan at 420.am> said:
> 
> > post the exact results of:
> > 
> > SELECT * FROM cust_main_county WHERE state = "UT" AND country = "US";
> > 
> > On Mon, Mar 18, 2002 at 09:37:56PM -0000, jbarnes at onsatnet.com wrote:
> > > Hello,
> > > 
> > > I am using freeside v 1.3.1 on Red Hat Linux 7.2 with
> > > Perl 5.6.0 and mysql 3.23.49a and DBD.
> > > I have verified that all of the software freeside depends
> > > on is installed correctly and functioning.
> > > I have scoured the web, the documentation and the freeside
> > > web site but I still cannot find a solution to my problem:
> > > When I attempt to add a new customer I get the following error
> > > reported in the browser
> > > 
> > > Error: Unknown state/county/country: UT//US
> > > 
> > > and in my apache error logs I get the following
> > > 
> > > [Mon Mar 18 14:26:46 2002] cust_main.cgi: Use of uninitialized value in
> > > concatenation (.) at /usr/lib/perl5/site_perl/5.6.0/FS/svc_acct.pm line
> 416.
> > > 
> > > I can see from searching the user mailing list archive 
> > > that a couple of others have had this same issue and
> > > they have been reffered to an FAQ that has information
> > > on how to fix this. I have searched high and low but I
> > > cannot find the FAQ in question. Does such a thing exist
> > > or have I misunderstood the previous answers?
> > > 
> > > Thanks
> > > James
> > 
> > -- 
> > _ivan
> > 
> 
> 
> 
> -- 
> 
> 
> 

-- 
_ivan