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

ivan ivan at 420.am
Tue Mar 19 19:24:14 PST 2002


On Tue, Mar 19, 2002 at 10:01:03PM -0000, jbarnes at onsatnet.com wrote:
> The exact result from mysql was
> 
> mysql> SELECT COUNT(*) from cust_main_county;
> +----------+
> | COUNT(*) |
> +----------+
> |        0 |
> +----------+
> 1 row in set (0.00 sec)
> 
> mysql>
> 
> I guess the question I should be asking is,
> When fs-setup runs, where does it pull the
> info for the State/county/country from?

fs-setup includes all of the two-letter country codes, as well as state
code for US and AU.  If it didn't populate your cust_main_county table, no
use trying to use the web interface - start over and run fs-setup again.
Once fs-setup completes sucessfully, the cust_main_county table will be
populated and you won't get the error below.  Good luck!

> 
> Thanks again,
> James
> 
> ivan <ivan at 420.am> said:
> 
> > 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
> > 
> 
> 
> 
> -- 
> 
> 
> 

-- 
_ivan



More information about the freeside-users mailing list