Hi,
wir haben unseren Magento Shop auf einen neuen Server umgezogen. Soweit funktioniert auch alles nur der Admin Bereich ist nicht aufrufbar.
Folgende Fehlermeldung bekommen wir:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db00081785.catalogsearch_query' doesn't exist, query was: SELECT COUNT(*) FROM `catalogsearch_query` AS `main_table`
Trace: #0 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array) #4 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array) #5 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array) #6 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array) #7 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize() #8 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber() #9 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Data/Collection/Db.php(522): Varien_Data_Collection->getCurPage() #10 /pages/ae/2c/d0011806/home/htdocs/impressys/lib/Varien/Data/Collection/Db.php(569): Varien_Data_Collection_Db->_renderLimit() #11 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(533): Varien_Data_Collection_Db->load() #12 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Dashboard/Searches/Last.php(66): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection() #13 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(626): Mage_Adminhtml_Block_Dashboard_Searches_Last->_prepareCollection() #14 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(632): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid() #15 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml() #16 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #17 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('lastSearches', true) #18 /pages/ae/2c/d0011806/home/htdocs/impressys/app/design/adminhtml/default/default/template/dashboard/index.phtml(109): Mage_Core_Block_Abstract->getChildHtml('lastSearches') #19 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(241): include('/pages/ae/2c/d0...') #20 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') #21 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #22 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() #23 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() #24 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #25 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() #26 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() #27 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('content', true) #28 /pages/ae/2c/d0011806/home/htdocs/impressys/app/design/adminhtml/default/default/template/page.phtml(74): Mage_Core_Block_Abstract->getChildHtml('content') #29 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(241): include('/pages/ae/2c/d0...') #30 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') #31 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #32 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() #33 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() #34 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #35 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #36 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(43): Mage_Core_Controller_Varien_Action->renderLayout() #37 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_DashboardController->indexAction() #38 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index') #39 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #40 /pages/ae/2c/d0011806/home/htdocs/impressys/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #41 /pages/ae/2c/d0011806/home/htdocs/impressys/app/Mage.php(684): Mage_Core_Model_App->run(Array) #42 /pages/ae/2c/d0011806/home/htdocs/impressys/index.php(88): Mage::run('', 'store') #43 {main}
In unserern .htaccess Datei steht nur folgendes:
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
Kann uns da jemand helfen? Vielen Dank!
Hallo,
die Fehlermeldung bedeutet das die Tabelle 'catalogsearch_query' nicht existiert.
Schau mal in der DB ob sie existiert. Wenn nicht sollte sie vom alten Server übernommen werden.
Vielen Dank für die Antwort, das habe ich mir auch schon gedacht und Sie existiert wirklich nicht. Aber auch auf dem alten Server exisitiert diese nicht. Datenbank wurde auch 1:1 übernommen.
Ich empfehle die Tabelle zu erzeugen...
Welche Version von Magento wird verwendet? Bitte genau die Version posten also zb. 1.9.3.2 dann kann ich ein SQL-Script zur Verfügung stellen welches die Tabelle anlegt.