SET v_subdivision_name = '';
SET v_city_name = '';
--- SELECT country_iso_code,subdivision_iso_name,city_name INTO v_country_iso_code, v_subdivision_name v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
+ SELECT country_iso_code,subdivision_iso_name,city_name INTO v_country_iso_code, v_subdivision_name v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
IF v_country_iso_code != '' THEN
SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_country_iso_code;