Product & Price Visibility Rules Error

This area is devoted to Product Questions/Answers. Please ask questions, report bugs and share ideas here.

Product & Price Visibility Rules Error

Postby atbenedict » Mon May 06, 2013 5:24 am

I have just recently started using the Product & Price Visibility Rules extension, and was happy with how it was working for me. Unfortunately, we have migrated the site to a new server, and the extension has stopped working. I did an uninstall using the Itoris installer tool, and even uninstalled the installer....reloaded everything, reset my key, and still have the same error every time I activate the extension. This is repeatable, and occurs when I have activated the extension and then proceed to view my categories in the admin panel:


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

Trace:
#0 /home/deligh15/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/deligh15/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/deligh15/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/deligh15/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select store_id...', Array)
#4 /home/deligh15/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('select store_id...', Array)
#5 /home/deligh15/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('select store_id...', Array)
#6 /home/deligh15/public_html/app/code/local/Itoris/ProductPriceVisibility/Helper/Data.php(89) : eval()'d code(74) : eval()'d code(67) : eval()'d code(262): Zend_Db_Adapter_Abstract->fetchAll('select store_id...')
#7 /home/deligh15/public_html/app/code/local/Itoris/ProductPriceVisibility/Helper/Data.php(89) : eval()'d code(74) : eval()'d code(67) : eval()'d code(234): Itoris_ProductPriceVisibility_Helper_Data->useDefaultForCategory('itoris_productp...', 0, 0)
#8 /home/deligh15/public_html/app/code/local/Itoris/ProductPriceVisibility/Block/Admin/Category/Edit/Tab/VisibilityRules.php(89) : eval()'d code(73) : eval()'d code(63) : eval()'d code(195): Itoris_ProductPriceVisibility_Helper_Data->getGroupIdForCategory('itoris_productp...', 0, 0)
#9 /home/deligh15/public_html/app/code/local/Itoris/ProductPriceVisibility/Block/Admin/Category/Edit/Tab/VisibilityRules.php(89) : eval()'d code(73) : eval()'d code(63) : eval()'d code(51): Itoris_ProductPriceVisibility_Block_Admin_Category_Edit_Tab_VisibilityRules->getGroupId('itoris_productp...', 0, 0)
#10 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Form.php(144): Itoris_ProductPriceVisibility_Block_Admin_Category_Edit_Tab_VisibilityRules->_prepareForm()
#11 /home/deligh15/public_html/app/code/core/Mage/Core/Block/Abstract.php(862): Mage_Adminhtml_Block_Widget_Form->_beforeToHtml()
#12 /home/deligh15/public_html/app/code/local/Itoris/ProductPriceVisibility/Model/Category/Observer.php(36) : eval()'d code(39) : eval()'d code(41) : eval()'d code(37): Mage_Core_Block_Abstract->toHtml()
#13 /home/deligh15/public_html/app/code/core/Mage/Core/Model/App.php(1338): Itoris_ProductPriceVisibility_Model_Category_Observer->addTabCategory(Object(Varien_Event_Observer))
#14 /home/deligh15/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Itoris_ProductPriceVisibility_Model_Category_Observer), 'addTabCategory', Object(Varien_Event_Observer))
#15 /home/deligh15/public_html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('adminhtml_catal...', Array)
#16 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/Block/Catalog/Category/Tabs.php(159): Mage::dispatchEvent('adminhtml_catal...', Array)
#17 /home/deligh15/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Catalog_Category_Tabs->_prepareLayout()
#18 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#19 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/Block/Catalog/Category/Edit/Form.php(55): Mage_Core_Model_Layout->createBlock('adminhtml/catal...', 'tabs')
#20 /home/deligh15/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Catalog_Category_Edit_Form->_prepareLayout()
#21 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#22 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Form/Container.php(82): Mage_Core_Model_Layout->createBlock('adminhtml/catal...')
#23 /home/deligh15/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Widget_Form_Container->_prepareLayout()
#24 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#25 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('adminhtml/catal...', 'category.edit')
#26 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('adminhtml/catal...', 'category.edit')
#27 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#28 /home/deligh15/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#29 /home/deligh15/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#30 /home/deligh15/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#31 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#32 /home/deligh15/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/CategoryController.php(201): Mage_Adminhtml_Controller_Action->loadLayout()
#33 /home/deligh15/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_Catalog_CategoryController->editAction()
#34 /home/deligh15/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('edit')
#35 /home/deligh15/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))
#36 /home/deligh15/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#37 /home/deligh15/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#38 /home/deligh15/public_html/index.php(87): Mage::run('', 'store')
#39 {main}
atbenedict
 
Posts: 1
Joined: Mon May 06, 2013 5:16 am

Re: Product & Price Visibility Rules Error

Postby IToris team » Mon May 06, 2013 7:24 pm

Hi atbenedict,

The error means you moved the files, but not copied the related database tables. Make sure you copied the following DB tables from your previous server:
Code: Select all
itoris_productpricevisibility_category_visibility_group
itoris_productpricevisibility_price_visibility_group
itoris_productpricevisibility_product_visibility_group
itoris_productpricevisibility_settings
itoris_productpricevisibility_settings_text
itoris_productpricevisibility_view


Or you can allow the extension to recreate default DB tables anew. To do that:
1. Using phpMyAdmin open table `core_resource`. Find record "itoris_productpricevisibility_setup". Remove it.
2. Remove the 6 DB tables listed above if you see them in phpMyAdmin
3. Update Magento's cache - System -> Cache Managament. Or if you can't log into your backend remove folder /var/cache on FTP.

Regards,
ITORIS team
IToris team
Site Admin
 
Posts: 1686
Joined: Mon Jan 19, 2009 12:33 pm


Return to Product Questions/Answers

Who is online

Users browsing this forum: No registered users and 1 guest

cron