Thread: Shipping State Bug

In ver 8.0.1.1. you can have a state with no country. We use Other (Non US) for all countries bar the USA.

However in ver 8.0.1.2. this breaks the shipping options! You have to assign a state to a country.

I don't really want to assign a new Other (Non US) for every country in the world. Is there a fix to this?

Has no one ran into this?

The only way I can get around this is by editing out lines 3665 to 3672 in ShoppingCart.aspx
Should be fine as we only check shipping on country. What changed in the code that meant every country needs to be assigned a state or was it always like that?

C#/VB.NET Code:

StringBuilder shipsql = new StringBuilder(4096);
                        shipsql.Append("select * from ShippingMethod  with (NOLOCK)  where IsRTShipping=0 ");
                        //if (!ShippingMethodToStateMapIsEmpty && !ShippingMethodToCountryMapIsEmpty)
                        //{
                        //    shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap  with (NOLOCK)  where StateID=" + AppLogic.GetStateID(FirstItemShippingAddress.State, AppLogic.GetCountryID(FirstItemShippingAddress.Country)).ToString() + ")");
                        //}
                        //else if (!ShippingMethodToStateMapIsEmpty)
                        //{
                        //    shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToStateMap  with (NOLOCK)  where StateID=" + AppLogic.GetStateID(FirstItemShippingAddress.State).ToString() + ")");
                        //}

                        if (!ShippingMethodToCountryMapIsEmpty)
                        {
                            shipsql.Append(" and ShippingMethodID in (select ShippingMethodID from ShippingMethodToCountryMap  with (NOLOCK)  where CountryID=" + AppLogic.GetCountryID(FirstItemShippingAddress.Country).ToString() + ")");
                        }
                        shipsql.Append(" order by Displayorder");
                        int i = 1;
                        int zeroShipCostCountThatShouldBeFiltered = 0;