Magento Module SQL does not run

Question

My module will setup correctly and all the relavant files are installed correctly. But the database tables are not being created.

I have followed this tutorial.

My config xml is as below.

<?xml version="1.0"?>
<config>
  <modules>
    <Myname_Mygateway>
      <version>1.0.0</version>
    </Myname_Mygateway>
  </modules>
  <global>
    <resources>

      <Mygateway_setup>
        <setup>
          <module>Myname_Mygateway</module>
        </setup>
        <connection>
          <use>core_setup</use>
        </connection>
      </Mygateway_setup>


      <Mygateway_write>
        <connection>
          <use>core_write</use>
        </connection>
      </Mygateway_write>

      <Mygateway_read>
        <connection>
          <use>core_read</use>
        </connection>
      </Mygateway_read>

    </resources>
    <models>
      <mygateway>
        <class>Myname_Mygateway_Model</class>
      </mygateway>
    </models>
    <helpers>
      <mygateway>
        <class>Myname_Mygateway_Helper</class>
      </mygateway>
    </helpers>
    <blocks>
      <mygateway>
        <class>Myname_Mygateway_Block</class>
      </mygateway>
    </blocks>
  </global>
  <default>
    <payment>
      <mygateway>
        <model>mygateway/standard</model>
        <active>1</active>
        <order_status>pending</order_status>
        <title>My Gateway</title>
        <payment_action>sale</payment_action>
        <allowspecific>0</allowspecific>
        <sort_order>1</sort_order>
      </mygateway>
    </payment>
  </default>
  <frontend>
    <routers>
      <mygateway>
        <use>standard</use>
        <args>
          <module>Myname_Mygateway</module>
          <frontName>mygateway</frontName>
        </args>
      </mygateway>
    </routers>
  </frontend>
</config>

I have a .php file named /sql/mygateway_setup/mysql4-install-1.0.0.php but it does not run.

What have I tried

Tried removing any entries from core_resource related to my module
Changing version numbers
Matchin version numbers

How can I fix this issue?

Maniprakash Chinnasamy · Accepted Answer · 2013-02-14 06:09:53Z

1

Follow the below steps to in admin panel.

Run The Compiler :

Admin => System => Tools => Compilation > Enable => Run Compilation Process.

Re index the Data :

Admin => System => Index Management =>

Check all the check box and click "Re Index Data" in drop-down in top right to submit.

answered Feb 14, 2013 at 6:09

Maniprakash Chinnasamy

2,77632 silver badges56 bronze badges

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

2 Comments

Techie Over a year ago

What's the purpose of doing this process? Please explain if you can

Maniprakash Chinnasamy Over a year ago

Me to meet this kind of issues while customizing module with database tables.so that i have re index the datas in admin panel. after the data reindex the table is created .. you try this.

VijayS91 · Accepted Answer · 2014-09-10 13:24:47Z

0

First of all change every word to lower case in your xml like ( to .second thing is to create models in your xml like

           <mygateway_mysql4>
                <class>Mygateway_Model_Mysql4</class>
                <entities>
                    <mygateway>
                        <table>mygateway</table>
                    </mygateway>

                </entities>
            </mygateway_mysql4>

for details and step by step process you can study these articles Link1, Link2.

Hope it solve your problem

edited Sep 10, 2014 at 13:24

VijayS91

1,53123 silver badges40 bronze badges

answered Feb 14, 2013 at 5:47

Mahmood Rehman

4,3377 gold badges43 silver badges76 bronze badges

Collectives™ on Stack Overflow

Magento Module SQL does not run

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related