Default Country Ignored

-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.4
-- Error-message(debug-mod must be tuned on) -- : Doesn't really apply to our issue currently but...

Notice: Undefined index: inches in /home/torontos/public_html/administrator/components/com_hikashop/helpers/volume.php on line 45

Notice: Undefined index: inches in /home/torontos/public_html/administrator/components/com_hikashop/helpers/volume.php on line 45

Hiya,

It seems that since updating to v2.6.0 the default country setting is being ignored. We do have an overrided address_template which I reverted with no change (all it does is move the order around a bit).

Hi Jerome,

I made the suggested change and it didn't make a difference.

Thanks Nicolas. I PM'd login info.

Hi,

The issue is due to an entry present in your table #__hikashop_zone_link, but linking to a zone which is no more existing.
So I think that you had created a new zone "UnitedStatesofAmerica" and then deleted it.

Please go in your phpMyAdmin interface and delete the entry with the "zone_child_namekey" equal to "country_UnitedStatesofAmerica_151105809". We will add check in HikaShop to avoid this kind of issues.

Hi,

Thanks for all the help. I really appreciate it.

You are correct, I do recall at some point they added a zone and removed it. It's been so long ago I can't recall the specific reason but it was something like they deleted a state and tried to fix it but ended up reinstalling to fix.

I am a bit confused though with your instructions. When I run this query I get 0 results:

SELECT *
FROM `#__hikashop_zone_link`
WHERE `zone_child_namekey` LIKE 'country_UnitedStatesofAmerica_151105809'
LIMIT 0 , 30

SELECT *
FROM `#__hikashop_zone_link`
WHERE `zone_parent_namekey` LIKE 'country_UnitedStatesofAmerica_151105809'
LIMIT 0 , 30

Hi,

Yes you have to delete these entries, the ones from the zone_parent_namekey with this value.

Thanks @all for the help. This indeed did work but before I dropped those rows I updated all of the existing orders that were using that old value.