Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Error 1005 while importing sample-data-1.2.0
 
Bob S
Jr. Member
 
Total Posts:  25
Joined:  2007-11-11
 

I received the following error while trying to import the sample data:
ERROR 1005 (HY000) at line 1185: Can’t create table ‘xxxxxxxx_importdb.catalog_product_website’ (errno: 1478)

The system admin informed me that the problem was actually at line 1192:
) ENGINE=InnoDB AUTO_INCREMENT=167 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;

He said that InnoDB tables cannot use ROW_FORMAT=FIXED. I removed that option and the sample data did import. Can anyone confirm that removing this option will not create problems in the future?

MySQL 5.1.30

Thanks for any help.

Bob

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