I installed Magento 3rd party "Brands" extension update, prior to installation I disabled cache and right after installation my homepage is showing an error:
Error in file: "/home/directory/public_html/site/app/code/local/extension/brandsextension/sql/brandsextension_setup/mysql-2-1-1-2" - SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'position_brand'
I tried deleting extension field from core_resource table, and reinstalled once again, however same error persists.
What can I try next?
Can you post the contents of this file? /home/directory/public_html/site/app/code/local/extension/brandsextension/sql/brandsextension_setup/mysql-2-1-1-2?
Also -- it's possible the SQL already ran and it's trying to install it again. You could rename this file to .old and see if it lets you install it then, but I'd actually recommend you go with a different extension. If you are already having issues with this on on install, can't image it's going to be a great addition to your plugin family.