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

jbarnes at onsatnet.com jbarnes at onsatnet.com
Tue Mar 19 14:01:06 PST 2002


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?

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
> 



-- 






More information about the freeside-users mailing list