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

Support Forums Modules and Extensions Marketplace Extension SQLSTATE[42S02]: Base table or view not found

This topic contains 0 replies, has 0 voices, and was last updated by  davidmilan 8 years, 7 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #368

    davidmilan
    Member

    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,

    #542

    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,

Viewing 2 posts - 1 through 2 (of 2 total)

You must Login/Register to reply to this topic.