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
 
GCRepairs
Jr. Member
 
Total Posts:  1
Joined:  2010-07-26
 

Hello

I installed Magento 1.4.1.0 & then installed sample data 1.2.0. I can see the FRONTEND fine however I am unable to login to the Admin Panel.

I came across the following link but it says the INFO is outdated
http://www.magentocommerce.com/wiki/groups/227/how_to_reset_your_password

Could anybody please shed some light.

Thank you

 
Magento Community Magento Community
Magento Community
Magento Community
 
Chester71
Jr. Member
 
Total Posts:  18
Joined:  2011-01-08
 

I was so happy to find this thread and to be honest a bit disappointed with Magento to be so complicated fro newbies. However, I don;t easily give up.
This sample products seemed the solution and I tried all three files available, all with errors.

I just did a clean fresh install through Cpanel (Softaculous) to be sure, same error appears.

This is the error for magento_sample_data_for_1.2.0.sql:

SQL-query:

CREATE TABLE `admin_rule` (
`rule_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`role_id` int( 10 ) unsigned NOT NULL default ‘0’,
`resource_id` varchar( 255 ) NOT NULL default ‘’,
`privileges` varchar( 20 ) NOT NULL default ‘’,
`assert_id` int( 10 ) unsigned NOT NULL default ‘0’,
`role_type` char( 1 ) default NULL ,
`permission` varchar( 10 ) default NULL ,
PRIMARY KEY ( `rule_id` ) ,
KEY `resource` ( `resource_id` , `role_id` ) ,
KEY `role_id` ( `role_id` , `resource_id` ) ,
CONSTRAINT `FK_admin_rule` FOREIGN KEY ( `role_id` ) REFERENCES `admin_role` ( `role_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =2 DEFAULT CHARSET = utf8 COMMENT = ‘ACL Rules’;

MySQL retourneerde: Documentatie
#1005 - Can’t create table ‘./kadoidee_mage877/admin_rule.frm’ (errno: 121) (<a href="server_engines.php?engine=InnoDB&page=Status&token=1a027cfdaa613f66ead8d9778fc04289">Details...</a>)

and to me it seems the same error for : magento_sample_data_for_1.2.0_revised.sql

SQL-query:

CREATE TABLE `admin_rule` (
`rule_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`role_id` int( 10 ) unsigned NOT NULL default ‘0’,
`resource_id` varchar( 255 ) NOT NULL default ‘’,
`privileges` varchar( 20 ) NOT NULL default ‘’,
`assert_id` int( 10 ) unsigned NOT NULL default ‘0’,
`role_type` char( 1 ) default NULL ,
`permission` varchar( 10 ) default NULL ,
PRIMARY KEY ( `rule_id` ) ,
KEY `resource` ( `resource_id` , `role_id` ) ,
KEY `role_id` ( `role_id` , `resource_id` ) ,
CONSTRAINT `FK_admin_rule` FOREIGN KEY ( `role_id` ) REFERENCES `admin_role` ( `role_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT =2 DEFAULT CHARSET = utf8 COMMENT = ‘ACL Rules’;

MySQL retourneerde: Documentatie
#1005 - Can’t create table ‘./kadoidee_mage877/admin_rule.frm’ (errno: 121) (<a href="server_engines.php?engine=InnoDB&page=Status&token=1a027cfdaa613f66ead8d9778fc04289">Details...</a>)

As the last one (assuming I only need to drop admin_assert and admin_role before reattempting) I tried this file: magento_sample_data_for_1.0.19870.sql
At least this last one, although older, seems to get further, since it creates 2 more tables before it halts: admin_rule and admin_user.

This is the error:

SQL-query:

-- -------------------
-- Foreign keys
-- -------------------
ALTER TABLE `admin_rule` ADD CONSTRAINT `FK_admin_rule` FOREIGN KEY ( `role_id` ) REFERENCES `admin_role` ( `role_id` ) ON DELETE CASCADE ON UPDATE CASCADE ;

MySQL retourneerde: Documentatie
#1005 - Can’t create table ‘./kadoidee_mage877/#sql-449_d3d60.frm’ (errno: 121) (<a href="server_engines.php?engine=InnoDB&page=Status&token=1a027cfdaa613f66ead8d9778fc04289">Details...</a>)

Well, now that I read back, it seems the all give the same error at the bottom.

Any solution for this?

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Chester71
Jr. Member
 
Total Posts:  18
Joined:  2011-01-08
 

A, i not being nice enough? I’ve posted three questions on this board and none of them have been responded to. Are my questions too hard , am I not being nice enough or just not lucky smile ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Aljoshammm
Jr. Member
 
Total Posts:  8
Joined:  2011-03-28
 

I did installing and after this he wrote this - http://www.infantexpress.ee (not advertisment)
What must i do ?
Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
unknownmx
Jr. Member
 
Total Posts:  3
Joined:  2011-04-22
 
andersbirkenstam - 14 November 2008 01:29 PM

i am reading in the forum of all the problems and i am going back to virtuemart. why does not the team answer ????????????????????????????????????????????????????????????

sorry bro, you lose a great ecommerce solution!

 
Magento Community Magento Community
Magento Community
Magento Community
 
zz00oo
Jr. Member
 
Total Posts:  3
Joined:  2011-03-15
 

Are you guys getting this error with the new sql file provided above or with the one you got from the download page?

 
Magento Community Magento Community
Magento Community
Magento Community
 
tongzhanshang
Jr. Member
 
Total Posts:  2
Joined:  2011-04-24
 

Thank you ecchi for the file - that solved the 1005 error for me!

 
Magento Community Magento Community
Magento Community
Magento Community
 
nvedia
Jr. Member
 
Total Posts:  14
Joined:  2008-03-16
 

Anyone knows what would be the best way to install sample data after installing magento?
Whenever I ran the sample sql from phpmyadmin after installing the magento, the sql file ran file with all quries run successfully, but whenever I click on the product page, it errors out and admin doesnt work too

Can we just run the INSERT statements?

 
Magento Community Magento Community
Magento Community
Magento Community
 
MicxaFica
Jr. Member
 
Total Posts:  1
Joined:  2011-12-20
 

I tried the same just with sample data imported to a new database and with the media folder copied to a new magento install directory, and I received the same fail as mentioned.

 
Magento Community Magento Community
Magento Community
Magento Community
 
webmasterdean
Jr. Member
 
Total Posts:  1
Joined:  2011-04-09
 

thank you very much.

it’s working

wworley - 07 March 2010 09:58 AM

I was able to get the following sql to work successfully

phpMyAdmin Version: 2.8.2.4
php Version: 5.0.89

on a completely new database with no issues

 
Magento Community Magento Community
Magento Community
Magento Community
 
laduda
Jr. Member
 
Total Posts:  6
Joined:  2007-09-19
 

MySQL - 5.0.27
phpMyAdmin - 2.8.2.4

CREATE TABLE `catalog_category_entity_datetime` (
`value_id` int( 11 ) NOT NULL AUTO_INCREMENT COMMENT ‘Value ID’,
`entity_type_id` smallint( 5 ) unsigned NOT NULL COMMENT ‘Entity Type ID’,
`attribute_id` smallint( 5 ) unsigned NOT NULL COMMENT ‘Attribute ID’,
`store_id` smallint( 5 ) unsigned NOT NULL COMMENT ‘Store ID’,
`entity_id` int( 10 ) unsigned NOT NULL COMMENT ‘Entity ID’,
`value` datetime DEFAULT NULL COMMENT ‘Value’,
PRIMARY KEY ( `value_id` ) ,
UNIQUE KEY `UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID` ( `entity_type_id` , `entity_id` , `attribute_id` , `store_id` ) ,
KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID` ( `entity_id` ) ,
KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID` ( `attribute_id` ) ,
KEY `IDX_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID` ( `store_id` ) ,
CONSTRAINT `FK_CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY ( `store_id` ) REFERENCES `core_store` ( `store_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CAT_CTGR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY ( `attribute_id` ) REFERENCES `eav_attribute` ( `attribute_id` ) ON DELETE CASCADE ON UPDATE CASCADE ,
CONSTRAINT `FK_CAT_CTGR_ENTT_DTIME_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY ( `entity_id` ) REFERENCES `catalog_category_entity` ( `entity_id` ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = ‘Catalog Category Datetime Attribute Backend Table’;

 
Magento Community Magento Community
Magento Community
Magento Community
 
Gundam_Zero
Jr. Member
 
Total Posts:  27
Joined:  2009-05-31
 

Hi guys,

i install new magento CE 1.7.0.2,and i use the sample data 1.6.1.0, first the Index Management is emapty and when i go in Cache Storage Management and flush magento cache it give me error.

i hope somebody see this.

thanks alot.

 
Magento Community Magento Community
Magento Community
Magento Community
 
dennise89
Jr. Member
 
Total Posts:  1
Joined:  2013-08-31
 

When i uploaded it as a .zip (name.sql.zip) it worked also.

 
Magento Community Magento Community
Magento Community
Magento Community
 
jains
Jr. Member
 
Total Posts:  1
Joined:  2013-09-20
 
jaredovi - 21 March 2013 02:01 AM

You should import sample data first and install later then it should work well.

Am using cpanel on remote host, with phpMyAdmin
- created DB, and user in SQL
- downloaded sample (zip file) http://www.magentocommerce.com/downloads/assets/1.6.1.0/magento-sample-data-1.6.1.0.zip
- logged via cpanel/phpMyadmin, browsed until I get to new magento DB created
- renamed sample file to xyz.sql.zip as per phpMyAdmin requirements
- start import sample zip file (format: SQL) via phpMyAdmin
- result: imported but 0 execution

on browsing the DB is still empty. version info:
- magento version 1.7.0.2 (to be installed, only after sample DB is created)
- PHP version 5.2.17
- MySQL version 5.1.63-rel13.4
- phpMyAdmin ver 4.0.5

Please help - totally confused after reading through so many threads.

UPDATE - tables were created. maybe I was interpreting the phpMyadmin wrongly. I unzipped the sample file, cut-paste the SQL into direct SQL execution, and blank tables were created. installed magento - frontend, backend shows up cleanly!

 
Magento Community Magento Community
Magento Community
Magento Community
 
fullnerlan
Jr. Member
 
Total Posts:  1
Joined:  2014-01-06
 

Hi there,

I receive the following error when importing the Database (sql file):

SQL query:

CREATE TABLE `tag` ( `tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘Tag Id’, `name` varchar(255) DEFAULT NULL COMMENT ‘Name’, `status` smallint(6) NOT NULL DEFAULT ‘0’ COMMENT ‘Status’, `first_customer_id` int(10) unsigned DEFAULT NULL COMMENT ‘First Customer Id’, `first_store_id` smallint(5) unsigned DEFAULT NULL COMMENT ‘First Store Id’, PRIMARY KEY (`tag_id`) USING BTREE, KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first_customer_id`), KEY `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID` (`first_store_id`), CONSTRAINT `FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`first_store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE NO ACTION, CONSTRAINT `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`first_customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT=’[...]

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘USING BTREE,
KEY `FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`first’ at line 7

Any idea? I used: magento-sample-data-1.6.1.0

Best regards,

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