Magento Module DB Setup Script not running

Question

Running Magento 1.9.0.2, I'm trying to add 2 new checkbox fields into the Address form via Module.

Problem: The database script is NOT executed (note the die() function on the first line)

Symptoms:

My module does not exist in core_resources table
database does not get updated
module is listed & enabled in System > Configuration > Advanced
log enabled, folder {base_dir}/var/log/ is 777, no log produced
I'm installing the module; is uploading the files to the folder & refresh the cache & frontend once triggers the install?

Question: What did I miss?

Here is the {base_dir}/app/code/local/Tdg/Check/etc/config.xml:

<?xml version="1.0" encoding="UTF-8"?>
<config>
    <modules>
        <Tdg_Check>
            <version>1.0.1</version>
        </Tdg_Check>
    </modules>
    <admin>
        <fieldsets>
            <customer_dataflow>
                <chk_commercial><billing>1</billing><shipping>1</shipping></chk_commercial>
                <chk_residential><billing>1</billing><shipping>1</shipping></chk_residential>
            </customer_dataflow>
        </fieldsets>
    </admin>
    <global>
        <models>
            <check>
                <class>Tdg_Check_Model</class>
            </check>
        </models>
        <resources>
            <check_setup>
                <setup>
                    <module>Tdg_Check</module>
                </setup>
                <connection>
                    <use>core_setup</use>
                </connection>
            </check_setup>
            <check_write>
                <connection>
                    <use>core_write</use>
                </connection>
            </check_write>
            <check_read>
                <connection>
                    <use>core_read</use>
                </connection>
            </check_read>
        </resources>
        <fieldsets>
            <sales_copy_order_billing_address>
                <chk_commercial><to_order>*</to_order></chk_commercial>
                <chk_residential><to_order>*</to_order></chk_residential>
            </sales_copy_order_billing_address>
            <sales_copy_order_shipping_address>
                <chk_commercial><to_order>*</to_order></chk_commercial>
                <chk_residential><to_order>*</to_order></chk_residential>
            </sales_copy_order_shipping_address>
            <sales_convert_quote_address>
                <chk_commercial><to_order_address>*</to_order_address><to_customer_address>*</to_customer_address></chk_commercial>
                <chk_residential><to_order_address>*</to_order_address><to_customer_address>*</to_customer_address></chk_residential>
            </sales_convert_quote_address>
            <sales_convert_order_address>
                <chk_commercial><to_quote_address>*</to_quote_address></chk_commercial>
                <chk_residential><to_quote_address>*</to_quote_address></chk_residential>
            </sales_convert_order_address>
            <customer_address>
                 <chk_commercial><to_quote_address>*</to_quote_address></chk_commercial>
                 <chk_residential><to_quote_address>*</to_quote_address></chk_residential>
            </customer_address>
            <checkout_onepage_billing>
                <chk_commercial><to_customer>*</to_customer></chk_commercial>
                <chk_residential><to_customer>*</to_customer></chk_residential>
            </checkout_onepage_billing>
        </fieldsets>
    </global>
</config>

And the SQL Update file {base_dir}/app/code/Tdg/Check/sql/check_setup/mysql4-install-1.0.1.php:

<?php
die('Installing Module');
/* @var $installer Mage_Customer_Model_Entity_Setup */
$installer = $this;
$installer->startSetup();
/* @var $addressHelper Mage_Customer_Helper_Address */
$addressHelper = Mage::helper('customer/address');
$store         = Mage::app()->getStore(Mage_Core_Model_App::ADMIN_STORE_ID);

/* @var $eavConfig Mage_Eav_Model_Config */
$eavConfig = Mage::getSingleton('eav/config');

// update customer address user defined attributes data
$attributes = array(
    'chk_commercial'           => array(   
        'label'             => 'Chk Commercial',
        'type'              => 'int',
        'input'             => 'checkbox',
        'default'           => 0,
        'is_user_defined'   => 1,
        'is_system'         => 0,
        'is_visible'        => 1,
        'sort_order'        => 140,
        'is_required'       => 1,
        'multiline_count'   => 0,
        'validate_rules'    => array(
            'max_text_length'   => 1,
            'min_text_length'   => 1
        ),
    ),
    'chk_residential'           => array(   
        'label'             => 'Chk Residential',
        'type'              => 'int',
        'input'             => 'checkbox',
        'default'           => 0,
        'is_user_defined'   => 1,
        'is_system'         => 0,
        'is_visible'        => 1,
        'sort_order'        => 141,
        'is_required'       => 1,
        'multiline_count'   => 0,
        'validate_rules'    => array(
            'max_text_length'   => 1,
            'min_text_length'   => 1
        ),
    ),
);

foreach ($attributes as $attributeCode => $data) {
    $attribute = $eavConfig->getAttribute('customer_address', $attributeCode);
    $attribute->setWebsite($store->getWebsite());
    $attribute->addData($data);
        $usedInForms = array(
            'adminhtml_customer_address',
            'customer_address_edit',
            'customer_register_address'
        );
        $attribute->setData('used_in_forms', $usedInForms);
    $attribute->save();
}

$installer->run("
    ALTER TABLE {$this->getTable('sales_flat_quote_address')} ADD COLUMN `chk_commercial` VARCHAR(1) CHARACTER SET utf8 DEFAULT NULL AFTER `fax`;
    ALTER TABLE {$this->getTable('sales_flat_order_address')} ADD COLUMN `chk_commercial` VARCHAR(1) CHARACTER SET utf8 DEFAULT NULL AFTER `fax`;
    ALTER TABLE {$this->getTable('sales_flat_quote_address')} ADD COLUMN `chk_residential` VARCHAR(1) CHARACTER SET utf8 DEFAULT NULL AFTER `fax`;
    ALTER TABLE {$this->getTable('sales_flat_order_address')} ADD COLUMN `chk_residential` VARCHAR(1) CHARACTER SET utf8 DEFAULT NULL AFTER `fax`;
");
$installer->endSetup();
?>

Last, it's the Module definition file Tdg_Check.xml:

<?xml version="1.0" encoding="UTF-8"?>
<config>
    <modules>
        <Tdg_Check>
            <active>true</active>
            <codePool>local</codePool>
        </Tdg_Check>
    </modules>
</config>

If you have are upgrading module then you have to change module version and create upgrade file instead of install file mysql4-upgrade-"OLDER_VERSION"-"NEW_VERSION". — Hardik Shah
– Hardik Shah, Commented Mar 16, 2015 at 10:09
Sorry I'm not clear enough, I try to install the module. How do I force install when core_resources does not have my module name on it ? (p.s. actually which value will appear in core_resources table? Is it Tdg_Check?) — Raptor
– Raptor, Commented Mar 16, 2015 at 10:26
Its shows like check_setup in code field of core_resource table. — Hardik Shah
– Hardik Shah, Commented Mar 16, 2015 at 10:45
Omg! I never thought it's check_setup ! I removed it from the core_resources table and the install script runs ! Thanks ! Please put it as answer ! — Raptor
– Raptor, Commented Mar 16, 2015 at 11:02

Hardik Shah · Accepted Answer · 2015-03-16 11:10:56Z

1

In Magento module entry stored in code field like below: yourmodulename_setup

Check for record like check_setup in code field of core_resource table.

So for run install script again you have to find module record in module and remove that record. It will automatically run the script again.

answered Mar 16, 2015 at 11:10

Hardik Shah

2861 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Magento Module DB Setup Script not running

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related