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

Site unavailable… [URGENT]
 
julgp
Jr. Member
 
Total Posts:  3
Joined:  2011-09-16
 

I updated from 1.6.x to the latest (1.7.0.2) and tried installing an extension that required to disable all cache.

Now when I try to access the homepage I am redirected to homepage/errors/report.php?id=1337894712002&skin;=default.

I can access MageConnect, but I get a cache error if I try to reinstall Mage_All_Latest

Below, the error message on the front page

Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘default-0-general/region/display_all’ for key ‘UNQ_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH’
[string:Exception:private] =>
[code:protected] => 23000
[file:protected] => /home/username/public_html/mywebsite/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[1] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[2] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[3] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[4] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[5] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Abstract.php
[line] => 574
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[6] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Directory/data/directory_setup/data-upgrade-1.6.0.0-1.6.0.1.php
[line] => 38
[function] => insert
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => core_config_data
[1] => Array
(
[scope] => default
[scope_id] => 0
[path] => general/region/display_all
[value] => 1
)

)

)

[7] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/username/public_html/mywebsite/app/code/core/Mage/Directory/data/directory_setup/data-upgrade-1.6.0.0-1.6.0.1.php
)

[function] => include
)

[8] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 407
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => data-upgrade
[1] => 1.6.0.0
[2] => 1.6.0.1
)

)

[9] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 286
[function] => _upgradeData
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.6.0.0
[1] => 1.6.0.1
)

)

[10] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 269
[function] => applyDataUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)

)

[11] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/App.php
[line] => 351
[function] => applyAllDataUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[12] => Array
(
[file] => /home/username/public_html/mywebsite/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)

)

)

)

[13] => Array
(
[file] => /home/username/public_html/mywebsite/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)

)

)

[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘default-0-general/region/display_all’ for key ‘UNQ_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH’
[string:Exception:private] =>
[code:protected] => 23000
[file:protected] => /home/username/public_html/mywebsite/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[1] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[2] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[3] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[4] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[5] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[6] => Array
(
[file] => /home/username/public_html/mywebsite/lib/Zend/Db/Adapter/Abstract.php
[line] => 574
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES (?, ?, ?, ?)
[1] => Array
(
[0] => default
[1] => 0
[2] => general/region/display_all
[3] => 1
)

)

)

[7] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Directory/data/directory_setup/data-upgrade-1.6.0.0-1.6.0.1.php
[line] => 38
[function] => insert
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => core_config_data
[1] => Array
(
[scope] => default
[scope_id] => 0
[path] => general/region/display_all
[value] => 1
)

)

)

[8] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/username/public_html/mywebsite/app/code/core/Mage/Directory/data/directory_setup/data-upgrade-1.6.0.0-1.6.0.1.php
)

[function] => include
)

[9] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 407
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => data-upgrade
[1] => 1.6.0.0
[2] => 1.6.0.1
)

)

[10] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 286
[function] => _upgradeData
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.6.0.0
[1] => 1.6.0.1
)

)

[11] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 269
[function] => applyDataUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)

)

[12] => Array
(
[file] => /home/username/public_html/mywebsite/app/code/core/Mage/Core/Model/App.php
[line] => 351
[function] => applyAllDataUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)

)

[13] => Array
(
[file] => /home/username/public_html/mywebsite/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)

)

)

)

[14] => Array
(
[file] => /home/username/public_html/mywebsite/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)

)

)

[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 23000
[1] => 1062
[2] => Duplicate entry ‘default-0-general/region/display_all’ for key ‘UNQ_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH’
)

)

)

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