Error after System-Copy

[W1zzard]

Hi,

I just copied a whole magento 1.7.0.2 system to a new hoster.

I get this first error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'usr_p271648_1.log_visitor_info' doesn't exist

Trace:
#0 /html/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /html/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /html/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('DESCRIBE `log_v...', Array)
#4 /html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('DESCRIBE `log_v...', Array)
...

How I get this table back?

Greetz & Thanks.

[W1zzard]

noone?

[aahermosa]

I have the same error message, but in my case I couldn't even start yet

QLSTATE[42S02]: Base table or view not found: 1146 Table 'solemake.index_process' doesn't exist, query was: SELECT `index_process`.`indexer_code` FROM `index_process`

Trace:
#0 /home/papermake/public_html/www.solemake.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/papermake/public_html/www.solemake.com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/papermake/public_html/www.solemake.com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/papermake/public_html/www.solemake.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `index_p...', Array)
#4 /home/papermake/public_html/www.solemake.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `index_p...', Array)
#5 /home/papermake/public_html/www.solemake.com/lib/Zend/Db/Adapter/Abstract.php(794): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/papermake/public_html/www.solemake.com/app/code/core/Mage/Index/Model/Resource/Setup.php(66): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#7 /home/papermake/public_html/www.solemake.com/app/code/core/Mage/Index/Model/Resource/Setup.php(45): Mage_Index_Model_Resource_Setup->_syncIndexes()
#8 /home/papermake/public_html/www.solemake.com/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Index_Model_Resource_Setup->applyUpdates()
#9 /home/papermake/public_html/www.solemake.com/app/code/core/Mage/Core/Model/App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#10 /home/papermake/public_html/www.solemake.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Model_App->_initModules()
#11 /home/papermake/public_html/www.solemake.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#12 /home/papermake/public_html/www.solemake.com/index.php(83): Mage::run('', 'store')
#13 {main}

[MrDjBinary]

Hello

I am having the EXACT error!

Did you fix this?

Could you PLEASE share the solution?

Thanks

[friendoflore]

This worked for me:

CREATE TABLE `log_visitor_info` (
`visitor_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Visitor ID',
`http_referer` varchar(255) DEFAULT NULL COMMENT 'HTTP Referrer',
`http_user_agent` varchar(255) DEFAULT NULL COMMENT 'HTTP User-Agent',
`http_accept_charset` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Charset',
`http_accept_language` varchar(255) DEFAULT NULL COMMENT 'HTTP Accept-Language',
`server_addr` bigint(20) DEFAULT NULL COMMENT 'Server Address',
`remote_addr` bigint(20) DEFAULT NULL COMMENT 'Remote Address',
PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log Visitor Info Table';

It looks like the back-ticks will copy correctly from here, but in case there is any trouble you can copy from here: http://pastebin.com/jYCS2aGZ#sthash.DJqq4ZY3.dpuf

Source:

http://www.discuzfeed.com/magento/rooer-i-moved-magento-folders-from-ftp-when-i-open-store-on-my-wam...

[benoitbour7a84]

That's don't works for me Someone else ? I have this problem since 2 week...