SQLSTATE[42S02]: Base table or view not found

[davidmilanMember]

Hi,

After install Magento marketplace extension getting below error in my magento admin panel.

There has been an error processing your request
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘tstore_mg.marketplace_seller’ doesn’t exist, query was: SELECT COUNT(*) FROM `marketplace_seller` AS `main_table`

Trace:
#0 /home/tstore/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/tstore/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/tstore/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/tstore/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(*)…’, Array)
#4 /home/tstore/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(*)…’, Array)
#5 /home/tstore/public_html/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/tstore/public_html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /home/tstore/public_html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /home/tstore/public_html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()

How to resolve this issue?

Thanks,

[imported_adminMember]

Hi David,

It looks you have not properly uninstalled the extension in your store.

Please follow the below steps in your site.

1. Uninstall the extension in your store.

2. Then delete the below tables in your DB.

sales_flat_quote,
Delete field seller_total_shipping_amount
sales_flat_quote_item,
Delete filed sellerid,optionid,shipping_calculated_method,shipping_calculated_amount
sales_flat_order_item,
Delete field sellerid,optionid,shipping_calculated_method,shipping_calculated_amount
sales_flat_order_grid,
Delete field site_purchase_order_status
sales_flat_invoice_item
Delete filed sellerid,optionid,shipping_calculated_method,shipping_calculated_amount
Marketplace tables and setup in core_resource table

3. Disable cache and install the extension again.

If you still face the same issue, please email to support@modulebazaar.com

Thanks,

[Author]

Posts