transfer - Magento 1.6 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'store_id' in 'field list'

Question

I have transferred a working Magento 1.6 site to a new host using the same file structure and database, I haven't changed anything apart from the database connection. Permissions are all correct and after a lot of fixing of the old database ie creating the required fields and uploading the data correctly I have a fully working backend.

The host doesn't support Varnish so this is all disabled I have compiled and I have removed cache and sessions repeatedly.

This error on the front page and I can't find any information about how to fix it:

There has been an error processing your request

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

Trace: #0 /home/sites/14b/e/e9d9945812/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/sites/14b/e/e9d9945812/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /home/sites/14b/e/e9d9945812/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /home/sites/14b/e/e9d9945812/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO lo...', Array) #4 /home/sites/14b/e/e9d9945812/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO lo...', Array) #5 /home/sites/14b/e/e9d9945812/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `lo...', Array) #6 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(448): Zend_Db_Adapter_Abstract->insert('log_visitor', Array) #7 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Log_Model_Visitor)) #8 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Log/Model/Visitor.php(167): Mage_Core_Model_Abstract->save() #9 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Model/App.php(1304): Mage_Log_Model_Visitor->initByRequest(Object(Varien_Event_Observer)) #10 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Model/App.php(1285): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Log_Model_Visitor), 'initByRequest', Object(Varien_Event_Observer)) #11 /home/sites/14b/e/e9d9945812/public_html/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array) #12 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(505): Mage::dispatchEvent('controller_acti...', Array) #13 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Controller/Front/Action.php(59): Mage_Core_Controller_Varien_Action->preDispatch() #14 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(409): Mage_Core_Controller_Front_Action->preDispatch() #15 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index') #16 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #17 /home/sites/14b/e/e9d9945812/public_html/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch() #18 /home/sites/14b/e/e9d9945812/public_html/app/Mage.php(640): Mage_Core_Model_App->run(Array) #19 /home/sites/14b/e/e9d9945812/public_html/index.php(80): Mage::run('', 'store') #20 {main}

The error logs are:

2021-01-07T10:09:58+00:00 ERR (3): Deprecated functionality: iconv_set_encoding(): Use of iconv.internal_encoding is deprecated in /home/sites/14b/e/e9d9945812/public_html/includes/src/Zend_Locale_Format.php on line 311 2021-01-07T10:09:58+00:00 ERR (3): Deprecated functionality: iconv_set_encoding(): Use of iconv.internal_encoding is deprecated in /home/sites/14b/e/e9d9945812/public_html/includes/src/Zend_Locale_Format.php on line 472 2021-01-07T10:09:58+00:00 ERR (3): Notice: Undefined index: items in /home/sites/14b/e/e9d9945812/public_html/includes/src/__default.php on line 46112 2021-01-07T10:09:58+00:00 ERR (3): Warning: Invalid argument supplied for foreach() in /home/sites/14b/e/e9d9945812/public_html/includes/src/__default.php on line 46112

Answer 1

等待大神答复