Customers cant select georgia as state of residents... appears twice on list.
Posted 17 May 2012 - 01:06 AM
Posted 17 May 2012 - 03:50 AM
By default, the state selection is NOT a drop down, which means a contribution has been added to the site to make it a drop down. I suggest checking the contribution to ensure Georgia is in the list of available states.
See my Profile (click here)
Posted 17 May 2012 - 04:22 PM
when you are making an account or adjusting one it is not drop down, but once I put GA or Georgia and update it says please select a state. then it has a drop down list. Where should I look to even begin to adjust this?
Edited by revolutionsms, 17 May 2012 - 04:33 PM.
Posted 17 May 2012 - 06:38 PM
select * from zones where zone_country_id = '223' order by zone_nameand look at the results. The most likely problem is that you have two lines for Georgia. I'd recommend backing up your zones table before deleting either line. You may want to look at other tables, like address_book, tax_rates, and zones_to_geo_zones, to figure out which line is used more. The original line looked something like
(19,223,'GA','Georgia')There is some risk here -- if you delete a line that is referenced in other tables, it can cause wonky results. Feel free to post back if you find the results confusing.
It's possible that the UPS contribution does something with zones. You might want to check for that.