php - Magento Error : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shoukatt_mgnt1.captcha_log' doesn't exist -
i new magento , dont have lot of coding idea. installed magento , installed sample data new sql file, made user name , password of magento admin panel vanish, created username , password through sql database.
but when login in admin panel, receive error "magento : exception printing disabled default security reasons". when refresh page can access admin panel
i opened error vile in var/errors number received , changed xml file.
i mentioning every thing written in file, please me or have install magento again , lost data , configuration
a:5:{i:0;s:100:" sqlstate[42s02]: base table or view not found: 1146 table 'shoukatt_mgnt1.captcha_log' doesn't exist";i:1;s:3388:" #0 /home4/shoukatt/public_html/mag/includes/src/varien_db_statement_pdo_mysql.php(110): zend_db_statement_pdo->_execute(array) #1 /home4/shoukatt/public_html/mag/includes/src/__default.php(63012): varien_db_statement_pdo_mysql->_execute(array) #2 /home4/shoukatt/public_html/mag/includes/src/__default.php(52694): zend_db_statement->execute(array) #3 /home4/shoukatt/public_html/mag/includes/src/__default.php(53730): zend_db_adapter_abstract->query('delete `ca...', array) #4 /home4/shoukatt/public_html/mag/includes/src/__default.php(54566): zend_db_adapter_pdo_abstract->query('delete `ca...', array) #5 /home4/shoukatt/public_html/mag/includes/src/__default.php(52876): varien_db_adapter_pdo_mysql->query('delete `ca...') #6 /home4/shoukatt/public_html/mag/includes/src/mage_captcha_model_resource_log.php(100): zend_db_adapter_abstract->delete('captcha_log', array) #7 /home4/shoukatt/public_html/mag/includes/src/mage_captcha_model_observer.php(276): mage_captcha_model_resource_log->deleteuserattempts('usman') #8 /home4/shoukatt/public_html/mag/includes/src/mage_captcha_model_observer.php(233): mage_captcha_model_observer->_resetattempt('usman') #9 /home4/shoukatt/public_html/mag/includes/src/__default.php(21045): mage_captcha_model_observer->resetattemptforbackend(object(varien_event_observer)) #10 /home4/shoukatt/public_html/mag/includes/src/__default.php(21024): mage_core_model_app->_callobservermethod(object(mage_captcha_model_observer), 'resetattemptfor...', object(varien_event_observer)) #11 /home4/shoukatt/public_html/mag/app/mage.php(447): mage_core_model_app->dispatchevent('admin_session_u...', array) #12 /home4/shoukatt/public_html/mag/includes/src/mage_admin_model_session.php(104): mage::dispatchevent('admin_session_u...', array) #13 /home4/shoukatt/public_html/mag/includes/src/mage_admin_model_observer.php(69): mage_admin_model_session->login('usman', '86288844', object(mage_core_controller_request_http)) #14 /home4/shoukatt/public_html/mag/includes/src/__default.php(21045): mage_admin_model_observer->actionpredispatchadmin(object(varien_event_observer)) #15 /home4/shoukatt/public_html/mag/includes/src/__default.php(21024): mage_core_model_app->_callobservermethod(object(mage_admin_model_observer), 'actionpredispat...', object(varien_event_observer)) #16 /home4/shoukatt/public_html/mag/app/mage.php(447): mage_core_model_app->dispatchevent('controller_acti...', array) #17 /home4/shoukatt/public_html/mag/includes/src/__default.php(13691): mage::dispatchevent('controller_acti...', array) #18 /home4/shoukatt/public_html/mag/includes/src/mage_adminhtml_controller_action.php(160): mage_core_controller_varien_action->predispatch() #19 /home4/shoukatt/public_html/mag/includes/src/__default.php(13571): mage_adminhtml_controller_action->predispatch() #20 /home4/shoukatt/public_html/mag/includes/src/__default.php(17927): mage_core_controller_varien_action->dispatch('index') #21 /home4/shoukatt/public_html/mag/includes/src/__default.php(17484): mage_core_controller_varien_router_standard->match(object(mage_core_controller_request_http)) #22 /home4/shoukatt/public_html/mag/includes/src/__default.php(20061): mage_core_controller_varien_front->dispatch() #23 /home4/shoukatt/public_html/mag/app/mage.php(683): mage_core_model_app->run(array) #24 /home4/shoukatt/public_html/mag/index.php(87): mage::run('', 'store') #25 {main}";s:3:"url";s:6:"/admin";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:5:"admin";}
the error tells problem is.
base table or view not found: 1146 table 'shoukatt_mgnt1.captcha_log' doesn't exist
an extension attempting load table shoukatt_mgnt1
in database, since not exist it's failing. you'll either have restore table, or reinstall extension table get's recreated.
Comments
Post a Comment