I have migrated my Magento site from shared to VPS, after complete migration it is showing some kind of error. Here it is.

a:5:{i:0;s:250:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'mojaric1_mage767.mgw0_log_visitor' doesn't exist, query was: INSERT INTO mgw0_log_visitor (session_id, first_visit_at, last_visit_at, last_url_id, store_id) VALUES (?, ?, ?, ?, ?)";i:1;s:2645:"#0 /home/mojaric1/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

enter image description here

  • Check if mgw0_log_visitor is exist in DB after migration or not? – aman Feb 16 '18 at 8:49
  • You should check too in the app/etc/local.xml if there is (or was in your old hosting) a node <table_prefix>. – Julien Loizelet Feb 16 '18 at 9:41
  • Yes here is a node of <table_prefix> in <table_prefix>@JulienLoizelet – Nadir Hussain Feb 16 '18 at 9:58
  • Yes there is no any table named mgw0_log_visitor in database, but i have manually imported database from my old server. Now its showing php fetal error. @aman – Nadir Hussain Feb 16 '18 at 9:59
  • Check your dump file if having this table or not, might be somehow this table is missed. Or you can create table manually in new server now. – aman Feb 16 '18 at 10:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.