title: Magento Install script never runs
body: <p>I am trying to create a custom table using custom module. I have been following <a href="http://alanstorm.com/magento_setup_resources" rel="nofollow">Alan Storm's article</a> to create a custom table</p>
  
  <p>This is my folder structure</p>
  
  <pre><code>CM
   Tablecreation
   etc &gt;&gt; config.xml (has 1.6.0.0 as the version mentioned)
   Helper &gt;&gt; Data.php
   controllers &gt;&gt; IndexController.php
   Model
    Actualtable.php
    Mysql4
     Actualtable.php
    Resource
     Mysql4
       Setup.php
    sql
     tablecreation_setup
       install-1.6.0.0.php
  </code></pre>
  
  <p>This is my config.xml file. </p>
  
  <pre><code>  &lt;?xml version="1.0" encoding="UTF-8"?&gt;
    &lt;config&gt;
    &lt;modules&gt;
      &lt;CM_Tablecreation&gt;
          &lt;version&gt;1.6.0.0&lt;/version&gt;
      &lt;/CM_Tablecreation&gt;
  &lt;/modules&gt;
  &lt;frontend&gt;
      &lt;routers&gt;
          &lt;tablecreation&gt;
              &lt;use&gt;standard&lt;/use&gt;
              &lt;args&gt;
                  &lt;module&gt;CM_Tablecreation&lt;/module&gt;
                  &lt;frontName&gt;tablecreation&lt;/frontName&gt;
              &lt;/args&gt;
          &lt;/tablecreation&gt;
      &lt;/routers&gt;
  &lt;/frontend&gt;    
  &lt;global&gt;
  
      &lt;models&gt;
          &lt;tablecreation&gt;
              &lt;class&gt;CM_Tablecreation_Model&lt;/class&gt;
              &lt;resourceModel&gt;tablecreation_mysql4&lt;/resourceModel&gt;
          &lt;/tablecreation&gt;
          &lt;tablecreation_mysql4&gt;
          &lt;class&gt;CM_Tablecreation_Model_Mysql4&lt;/class&gt;     
          &lt;entities&gt;
              &lt;actualtable&gt;
                  &lt;table&gt;actual_table&lt;/table&gt;
              &lt;/actualtable&gt;
          &lt;/entities&gt;                    
      &lt;/tablecreation_mysql4&gt;
      &lt;/models&gt;
  
      &lt;resources&gt;
      &lt;tablecreation_setup&gt;
      &lt;setup&gt;
          &lt;module&gt;CM_Tablecreation&lt;/module&gt;
          &lt;class&gt;CM_Tablecreation_Model_Resource_Mysql4_Setup&lt;/class&gt;
      &lt;/setup&gt;
      &lt;connection&gt;
          &lt;use&gt;core_setup&lt;/use&gt;
      &lt;/connection&gt;
      &lt;/tablecreation_setup&gt;
      &lt;tablecreation_write&gt;
          &lt;connection&gt;
              &lt;use&gt;core_write&lt;/use&gt;
          &lt;/connection&gt;
      &lt;/tablecreation_write&gt;
      &lt;tablecreation_read&gt;
          &lt;connection&gt;
              &lt;use&gt;core_read&lt;/use&gt;
          &lt;/connection&gt;
      &lt;/tablecreation_read&gt;      
  &lt;/resources&gt;      
  
      &lt;helpers&gt;
              &lt;tablecreation&gt;
                  &lt;class&gt;CM_Tablecreation_Helper&lt;/class&gt;
              &lt;/tablecreation&gt;
      &lt;/helpers&gt;
  &lt;/global&gt;
  &lt;/config&gt;
  </code></pre>
  
  <p>And this is the error I get every time</p>
  
  <pre><code>  a:5:{i:0;s:69:"/home/dev/public_html/app/code///sql/tablecreation_setup not found";i:1;s:818:"#0 /home/dev/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup-&gt;_modifyResourceDb('install', '', '1.6.0.0')
  </code></pre>
  
  <p>I tried debugging by putting try catch with exception messages in app/code/core/Mage/Core/Resource/Setup.php as suggested in some of the previous similar questions on this topic, but to no success</p>
  
  <p>My module isn't even getting listed in core_resource table. And even if some how it does, the table surely never gets created. </p>
  
  <p>I have also had the situation when it did list in core_resource table but If I delete my module's record from the table (to run install script again) and then try to refresh any page of my site I again end up getting error page opening the report of which I find the same error.</p>
  
  <p>Basically any article over the net I follow, I get stuck at this same error. Please help me explain this error and what's causing it. Probably also if some one can suggest what's the solution to sort it. </p>
  
  <p>Many thanks in advance.</p>