Magento Module SQL无法运行 [英] Magento Module SQL does not run

问题描述

我的模块将正确安装，并且所有相关文件都已正确安装.但是没有创建数据库表.

我已遵循此教程.

我的配置xml如下.

<?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>

我有一个名为/sql/mygateway_setup/mysql4-install-1.0.0.php的.php文件，但它没有运行.

我尝试了什么

• 试图从core_resource中删除与我的模块相关的所有条目
• 更改版本号
• 比赛版本号

如何解决此问题?

解决方案

首先将xml中的每个单词更改为小写，例如(更改为.second就是在xml中创建模型，例如

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

                </entities>
            </mygateway_mysql4>

有关详细信息和逐步过程，您可以研究以下文章链接1 ， Link2 .. >

希望它可以解决您的问题

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?

解决方案

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

这篇关于Magento Module SQL无法运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！