cancel
Showing results for 
Search instead for 
Did you mean: 

Database issues I think...

Database issues I think...

Hi everyone,

 

I'm running a website and i'll cut the long story short, I have a website that needs to go back online. I ran a bunch of updates from 1.9.2.1 to 1.9.2.4 in Magento Connect without backing up and shortly afterwards I was getting problems with 500 internal errors.

At this point i downloaded the database, took all of my files that 1&1 has hosted from a couple days ago and re-uploaded them.

 

The database is in PhpMyAdmin and i added it back in, there were a couple errors (obviously)

 

Now my website is stuck with an error page, my products still exist but i can do nothing.

 

At the moment i'm trying to get them to send me an older database that doesn't have issues in the hope that everything will be alright and i can continue on.

 

Help would be appreciated.

Heart

 

Matthew Theobald.

 

EDIT: I assume the bulk of the problem is that in the mysql database, everything is referencing updated files whereas i'm currently using the old ones because the updated ones broke the website. If anyone has a method of fixing this, many thank's would be given!

 

TL : DR Version

Pretty sure i need a blank database that i can shove products in for 1.9.2.1 but i don't think it's possible.

3 REPLIES

Re: Database issues I think...

This is the var/report 1963631 at the top...

 

http://imgur.com/WE3JuQj

 

a:4:{i:0;s:94:"SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known";i:1;s:3373:"#0 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect()
#3 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#4 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#5 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#6 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element))
#7 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write')
#8 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write')
#9 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
#10 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Resource/Cache.php(53): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
#11 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Cache.php(478): Mage_Core_Model_Resource_Cache->getAllOptions()
#12 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Cache.php(520): Mage_Core_Model_Cache->_initOptions()
#13 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/App.php(1202): Mage_Core_Model_Cache->canUse('config')
#14 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Config.php(414): Mage_Core_Model_App->useCache('config')
#15 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/Config.php(294): Mage_Core_Model_Config->_canUseCacheForInit()
#16 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/App.php(424): Mage_Core_Model_Config->loadModulesCache()
#17 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
#18 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#19 /homepages/34/d614833542/htdocs/clickandbuilds/Magento/NaturalPetSupply/index.php(83): Mage::run('', 'store')
#20 {main}";s:3:"url";s:1:"/";s:11:"script_name";s:10:"/index.php";}

Re: Database issues I think...

New update, I've been given the new database, i've uploaded it and it went smoothly. But even with that said, i'm still not able to see the website.

 

Cleanup tool says

 

-= WARNING =- Overrides or extensions exist in the app/code/local folder
-= WARNING =- Overrides or extensions exist in the app/code/community folder

Re: Database issues I think...

Hi

Did you get this fixed as I am having exactly the same problem with a site hosted at 1and1 who are trying to be helpful but cannot sort this out. Although I know the the database structure is fine.