Re: BREXIT: Set minimum order requirement for UK addresses
I had a similar problem when i was testing this. I did find a sloution but my test machine died. I'll try to reproduce again and let you know what i did. I think I changed zone_id to Null from 0 because if the country id does not have a tax rate then it assumes 0 for the zone_id and if you have any countries with the deny set then they are picked up. I'll have a more detaile look and see if i can post a suggested fix other than changing the data.
Bit of code causing issue is the select line 148.
PHP Code:
$sql = "SELECT geo_zone_description
FROM " . TABLE_GEO_ZONES . "
INNER JOIN " . TABLE_ZONES_TO_GEO_ZONES . " za USING (geo_zone_id)
WHERE zone_country_id = " . (int)$country_id . "
OR zone_id = " . (int)$zone_id . "
ORDER BY zone_id DESC";
Or Zone_id is overriding country code
Mark Brittain
http:\\innerlightcrystals.co.uk\sales\
Bookmarks