Magento – SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘session_id’ in ‘field list’

magento-1.4magento-enterpriseMySQLsql

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

Best Answer

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.

Related Topic