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