Magento

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..??

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

angelleye - 11 April 2009 10: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.

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.

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)

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.

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

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)

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

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.

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…

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…

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

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 ?

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