Base table or view not found Fix for Magento 1 Responsive Admin Template By CMSmart

Base table or view not found Fix for Magento 1  Responsive Admin Template By CMSmart

Plugin Link : https://cmsmart.net/magento-themes/magento-responsive-admin-template

Issue : Error in admin dashboard after installation

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

Fix

  1. Go to app/design/adminhtml/default/admintheme/template/dashboard/index.phtml
  2. Paste below code, line number 215
                       <?php
                                // Gets the current store's details
                                $storeId = Mage::app()->getRequest()->getParam('store');
    							$log_customer = Mage::getSingleton('core/resource')->getTableName('log_customer');
                                $connection = Mage::getModel('core/resource')->getConnection('core_read');
                                $sql = 'SELECT * FROM `'.$log_customer.'` ORDER BY `log_id` DESC';
                                $customers = $connection->fetchAll($sql);
                            ?>

Leave a Reply