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);
                            ?>
John Perri Cruz

About the Author

John Perri Cruz was born in the Philippines, at the cold month of december. (Not cold enough cause Philippines is a tropical country.)

He's currently working as a Fullstack Web developer and when not sleeping, he can be found in coffee shop most of the time.

He gained his experience and skills by making and developing websites and systems for various individuals. He is well equipped with different Web programming languages and tools.

Connect :


Buy me a cup of coffee :

Leave a Reply