How can I solve this kind of error after transferring my magento file and SQL to new hosting?

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session_id' in 'field list'

Please see this screenshot for the error: http://prntscr.com/3yj69u

  • Hi Amit, I got this error SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rmmagsde_database.report_viewed_product_index' doesn't exist This is the screenshot1: prntscr.com/3ykmg2 And when I got login I see this error also. SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rmmagsde_database.sales_flat_order' doesn't exist This is the screenshot2: prntscr.com/3ykmug
    – ambengran
    Jul 2, 2014 at 6:42
  • Have you cleared, the cache? Are you using the same version of Magento on the new hosting company? Did you wait for the SQL script to finish importing? Jul 2, 2014 at 11:28
  • Hi Brent, Yes! I cleared all the cache from var/cache folder, I am still using the same version of magento, and yes finish and wait the SQL script importing successful..
    – ambengran
    Jul 4, 2014 at 2:11
  • But still I get the error.. Please help! Anybody?
    – ambengran
    Jul 8, 2014 at 4:18

1 Answer 1


It appears that something has gone wrong when coping over your databases. Maybe it did not complete or something.

The error suggests that the column session_id is not on the table log_visitor. Which it should be, at least in version 1.6 and upwards.

I would suggest that you try again with your database copy. Make sure that it completes and validate the old database and new database to see if there are any issues between the two regards structure of the log_visitor table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.