"SQLSTATE[42S02]: Base table or view not found"

[kclaytonCSP]

I have added this extension to a few other sites with no problem. But when I add it to this site, I am told that there is a missing table.

After I upload the extension and clear the cache, I clicked on a product to make sure that stock movements was there. When I click the product, I get this error.

I'm using Magento ver. 1.9.0.1. Could you please help me?

There has been an error processing your request
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'shopsorg_wzt5koj.bubble_stock_movement' doesn't exist

Trace:

0 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

1 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

2 /home/shopsorg/domains/shophopenetwork.com/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)

3 /home/shopsorg/domains/shophopenetwork.com/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array)

4 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array)

5 /home/shopsorg/domains/shophopenetwork.com/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)

6 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)

7 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()

8 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()

9 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Data/Collection/Db.php(516): Varien_Data_Collection->getCurPage()

10 /home/shopsorg/domains/shophopenetwork.com/lib/Varien/Data/Collection/Db.php(563): Varien_Data_Collection_Db->_renderLimit()

11 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(533): Varien_Data_Collection_Db->load()

12 /home/shopsorg/domains/shophopenetwork.com/app/code/community/Bubble/StockMovements/Block/Adminhtml/Stock/Movement/Grid.php(41): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()

13 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(626): Bubble_StockMovements_Block_Adminhtml_Stock_Movement_Grid->_prepareCollection()

14 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(632): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()

15 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()

16 /home/shopsorg/domains/shophopenetwork.com/app/code/community/Bubble/StockMovements/Model/Stock/Observer.php(19): Mage_Core_Block_Abstract->toHtml()

17 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Model/App.php(1338): Bubble_StockMovements_Model_Stock_Observer->addStockMovementsTab(Object(Varien_Event_Observer))

18 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Bubble_StockMovements_Model_Stock_Observer), 'addStockMovemen...', Object(Varien_Event_Observer))

19 /home/shopsorg/domains/shophopenetwork.com/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)

20 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Controller/Varien/Action.php(385): Mage::dispatchEvent('controller_acti...')

21 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(269): Mage_Core_Controller_Varien_Action->renderLayout()

22 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->editAction()

23 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('edit')

24 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))

25 /home/shopsorg/domains/shophopenetwork.com/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()

26 /home/shopsorg/domains/shophopenetwork.com/app/Mage.php(684): Mage_Core_Model_App->run(Array)

27 /home/shopsorg/domains/shophopenetwork.com/index.php(87): Mage::run('', 'store')

28 {main}

[sergeifilippov]

Sounds like the setup scripts didn't finish running correctly so the table was not created.

Check your core_resource and check for bubble_stockmovements_setup entry. What are the version and data_version listed there?

Both should be 1.2.1.