Appreciate if anyone could help me out, as I've been searching for a solution for hours, but they are all pretty vague.
When I attempt to access my website receive the following error:
There has been an error processing your request SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopstel_magento.core_store' doesn't exist Trace:
#0 /home/shopstel/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/shopstel/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/shopstel/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT main_ta...', Array)
#3 /home/shopstel/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#4 /home/shopstel/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/shopstel/public_html/lib/Varien/Data/Collection/Db.php(779): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#6 /home/shopstel/public_html/lib/Varien/Data/Collection/Db.php(696): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#7 /home/shopstel/public_html/lib/Varien/Data/Collection/Db.php(617): Varien_Data_Collection_Db->getData()
#8 /home/shopstel/public_html/app/code/core/Mage/Core/Model/Mysql4/Store/Collection.php(137): Varien_Data_Collection_Db->load(false, false)
#9 /home/shopstel/public_html/lib/Varien/Data/Collection.php(740): Mage_Core_Model_Mysql4_Store_Collection->load()
#10 /home/shopstel/public_html/app/code/core/Mage/Core/Model/App.php(581): Varien_Data_Collection->count()
#11 /home/shopstel/public_html/app/code/core/Mage/Core/Model/App.php(429): Mage_Core_Model_App->_initStores()
#12 /home/shopstel/public_html/app/code/core/Mage/Core/Model/App.php(335): Mage_Core_Model_App->_initCurrentStore('', 'store')
#13 /home/shopstel/public_html/app/Mage.php(627): Mage_Core_Model_App->run(Array)
#14 /home/shopstel/public_html/index.php(80): Mage::run('', 'store')
After reading many websites, I understand that Magento is trying to grab a table, that does not exist (for some reason). I have not updated/changed my website for a year or so, and I even asked my host to restore my database to last year, but the error message is still appearing.
I am not an expert at coding, but I can follow specific instructions. Ideally I would like to remove the error without reinstalling Magento. I have read somewhere too that core_store is a simple table. Someone please help me to solve this problem. Let me know if you need any more information from me. Thank you so much and appreciate your time!