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

HELP Site totally down after upgrading from 1.3.2.3 to 1.4, can’t access back or front only downloader
 
Chris Nudd
Jr. Member
 
Total Posts:  28
Joined:  2008-05-17
 

Getting the following. My heads is about to explode trying to figure out. Have seen posts on problem with replacing a block, or /lib file problems. Have no idea, have to get up. Any help or redirection to the problem extremely appreciated.

There has been an error processing your request
Error in file: \\\"/home/virtualb/public_html/posdirect/app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-1.4.0.0.21-1.4.0.0.22.php\\\" - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry \\\’3-1-531-0\\\’ for key 2

Trace:
#0 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception(\\\’Mage_Core\\\’, \\\’Error in file: ...\\\’)
#1 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/Resource/Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb(\\\’upgrade\\\’, \\\’1.4.0.0.21\\\’, \\\’1.4.0.0.28\\\’)
#2 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/Resource/Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(\\\’1.4.0.0.21\\\’, \\\’1.4.0.0.28\\\’)
#3 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/App.php(363): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/virtualb/public_html/posdirect/app/code/core/Mage/Core/Model/App.php(295): Mage_Core_Model_App->_initModules()
#6 /home/virtualb/public_html/posdirect/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#7 /home/virtualb/public_html/posdirect/index.php(78): Mage::run(\\\’\\\’, \\\’store\\\’)
#8 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
SimpleHelixcom
Enthusiast
 
Avatar
Total Posts:  906
Joined:  2007-08-31
Huntsville, AL
 

Hello,

If you have access to PHPMyAdmin, try this after backing up your files and database:

Clear these tables using phpMyAdmin. *EMPTY THEM, DO NOT DROP THEM!*

dataflow_batch_export
dataflow_batch_import
log_url
log_url_info
log_visitor
log_visitor_info
report_event

Then remove your store cache by deleting from your files the following folders:

var/cache
var/session

Good luck!

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