cancel
Showing results for 
Search instead for 
Did you mean: 

There has been an error processing your request - live to local

There has been an error processing your request - live to local

I had recently changed my live magento site to localhost it showed me this error.

 

cleared cache tried renaming errors/local.xml.sample to errors/local.xml

 

changed DB also..... restarted XAMPP also.....

 

 

 

Error log record number: 1003559877

 

 

SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Trace: #0 C:\xampp\htdocs\jskgemstore\lib\Zend\Db\Adapter\Pdo\Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 C:\xampp\htdocs\jskgemstore\lib\Varien\Db\Adapter\Pdo\Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 C:\xampp\htdocs\jskgemstore\lib\Zend\Db\Adapter\Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect() #3 C:\xampp\htdocs\jskgemstore\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #4 C:\xampp\htdocs\jskgemstore\lib\Varien\Db\Adapter\Pdo\Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #5 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8') #6 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element)) #7 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource\Db\Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write') #8 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource\Db\Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write') #9 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource\Db\Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter() #10 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Resource\Cache.php(53): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter() #11 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Cache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions() #12 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Cache.php(520): Mage_Core_Model_Cache->_initOptions() #13 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\App.php(1202): Mage_Core_Model_Cache->canUse('config') #14 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\Config.php(446): Mage_Core_Model_App->useCache('config') #15 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\App.php(432): Mage_Core_Model_Config->saveCache() #16 C:\xampp\htdocs\jskgemstore\app\code\core\Mage\Core\Model\App.php(354): Mage_Core_Model_App->_initModules() #17 C:\xampp\htdocs\jskgemstore\app\Mage.php(684): Mage_Core_Model_App->run(Array) #18 C:\xampp\htdocs\jskgemstore\index.php(83): Mage::run('', 'store') #19 {main}

 

1 REPLY

Re: There has been an error processing your request - live to local

1- Import your live site database in localhost

2- Enter the correct database connection details in the magentosite/app/etc/local.xml

3- Then Refresh the page

          <default_setup>
                <connection>
                    <host><![CDATA[localhost]]></host>
                    <username><![CDATA[username]]></username>
                    <password><![CDATA[password]]></password>
                    <dbname><![CDATA[dbname]]></dbname>
                    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
                    <model><![CDATA[mysql4]]></model>
                    <type><![CDATA[pdo_mysql]]></type>
                    <pdoType><![CDATA[]]></pdoType>
                    <active>1</active>
                </connection>
            </default_setup>
OpenSource Expert | OpenSource Technologies | www.opensourcetechnologies.com
Magento plugins released: http://www.opensourcetechnologies.com/product/product-category/magento-extensions