cancel
Showing results for 
Search instead for 
Did you mean: 

Magento Umzug Backend error

Magento Umzug Backend error

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:

There has been an error processing your request
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!

3 REPLIES

Re: Magento Umzug Backend error

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.

Beste Grüße | Regards, Roman from CopeX.io

Re: Magento Umzug Backend error

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.

Re: Magento Umzug Backend error

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.

Beste Grüße | Regards, Roman from CopeX.io