Magento Forum

   
can’t create table catalog_category_entity_datetime.frm
 
Carolus
Jr. Member
 
Total Posts:  28
Joined:  2008-07-17
 

Hi,
Importing the sample data sql script I got the error message: “#1005 - Can’t create table ‘./db_mag/catalog_category_entity_datetime.frm’ (errno: 150) “. In this forum I read the solution should be
1) remove “SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
2) change everything to InnoDB
3) remove all inline comments, preserve the code within the comments

Because of lack of experience with MySQL I do not understand what and exactly how I have to do that.
carolus

 
Magento Community Magento Community
Magento Community
Magento Community
 
xitch
Member
 
Total Posts:  54
Joined:  2008-10-21
 

Visit the following.  It’s in the dutch boards, but the answer is in english.  Scroll to the bottom and you’ll find a corrected file.  It works.  I had the same problem as you did and this fixed it no problems.

http://www.magentocommerce.com/boards/viewthread/15520/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top