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

Sample Data 1.0.19870 installation error - Please help
 
angelleye
Member
 
Avatar
Total Posts:  45
Joined:  2009-02-09
Kansas City, MO
 

Anybody in this thread working on a dedicated host or are we all on shared hosts?  I’m curious because I’ve noticed better performance on different hosts, but all I’ve ever worked on are shared hosts.  I’m wondering if Magento would run a lot better on its own server..??

 
Magento Community Magento Community
Magento Community
Magento Community
 
CCondra
Magento Team
 
Avatar
Total Posts:  45
Joined:  2009-04-15
Lemon Grove, California (San Diego County)
 

Re: SOLUTION for error #1005 on importing magento_sample_data_for_1.1.2.sql

I would like to thank you, Nijhof Internet Media, for posting a solution to this sample data installation script problem.  I replaced the line in the script and it worked perfectly. Thank you *so* much for sharing this solution.  :o) :o) :o)

Claire

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 
angelleye - 11 April 2009 09:40 AM

Anybody in this thread working on a dedicated host or are we all on shared hosts?  I’m curious because I’ve noticed better performance on different hosts, but all I’ve ever worked on are shared hosts.  I’m wondering if Magento would run a lot better on its own server..??

Usually, with a dedicated server you will have more resources like CPU and memory which should give better performance. However, unless the server is properly optimized you might not get as good results as you would expect. It is important to tune the MySQL server, PHP processing can be improved with an op-code cache, etc.

A shared hosting package specifically optimized for Magento might be a good option if you don’t have a very large site with lots of traffic.

 
Magento Community Magento Community
Magento Community
Magento Community
 
angelleye
Member
 
Avatar
Total Posts:  45
Joined:  2009-02-09
Kansas City, MO
 

My host recently added the ability to install and upgrade Magento using a tool within the cPanel they provide.  This way, even though I’m on a shared host, the installation gets done using SSH and does not have any timeout issues.  I haven’t had a single issue installing or upgrading Magento since I started using the cPanel installer that they provide.

 
Magento Community Magento Community
Magento Community
Magento Community
 
brunoserin
Jr. Member
 
Total Posts:  1
Joined:  2009-04-19
 

erno: 150

CREATE TABLE `catalog_category_entity_datetime` (

`value_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`entity_type_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`attribute_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`store_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`entity_id` int( 10 ) unsigned NOT NULL default ‘0’,
`value` datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY ( `value_id` ) ,
UNIQUE KEY `IDX_BASE` ( `entity_type_id` , `entity_id` , `attribute_id` , `store_id` ) ,
KEY `FK_ATTRIBUTE_DATETIME_ENTITY` ( `entity_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE` ( `attribute_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE` ( `store_id` ) ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY ( `attribute_id` ) REFERENCES `eav_attribute` ( `attribute_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY` FOREIGN KEY ( `entity_id` ) REFERENCES `catalog_category_entity` ( `entity_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE` FOREIGN KEY ( `store_id` ) REFERENCES `core_store` ( `store_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

MySQL a répondu:

#1005 - Can’t create table ‘./admin_magentobidon/catalog_category_entity_datetime.frm’ (errno: 150)

 
Magento Community Magento Community
Magento Community
Magento Community
 
lowkey704
Member
 
Avatar
Total Posts:  41
Joined:  2009-05-18
 

Hmmmm guess I goofed up… I installed Magento first… then i wanted to load the sample data so I can get a feel for this software… but I am learning that I need to install on a Clean DB..... maybe I can export my DB… install the sample data DB and then import the Magento DB ? Sounds a little backwards but maybe it will work.

Has anyone else been through this one. I am Very New like… all the way Green with Magento… I have a couple of Oscommerce Stores but this is a new learning experience for me.

Thanks

Lonny M.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

You will need to first import the sample data (on a clean DB), then install Magento.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lowkey704
Member
 
Avatar
Total Posts:  41
Joined:  2009-05-18
 

Error

SQL query:

CREATE TABLE `catalog_category_entity_datetime` (
`value_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`entity_type_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`attribute_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`store_id` smallint( 5 ) unsigned NOT NULL default ‘0’,
`entity_id` int( 10 ) unsigned NOT NULL default ‘0’,
`value` datetime NOT NULL default ‘0000-00-00 00:00:00’,
PRIMARY KEY ( `value_id` ) ,
UNIQUE KEY `IDX_BASE` ( `entity_type_id` , `entity_id` , `attribute_id` , `store_id` ) ,
KEY `FK_ATTRIBUTE_DATETIME_ENTITY` ( `entity_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE` ( `attribute_id` ) ,
KEY `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE` ( `store_id` ) ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE` FOREIGN KEY ( `attribute_id` ) REFERENCES `eav_attribute` ( `attribute_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY` FOREIGN KEY ( `entity_id` ) REFERENCES `catalog_category_entity` ( `entity_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE` FOREIGN KEY ( `store_id` ) REFERENCES `core_store` ( `store_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

MySQL said: Documentation
#1005 - Can’t create table ‘./*****/catalog_category_entity_datetime.frm’ (errno: 150)

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

Is this an installation on an empty database? Do your server support all the system requirements, including the InnoDB storage engine?

 
Magento Community Magento Community
Magento Community
Magento Community
 
lowkey704
Member
 
Avatar
Total Posts:  41
Joined:  2009-05-18
 

Yes PHP was updated… I had Magento on the server… but then I decided I wanted the sample data so I can get a feel for the back end being that I am a green pea. This is way different than Oscommerce which is what I am used too… but with all the hype I am hearing about Magento I wanted to give it a spin.

Yes - empty DB (which I now see several people are having the same issue…
I deleted Magento and now I am uploading it (FTP) to the server to install again.

I have to say that Magento looks scary to a newbie lol

I will work it out… I always do… I am not a programmer - I am not a web design guru… but I do ok… my oscommerce site has loads of features. http://www.themancaveoutletstore.com --- but I like learning new things… so I want to feel the power of Magento.

Lonny M.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lowkey704
Member
 
Avatar
Total Posts:  41
Joined:  2009-05-18
 

Got it working now… thanks to one of the attachments I downloaded from this thread… now the fun begins… trying to learn something totally new…

 
Magento Community Magento Community
Magento Community
Magento Community
 
lowkey704
Member
 
Avatar
Total Posts:  41
Joined:  2009-05-18
 

Well I thought I had it… now I am getting 404 errors. http://www.valuecityusa.com/sony-vaio-vgn-txn27n-b-11-1-notebook-pc.html I know that the product page exists because I see it in the admin area… but it won’t show…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

Try this: go to System -> Cache Management and click Refresh Catalog Rewrites. It should solve it.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Ace_ov_Spade
Jr. Member
 
Total Posts:  2
Joined:  2009-06-14
 

I’ve just installed Magento Full Release [ver 1.3.2.1] and after that installed sample data [ver 1.2.0]. I have downloaded these files from magento website.

Magento installation was fine. but when I imported the sample data sql [via PHPMyAdmin] I got a long list of errors.

can anyone guide me how to solve this problem ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Sindre|ProperHost
Mentor
 
Avatar
Total Posts:  1158
Joined:  2008-04-24
 

You must import the sample data before you install Magento. I advise you to start over with an empty database.

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