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

Crucial Web Hosting spotted an error
 
leeaston
Sr. Member
 
Total Posts:  77
Joined:  2007-11-26
France
 

I get this error on the front page of my site.going to 1.1.7 to 1.1.8. Crucial Web Hosting look after my site and attempted the upgrade - they advised me to post the errors here.

What’s the fix guys? is 1.1.9 on the way?

Best wishes
Lee

PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘catalogrule_affected_product’ already exists
[string:private] =>
[code:protected] => 42S01
[file:protected] => /home/packycom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line:protected] => 187
[trace:private] => Array
(
[0] => Array
(
[file] => /home/packycom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 187
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] => CREATE TABLE catalogrule_affected_product (
`product_id` int(10) unsigned NOT NULL,
KEY `IDX_PRODUCT` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)

)

[1] => Array
(
[file] => /home/packycom/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 249
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => CREATE TABLE catalogrule_affected_product (
`product_id` int(10) unsigned NOT NULL,
KEY `IDX_PRODUCT` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
)

)

[2] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 493
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE catalogrule_affected_product (
`product_id` int(10) unsigned NOT NULL,
KEY `IDX_PRODUCT` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

)

)

[3] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/CatalogRule/sql/catalogrule_setup/mysql4-upgrade-0.7.4-0.7.5.php
[line] => 37
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
CREATE TABLE catalogrule_affected_product (
`product_id` int(10) unsigned NOT NULL,
KEY `IDX_PRODUCT` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

)

)

[4] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 268
[args] => Array
(
[0] => /home/packycom/public_html/app/code/core/Mage/CatalogRule/sql/catalogrule_setup/mysql4-upgrade-0.7.4-0.7.5.php
)

[function] => include
)

[5] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 178
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 0.7.3
[2] => 0.7.5
)

)

[6] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 145
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.7.3
[1] => 0.7.5
)

)

[7] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 120
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)

)

[8] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/Config.php
[line] => 215
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[9] => Array
(
[file] => /home/packycom/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 243
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
[0] => Array
(
)

)

)

[10] => Array
(
[file] => /home/packycom/public_html/app/Mage.php
[line] => 424
[function] => init
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)

)

)

[11] => Array
(
[file] => /home/packycom/public_html/app/Mage.php
[line] => 443
[function] => app
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
[2] => Array
(
)

)

)

[12] => Array
(
[file] => /home/packycom/public_html/index.php
[line] => 46
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)

)

)

[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table ‘catalogrule_affected_product’ already exists
)

)
Error in file: “/home/packycom/public_html/app/code/core/Mage/CatalogRule/sql/catalogrule_setup/mysql4-upgrade-0.7.4-0.7.5.php” - SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘catalogrule_affected_product’ already exists

#0 /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(286): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(178): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.7.3’, ‘0.7.5’)
#2 /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(145): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.7.3’, ‘0.7.5’)
#3 /home/packycom/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php(120): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/packycom/public_html/app/code/core/Mage/Core/Model/Config.php(215): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/packycom/public_html/app/code/core/Mage/Core/Model/App.php(243): Mage_Core_Model_Config->init(Array)
#6 /home/packycom/public_html/app/Mage.php(424): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /home/packycom/public_html/app/Mage.php(443): Mage::app(’’, ‘store’, Array)
#8 /home/packycom/public_html/index.php(46): Mage::run()
#9 {main}

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

Well, there is nothing wrong with the 1.1.8 release, so something must have gone wrong during the upgrade. Advise your host to re-install the upgrade through SSH like this:

./pear install -f magento-core/Mage_All_Latest

Some dependencies might be missing.

PS: if that does not help, you can restore the backup you should have made before attempting to upgrade. smile

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