Magento – Module Upgrade Script Not Running

attributescategorysetup-script

I would like to do something as simple as create an upgrade script for an existing module to add custom category attributes. Unfortunately this has been anything but simple as no upgrade script is ever run. I've read about a dozen tutorials and stackoverflow questions to find an answer to no avail.

Below is my config.xml with version 0.2.1 at the top:

   <resources>
        <mymodule_services_setup>
            <setup>
                <module>MyModule_Services</module>
                <class>MyModule_Services_Model_Resource_Eav_Mysql4_Setup</class>
            </setup>
            <connection>
                <use>core_setup</use>
            </connection>
        </mymodule_services_setup>
        <mymodule_services_write>
            <connection>
                <use>core_write</use>
            </connection>
        </mymodule_services_write>
        <mymodule_services_read>
            <connection>
                <use>core_read</use>
            </connection>
        </mymodule_services_read>
    </resources>

The install script at MyModule/Services/sql/mymodule_services_setup/mysql4-upgrade-0.2.1.php:

  $installer = $this;
  //$installer->installEntities();
  Mage::log('running script', null, 'services_upgrade.log');

  $installer->startSetup();

  $installer->addAttribute('catalog_category', 'hide_page_title',  array(
    'type'     => 'int',
    'label'    => 'Hide Page Title',
    'input'    => 'select',
    'source'   => 'eav/entity_attribute_source_boolean',
    'global'   => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
    'required' => false,
    'default'  => 0
  ));

  Mage::log('in the middle', null, 'services_upgrade.log');

  $installer->addAttribute('catalog_category', 'show_percentage_off',  array(
    'type'     => 'int',
    'label'    => 'Show Percentage Off',
    'input'    => 'select',
    'source'   => 'eav/entity_attribute_source_boolean',
    'global'   => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_STORE,
    'required' => false,
    'default'  => 0
  ));

  Mage::log('finished', null, 'services_upgrade.log');
  $installer->endSetup();

The Setup class (MyModule/Services/Model/Resource/Eav/Mysql/Setup.php) specified in the config.xml is there but empty as follows for now:

class MyModule_Services_Model_Resource_Eav_Mysql4_Setup extends Mage_Eav_Model_Entity_Setup
{

}

Resource_core shows the module version being bumped up but the upgrade script is never run.

If anyone can give any help I would be eternally grateful as this simple task is taking hours.

Best Answer

i think you must enter:

MyModule/Services/sql/mymodule_services_setup/mysql4-upgrade-0.2.0-0.2.1.php:

to upgrade from 0.2.0 to 0.2.1 and then type 0.2.1 into config.xml <version> tag.

Related Solutions

Magento – Magento will not run the customer install script

I think you need to add the mysql4-install-0.1.0.php inside a folder called blizzardlabs_customer_setup. Just like the name of your xml tag inside the <resources> tag. So the path should be BlizzardLabs/Customer/sql/blizzardlabs_customer_setup/mysql4-install-0.1.0.php. Before trying it again with the modified path make sure you delete the record from the table core_resource with the code blizzardlabs_customer_setup and clear the cache.
Off topic. If you work with Magento EE 1.12 you can lose the mysql4 in the install script name. You can make it install-0.1.0.php. But it's not that important. It works both ways.

[EDIT]
I've tested tried to run your script. I've created the files as you described. The only thing I added was the module declaration file: app/etc/modules/BlizzardLabs_Customer.xml with this content.

<?xml version="1.0"?>
<config>
    <modules>
        <BlizzardLabs_Customer>
            <active>true</active>
            <codePool>local</codePool>
            <depends>
                <Mage_Customer />
            </depends>
        </BlizzardLabs_Customer>
    </modules>
</config>

And everything worked perfectly. Make sure you cleared the cache. Make sure that the local modules are not disabled (in app/etc/local.xml this tag is set to false <disable_local_modules>false</disable_local_modules>). This is all I can think about.

Magento – Create a sortable and filterable custom attribute to stand-alone entity

When adding the product attribute, set used_in_product_listing, used_for_sort_by and filterable to true.

You can do that with the following update script:

$installer = Mage::getResourceModel('catalog/setup', 'catalog_setup');
$installer->startSetup();
$installer->updateAttribute('catalog_product', 'product_type', 'used_in_product_listing', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'used_for_sort_by', 1);
$installer->updateAttribute('catalog_product', 'product_type', 'is_filterable', 1);
$installer->endSetup();

Thats all, if if you are NOT using the flat catalog.

If you enable the flat catalog product feature, then you need to ensure that your custom source model implements the methods getFlatColums(), getFlatIndexes() and getFlatUpdateSelect().
If they are missing, your attribute won't be included in the generated flat tables, even if used_in_product_listing is enabled.
Have a look at the class Mage_Eav_Model_Entity_Attribute_Source_Boolean for an example. You can probably copy over the methods with minimal adjustments into your custom source model from there. Otherwise, please ask a new question.

Best Answer

Related Solutions

Magento – Magento will not run the customer install script

Magento – Create a sortable and filterable custom attribute to stand-alone entity

Related Topic