Other SQL import of countries for country custom field

[Brent W]

Does anyone have a working query for this: https://xenforo.com/community/threads/country-custom-field-made-easy.21451/

The query in the txt file no longer works.

 

[Naz]

Works fine for me, just need to make sure you manually save the custom field after you've executed the query to rebuild the cache.

 

[Brent W]

Hmm will try again and post error I get in a few.

 

[Brent W]

Not sure what I was doing wrong previously but it worked this time.