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 Upgrading on 1and1
 
iPhony
Member
 
Avatar
Total Posts:  37
Joined:  2007-09-01
 

I upload the new Magento ver. 0.8.17240 to my 1and1 folder and renamed the current folder to make this new install become the new folder.
However right after entering the database info and pressing next I get the following errors. Any clue?
---------

PDOException Object
(
    
[message:protected] => SQLSTATE[HY000]General error1005 Can't create table './db216384921/storecore_layout_link.frm' (errno: 121)
    [string:private] => 
    [code:protected] => HY000
    [file:protected] => /homepages/12/d147385902/htdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
    [line:protected] => 109
    [trace:private] => Array
        (
            [0] => Array
                (
                    [file] => /homepages/12/d147385902/htdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 109
                    [function] => query
                    [class] => PDO
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `storecore_layout_link` (
  `layout_link_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned NOT NULL default '
0',
  `package` varchar(64) NOT NULL default '',
  `theme` varchar(64) NOT NULL default '',
  `layout_update_id` int(10) unsigned NOT NULL default '
0',
  PRIMARY KEY  (`layout_link_id`),
  UNIQUE KEY `store_id` (`store_id`,`package`,`theme`,`layout_update_id`),
  KEY `FK_core_layout_link_update` (`layout_update_id`),
  CONSTRAINT `FK_CORE_LAYOUT_LINK_STORE` FOREIGN KEY (`store_id`) REFERENCES `storecore_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_core_layout_link_update` FOREIGN KEY (`layout_update_id`) REFERENCES `storecore_layout_update` (`layout_update_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
                        )

                )

            [1] => Array
                (
                    [file] => /homepages/12/d147385902/htdocs/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 147
                    [function] => raw_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `storecore_layout_link` (
  `layout_link_id` int(10) unsigned NOT NULL auto_increment,
  `store_id` smallint(5) unsigned NOT NULL default '
0',
  `package` varchar(64) NOT NULL default '',
  `theme` varchar(64) NOT NULL default '',
  `layout_update_id` int(10) unsigned NOT NULL default '
0',
  PRIMARY KEY  (`layout_link_id`),
  UNIQUE KEY `store_id` (`store_id`,`package`,`theme`,`layout_update_id`),
  KEY `FK_core_layout_link_update` (`layout_update_id`),
  CONSTRAINT `FK_CORE_LAYOUT_LINK_STORE` FOREIGN KEY (`store_id`) REFERENCES `storecore_store` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_core_layout_link_update` FOREIGN KEY (`layout_update_id`) REFERENCES `storecore_layout_update` (`layout_update_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
                        )

                )

            [2] => Array
                (
                    [file] => /homepages/12/d147385902/htdocs/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 484
                    [function] => multi_query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
DROP TABLE IF EXISTS `storecore_config_data`;
CREATE TABLE `storecore_config_data` (
  `config_id` int(10) unsigned NOT NULL auto_increment,
  `scope` enum('
default','websites','stores','config') NOT NULL default 'default',
  `scope_id` int(11) NOT NULL default '
0',
  `path` varchar(255) NOT NULL default '
general',
  `value` text NOT NULL,
  PRIMARY KEY  (`config_id`),
  UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[...]
 
Magento Community Magento Community
Magento Community
Magento Community
 
iPhony
Member
 
Avatar
Total Posts:  37
Joined:  2007-09-01
 

Unless I am missing something, while this magento release works fine with a new installation it looks like it has issues upgrading the database.
Anyone else succeeded upgrading?

Also it has always been a pain upgrading magento for those who have already uploaded product. Can you guys suggest what the best way to upgrade is?

Thanks.

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