Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Base table or view not found: 1146 Table ‘xxxxx_xxxxx.log_visitor_online’ doesn’t exist” - Individual pages throws error
 
suji
Jr. Member
 
Total Posts:  7
Joined:  2010-11-11
 

Hi Experts,

We have facing recent issues in one of client that everyday or every four hour Individual pages throws error as Base table or view not found: 1146 Table ‘xxxxx_xxxxx.log_visitor_online’ doesn’t exist”.  When we check the database table and try to describe or truncate it tells that the table log_visitor_online doesn’t exist.

We don’t know what to do then we store the data backup and we lost previous customers, products etc.  This is reoccuring issue and this is started after moved Amazon EC2 large instance.  The store has 35000 products right now and it is day by day client is increasing.

We have 100GB storage space and couldn’t find anything.  Can someone help me on this?

Error:

Base table or view not found: 1146 Table ‘xxxxx_xxxxxx.log_visitor_online’ doesn’t exist";i:1;s:4357:"#0 /var/www/html/book
nbuy/lib/Varien/Db/Adapter/Pdo/Mysql.php(277): PDO->query(’TRUNCATE `log_v...’)
#1 /var/www/html/xxxxxx/lib/Varien/Db/Adapter/Pdo/Mysql.php(1351): Varien_Db_A
dapter_Pdo_Mysql->raw_query(’TRUNCATE `log_v...’)
#2 /var/www/html/xxxxxx/app/code/core/Mage/Log/Model/Mysql4/Visitor/Online.php
(59): Varien_Db_Adapter_Pdo_Mysql->truncate(’log_visitor_onl...’)
#3 /var/www/html/xxxxxx/app/code/core/Mage/Log/Model/Visitor/Online.php(66): M
age_Log_Model_Mysql4_Visitor_Online->prepare(Object(Mage_Log_Model_Visitor_Onlin
e))
#4 /var/www/html/xxxxxx/app/design/frontend/default/bookstore/template/catalog
/product/view/type/default.phtml(32): Mage_Log_Model_Visitor_Online->prepare()
#5 /var/www/html/xxxxxx/app/code/core/Mage/Core/Block/Template.php(235): inclu
de(’/var/www/html/b...’)
#6 /var/www/html/xxxxxx/app/code/core/Mage/Core/Block/Template.php(266): Mage_
Core_Block_Template->fetchView(’frontend/defaul...’)
#7 /var/www/html/xxxxxx/app/code/core/Mage/Core/Block/Template.php(280): Mage_
Core_Block_Template->renderView()
#8 /var/www/html/xxxxxx/app/code/core/Mage/Core/Block/Abstract.php(758): Mage_
Core_Block_Template->_toHtml()
#9 /var/www/html/xxxxxx/app/code/core/Mage/Core/Block/Abstract.php(525): Mage_
Core_Block_Abstract->toHtml()

I have followed many threads to create new table but unsuccessful.

regards

Suj

 
Magento Community Magento Community
Magento Community
Magento Community
 
suji
Jr. Member
 
Total Posts:  7
Joined:  2010-11-11
 

Hi Team,

I think we need to optimize or strengthen the database.  Anyone here to help me or team?

Regards

Suj

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top