Databases
StackOverflow2013
Postsdbo
POMagento 1.4.0.1 -> 1.7 MySQL Error 150
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMagento 1.4.0.1 -> 1.7 MySQL Error 150
    primarykey
    data
    text
    <p>Did all as the instruction says: <a href="http://turnkeye.com/blog/magento-upgrade-guide/" rel="nofollow">http://turnkeye.com/blog/magento-upgrade-guide/</a> (It's not official Magento site, but it refers to this).</p> <p>I've got myself to </p> <blockquote> <p>Now the upgrade is complete and you can execute database upgrade visiting your Magento store in your browser, this process will take several minutes, so be patient.</p> </blockquote> <p>And then got the mysql error. Google doesn't know something about EXACTLY this problem. Please help if you know something.</p> <p>My error log:</p> <pre><code>a:5:{i:0;s:245:"Error in file: "/home/mysite/public_html/app/code/core/Mage/Customer/sql/customer_setup/mysql4-upgrade-1.4.0.0.7-1.4.0.0.8.php" - SQLSTATE[HY000]: General error: 1005 Can't create table './mysite_magento/customer_form_attribute.frm' (errno: 150)";i:1;s:978:"#0 /home/mysite/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...') #1 /home/mysite/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup-&gt;_modifyResourceDb('upgrade', '1.4.0.0.6', '1.6.2.0.1') #2 /home/mysite/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup-&gt;_upgradeResourceDb('1.4.0.0.6', '1.6.2.0.1') #3 /home/mysite/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup-&gt;applyUpdates() #4 /home/mysite/public_html/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates() #5 /home/mysite/public_html/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App-&gt;_initModules() #6 /home/mysite/public_html/app/Mage.php(683): Mage_Core_Model_App-&gt;run(Array) #7 /home/mysite/public_html/index.php(87): Mage::run('', 'store') #8 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";} </code></pre> <p>I found the exact code that should make table <strong>customer_form_attribute</strong> and tried to exewcute it, but got the same error without any additional information about it's reason. Here it is:</p> <pre><code>[SQL] CREATE TABLE `customer_form_attribute` ( `form_code` char(32) NOT NULL, `attribute_id` smallint UNSIGNED NOT NULL, PRIMARY KEY(`form_code`, `attribute_id`), KEY `IDX_CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE` (`attribute_id`), CONSTRAINT `FK_CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `{$installer-&gt;getTable('eav_attribute')}` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer attributes/forms relations'; [Err] 1005 - Can't create table './mysite_magento/customer_form_attribute.frm' (errno: 150) </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USABTOMAT
    1. USABTOMAT
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMagento 1.4.0.1 -> 1.7 MySQL Error 150
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMagento 1.4.0.1 -> 1.7 MySQL Error 150
      1. USZak
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload