创建magento安装脚本时未找到基表或视图

Question

以下是我的所有文件。

应用程序/代码/本地/ Vlabs/Productquery/SQL/productquery_setup /资源安装-0.1.0.php

<?php 
    $installer = $this; 
    $installer->startSetup(); 

$installer->run(" 
    -- DROP TABLE IF EXISTS {$this->getTable('Vlabs_queryBox')}; 
    CREATE TABLE {$this->getTable('Vlabs_queryBox')} (
     `id` int(11) unsigned NOT NULL auto_increment, 
     `name` varchar(255) NOT NULL default, 
     `email` varchar(255), 
     `query` varchar(255), 
     `product_name` varchar(255), 
     `sku` varchar(255), 
     `answer` varchar(255), 
     `status` varchar(255), 
     `date` date NULL, 
     PRIMARY KEY (`id`) 
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
    "); 

    $installer->endSetup(); 

应用程序/代码/本地/ Vlabs/Productquery的/ etc/config.xml中

<?xml version="1.0"?> 
<config> 
    <modules> 
     <Vlabs_Productquery> 
      <version>0.1.0</version> 
     </Vlabs_Productquery> 
    </modules> 

    <frontend> 
     <routers> 
      <productquery> 
       <use>standard</use> 
       <args> 
        <module>Vlabs_Productquery</module> 
        <frontName>productquery</frontName> 
       </args> 
      </productquery> 
     </routers> 
     <layout> 
      <updates> 
       <productquery module="Vlabs_Productquery"> 
        <file>productquery.xml</file> 
       </productquery> 
      </updates> 
     </layout> 
    </frontend> 

    <global> 
     <blocks> 
      <productquery> 
       <class>Vlabs_Productquery_Block</class> 
      </productquery> 
     </blocks> 

     <models> 
      <productquery> 
       <class>Vlabs_Productquery_Model</class> 
       <resourceModel>productquery_Resource</resourceModel> 
      </productquery> 
      <productquery_Resource> 
       <class>Vlabs_Productquery_Model_Resource</class> 
       <entities> 
        <querybox> 
         <table>Vlabs_queryBox</table> 
        </querybox> 
       </entities> 
      </productquery_Resource> 
     </models> 
     <helpers> 
      <productquery> 
      <class>Vlabs_Productquery_Helper</class> 
      </productquery> 
     </helpers> 
     <resources> 
      <form_setup> 
       <setup> 
        <module>Vlabs_Productquery</module> 
       </setup> 
       <connection> 
        <use>core_setup</use> 
       </connection> 
      </form_setup> 
      <form_write> 
       <connection> 
        <use>core_write</use> 
       </connection> 
      </form_write> 
      <form_read> 
       <connection> 
        <use>core_read</use> 
       </connection> 
      </form_read> 
     </resources> 
     <template> 
     <email> 
      <vlabs_query_email_template translate="label"> 
       <label>Recurring order email</label> 
       <file>vlabs_querybox_email.html</file> 
       <type>html</type> 
      </vlabs_query_email_template> 
     </email> 
    </template> 
    </global> 

    <!-- <default> 
     <productquery> 
      <settings> 
       <enable>1</enable>    
      </settings> 
     </productquery> 
    </default> --> 

    <admin> 
     <routers> 
      <adminhtml> 
       <use>admin</use> 
       <args> 
        <modules> 
         <Vlabs_Productquery before="Mage_Adminhtml">Vlabs_Productquery_Adminhtml</Vlabs_Productquery> 
        </modules> 
        <frontname>productquery</frontname> 
       </args> 
      </adminhtml> 
     </routers> 
    </admin> 
    <adminhtml> 
     <layout> 
      <updates> 
       <productquery> 
        <file>productquery.xml</file> 
       </productquery> 
      </updates> 
     </layout> 
    </adminhtml> 
</config> 

应用程序/代码/本地/ Vlabs/Productquery /型号/资源/ Querybox/Setup.php

<?php 
class Vlabs_Productquery_Model_Resource_Querybox_Setup extends Mage_Core_Model_Resource_Setup { 
} 

错误

a:5:{i:0;s:179:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento_mirror_new.Vlabs_queryBox' doesn't exist, query was: SELECT `main_table`.* FROM `Vlabs_queryBox` AS `main_table`";i:1;s:5763:"#0 /var/www/html/magento-mirror-new/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) 

我正在做的扩展。但没有在数据库中创建表。但是在mysql中直接运行这个查询时，查询是可行的。我该如何解决这个问题？

Answer 1

看起来你已经安装了你的模块，后来你改变了数据库名称。

转到core_resource表并尝试删除此条目“form_setup”。然后清除缓存并重试。我希望这会起作用。