0

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 – ambenrqtg Jul 2 '14 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? – brentwpeterson Jul 2 '14 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.. – ambenrqtg Jul 4 '14 at 2:11
  • But still I get the error.. Please help! Anybody? – ambenrqtg Jul 8 '14 at 4:18
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, privacy policy and cookie policy

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