According to the official ISO codes linked in the first post, 4 more countries need to be updated:
Code:
UPDATE `#__osmembership_countries` SET
`country_3_code` = 'BLM',
`country_2_code` = 'BL'
WHERE `id` =242;
Code:
UPDATE `#__osmembership_countries` SET
`country_3_code` = 'JEY',
`country_2_code` = 'JE'
WHERE `id` = 241;
Code:
UPDATE `#__osmembership_countries` SET `name` = 'Timor-Leste',
`country_3_code` = 'TLS',
`country_2_code` = 'TL'
WHERE `id` = 240;
Code:
UPDATE `#__osmembership_countries` SET `name` = 'Bonaire, Sint Eustatius and Saba',
`country_3_code` = 'BES',
`country_2_code` = 'BQ'
WHERE `id` = 243;
