Magento module not calling install script, to create attribute for category

Question

I am creating module in magento 1.9.1, to create a attribute for categories. I have created files as follows:

app\etc\modules\Ddevs_Ebayaff.xml

<?xml version="1.0"?>
<config>
     <modules>
        <Ddevs_Ebayaff>
            <active>true</active>
            <codePool>local</codePool>
        </Ddevs_Ebayaff>
     </modules>
</config>

I am trying to call controller and mysql install script in one config file as follows

app\code\local\Ddevs\Ebayaff\etc\config.xml

 <?xml version="1.0"?> <config>
        <modules>
            <ddevs_ebayaff>
                <version>
                    0.1.0
                </version>
            </ddevs_ebayaff>
        </modules>   
          <frontend>
            <routers>
                <helloworld>
                    <use>standard</use>
                    <args>
                        <module>Ddevs_Ebayaff</module>
                        <frontName>ebayaffload</frontName>
                    </args>
                </helloworld>
            </routers>
        </frontend>     
     <global>
     <resources>
        <add_category_attribute>
            <setup>
                <module>Ddevs_Ebayaff</module>
                <class>Mage_Catalog_Model_Resource_Setup</class>
            </setup>
        </add_category_attribute>
    </resources>

</global>
     </config>

In IndexController, i have the following content

app\code\local\Ddevs\Ebayaff\controllers\IndexController.php

<?php
class Ddevs_Ebayaff_IndexController extends Mage_Core_Controller_Front_Action{
    public function indexAction(){
           $this->loadLayout();
            $this->renderLayout();
}
}

And my install script as follows:

app\code\local\Ddevs\Ebayaff\sql\add_category_attribute\mysql4-install-0.1.0.php

<?php
$this->startSetup();
$this->addAttribute(Mage_Catalog_Model_Category::ENTITY, 'ddev_ebayaff_cat', array(
    'group'         => 'General Information',
    'input'         => 'text',
    'type'          => 'text',
    'label'         => 'Category ID',
    'backend'       => '',
    'visible'       => true,
    'required'      => false,
    'visible_on_front' => true,
    'global'        => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
));

$this->endSetup();

Answer 1

You are missing this in the config.xml inside the <global> tag

    <resources>
        <add_category_attribute>
            <setup>
                <module>Ddevs_Ebayaff</module>
                <class>Mage_Catalog_Model_Resource_Setup</class>
            </setup>
        </add_category_attribute>
    </resources>

also change this section from the same config file

<ddevs_ebayaff>
    <version>
        0.1.0
    </version>
</ddevs_ebayaff>

to

<Ddevs_Ebayaff>
    <version>0.1.0</version>
</Ddevs_Ebayaff>

Answer 2

For your specific problem, you are missing the <resources> configuration in your module config. You need to add it directly under the <global> tag

<resources>
    <add_category_attribute>
        <setup>
            <module>Ddevs_Ebayaff</module>
            <class>Mage_Eav_Model_Entity_Setup</class>
        </setup>
    </add_category_attribute>
</resources>

^{The <add_category_attribute> tag should be the same as the directory name which contains your install scripts.}

Other than that, you have different issues in your config.xml.

You cannot put a <frontend> tag inside <global>. The thing is, most of your module configuration fall under ONE of three tags.

• <frontend>
  Configuration under this tag, applies only to the frontend of Magento.
  These can be for example new routes just for the frontend.
• <admin>
  Configuration under this tag, applies only to the backend of Magento.
  These can be for example new routes just for the backend
• <global>
  Configuration under this tag, applies everywhere in Magento.
  These can be for example configuration for models, block, helpers.

This is how your config.xml should be:

<?xml version="1.0"?>
<config>
    <modules>
        <Ddevs_Ebayaff>
            <version>0.1.0</version>
        </Ddevs_Ebayaff>
    </modules>
    <global>
        <resources>
            <add_category_attribute>
                <setup>
                    <module>Ddevs_Ebayaff</module>
                    <class>Mage_Eav_Model_Entity_Setup</class>
                </setup>
            </add_category_attribute>
        </resources>
    </global>
    <frontend>
        <routers>
            <helloworld>
                <use>standard</use>
                <args>
                    <module>Ddevs_Ebayaff</module>
                    <frontName>ebayaffload</frontName>
                </args>
            </helloworld>
        </routers>
    </frontend>
</config>