search

ubertheme / module-ubdatamigration

This is a module for Magento 2. This allow migrate data from Magento 1.x to Magento 2.x
https://www.ubertheme.com/magento-extensions-2-x/magento-2-data-migration-pro?utm_source=github&utm_medium=repo&utm_campaign=magento_migration_ce
48 stars 38 forks source link

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'petshop_new.catalogsearch_fulltext_scope3' doesn't exist' #31

Open azucenaz opened 8 years ago

azucenaz commented 8 years ago

successfully migrate but once i want to edit products it gives me error.

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'petshop_new.catalogsearch_fulltext_scope3' doesn't exist' in C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement\Pdo.php:228 Stack trace: #0 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array) #1 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Statement\Pdo\Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array) #2 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array) #3 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array) #4 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('DELETE FROM ca...', Array) #5 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Adapter\Pdo\Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('DELETE FROMca...', Array) #6 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\DB\Adapter\Pdo\Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('DELETE FROM ca...', Array) #7 C:\xampp\htdocs\petshop_new\vendor\magento\zendframework1\library\Zend\Db\Adapter\Abstract.php(664): Magento\Framework\DB\Adapter\Pdo\Mysql->query('DELETE FROMca...') #8 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\IndexerHandler.php(106): Zend_Db_Adapter_Abstract->delete('catalogsearch_f...', Array) #9 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext.php(91): Magento\CatalogSearch\Model\Indexer\IndexerHandler->deleteIndex(Array, Object(ArrayObject)) #10 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext.php(142): Magento\CatalogSearch\Model\Indexer\Fulltext->execute(Array) #11 C:\xampp\htdocs\petshop_new\app\code\Magento\Indexer\Model\Indexer.php(433): Magento\CatalogSearch\Model\Indexer\Fulltext->executeRow('1') #12 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\AbstractPlugin.php(34): Magento\Indexer\Model\Indexer->reindexRow('1') #13 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product.php(26): Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\AbstractPlugin->reindexRow('1') #14 [internal function]: Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin{closure}() #15 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Model\ResourceModel\AbstractResource.php(94): call_user_func(Object(Closure)) #16 C:\xampp\htdocs\petshop_new\var\generation\Magento\Catalog\Model\ResourceModel\Product\Interceptor.php(713): Magento\Framework\Model\ResourceModel\AbstractResource->commit() #17 C:\xampp\htdocs\petshop_new\app\code\Magento\Eav\Model\Entity\AbstractEntity.php(1156): Magento\Catalog\Model\ResourceModel\Product\Interceptor->commit() #18 [internal function]: Magento\Eav\Model\Entity\AbstractEntity->save(Object(Magento\Catalog\Model\Product\Interceptor)) #19 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Interceptor.php(74): call_user_func_array(Array, Array) #20 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(70): Magento\Catalog\Model\ResourceModel\Product\Interceptor->___callParent('save', Array) #21 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(63): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Catalog...', 'save', Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Array, 'catalogsearchFu...') #22 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product.php(28): Magento\Framework\Interception\Chain\Chain->Magento\Framework\Interception\Chain{closure}(Object(Magento\Catalog\Model\Product\Interceptor)) #23 [internal function]: Magento\CatalogSearch\Model\Indexer\Fulltext\Plugin\Product->aroundSave(Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Object(Closure), Object(Magento\Catalog\Model\Product\Interceptor)) #24 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Chain\Chain.php(68): call_user_func_array(Array, Array) #25 C:\xampp\htdocs\petshop_new\lib\internal\Magento\Framework\Interception\Interceptor.php(136): Magento\Framework\Interception\Chain\Chain->invokeNext('Magento\Catalog...', 'save', Object(Magento\Catalog\Model\ResourceModel\Product\Interceptor), Array, 'apply_catalog_r...') #26 C:\xampp\htdocs\petshop_new\app\code\Magento\CatalogRule\Plugin\Indexer\Product\Save\ApplyRules.php(40): Magento\Catalog\Model\ResourceModel\Product\Interceptor-