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;