I created dropdown, and changed source_model column in SQL
catalog/product_attribute_source_countryofmanufacture
My new attribute shows country list in backend, but when I select country and save product value disappears.
All parameters of dropdown are same like country_of_manufacture attribute.
What might be a problem for that? I’m using 1.7.0.2 ver.
check whether it returns or not
SELECT * FROM eav_attribute WHERE attribute_code = 'country_of_manufacture';
it's better to create attribute using installer for this you can refer below link
https://github.com/benmarks/magento-mirror/blob/1.7.0.2/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.1-1.6.0.0.2.php#L28