Some countries are missing and this is one way to add them to your osclass.
1. Download and open with a text editor one of the countries from Geo
It should have the format similar to the one pasted below.
A
REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_slug) VALUES
('ZA', 'South Africa', 'south-africa');
B
REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES
(782117, 'za', 'Eastern Cape', 1, 'eastern-cape');
C
REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug) VALUES
(451918, 782117, 'za', 'Willowvale', 1, 'willowvale'),
(451919, 782117, 'za', 'Uniondale', 1, 'uniondale'),
2. You have t_country , t_region , t_city
Find from internet an updated geo for your country, region, city. Check this one which is old
https://github.com/prograhammer/countries-regions-cities/blob/master/world.sql.gz3. Update the .sql file as follows
a - ('ZA', 'South Africa', 'south-africa'); This should be your country code, country name, country name in small letters with word joined with a hyphen e.g south-africa
When done run the query on your mysql control panel where your osclass is installed. Take care backup the whold database first, i prefer doing it twice.
b- Updating region 5 values (782117, 'za', 'Eastern Cape', 1, 'eastern-cape');
i) replace value 1 with NULL because the column pk_i_id is auto_increment meaning it will generate the id for you
ii) value 2 is your country code in lower cases
iii) value 3 is your region name
iV) value 4 is 1 which means it will be enabled and available for selection
v) value 5 is your region name in lowercases join words with a hyphen like eastern-cape
When done run the query on your mysql control panel where your osclass is installed. Take care backup the whold database first, i prefer doing it twice.
c- Updating 6 values of t_city on the .sql file (451918, 782117, 'za', 'Willowvale', 1, 'willowvale'),
i) replace value 1 with NULL
ii) replace value 1 with your region id e.g. 782117 if from region section. Where do you get this id? After running mysql update query in section b-, you will have the region ids auto-generated.
iii) value 3 is your country code in lowercases
iv) value 4 is your city name
v) value 5 make it 1 to enable the town
vi) value 6 is your city name in lowercases words joined with a hyphen e.g. johannesburg-south
When done run the query on your mysql control panel where your osclass is installed. Take care backup the whold database first, i prefer doing it twice.
Then test your osclass application to see that all is well. If there are big problems reinstall your backups and contact me to help.
I hope this will help.
