Upgrade script not working

Question

I've added two category attributes successfully to magento admin. However when I run an upgrade script to add another, "core_resource" takes note of my module update but doesn't install the new attribute.

Here is my upgrade-1.0.1-1.0.2.php

<?php
$this->startSetup();

$this->addAttribute('catalog_category', 'is_brand', array(
    'group'                     => 'Display Settings',
    'type'                      => 'int',
    'input'                     => 'select',
    'source'                    => '',
    'label'                     => 'Is a brand?',
    'backend'                   => '',
    'visible'                   => 1,
    'required'                  => 0,
    'user_defined'              => 999,
    'default'                   => 0,
    'global'                    => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
));

$this->endSetup();

and as mentioned I updated config.xml to <version>1.0.2</version>

Nothing is added to the admin panel, no errors, no log errors.

Any ideas?

Answer 1

From comment your file name should be

The second script name was not correct

upgrade-1.0.1.php
    upgrade-1.0.1-1.0.2 

Answer 2

i've sorted this.

Problem was I had:

install-1.0.0.php
upgrade-1.0.1.php
upgrade-1.0.1-1.0.2.php

The second script name was not correct and was breaking the chain of running scripts.

Thanks to Keyur Shah his help led me to solving the problem.

Answer 3

For me, the reason why it was not triggered is that I had different version in the table core_resource from the xml version from config.xml.

In my case, the xml version was 1.4.0 and in the databse I had 1.4.2

I posted this, so it might help others facing this issue. Thank you