You cannot define a correlation name 'salesrules' more than once

[InsiderEdsHead]

Hi,

Great extension. I installed the latest version and ran into a conflict with what looks like sweet tooth rewards. Here is the trace:

You cannot define a correlation name 'salesrules' more than once

Trace:

0 -/public_html/includes/src/__default.php(60242): Zend_Db_Select->_join('left join', Array, 'reference_table...', Array, NULL)

1 -/public_html/includes/src/__default.php(58968): Varien_Db_Select->_join('left join', Array, 'reference_table...', Array, NULL)

2 -/public_html/includes/src/TBT_Rewards_Model_Mysql4_Transfer_Collection.php(165): Zend_Db_Select->joinLeft(Array, 'reference_table...', Array)

3 -/public_html/includes/src/TBT_Rewards_Block_Adminhtml_Sales_Order_View_Tab_Points.php(80): TBT_Rewards_Model_Mysql4_Transfer_Collection->addRules()

4 -/public_html/includes/src/BL_CustomGrid_Model_Observer.php(544) : eval()'d code(97): TBT_Rewards_Block_Adminhtml_Sales_Order_View_Tab_Points->_prepareCollection()

5 -/public_html/includes/src/BL_CustomGrid_Model_Observer.php(544) : eval()'d code(378): BL_CustomGrid_Block_Rewrite_Adminhtml_Sales_Order_View_Tab_Points->_prepareCollection()

6 -/public_html/includes/src/BL_CustomGrid_Model_Observer.php(946): BL_CustomGrid_Block_Rewrite_Adminhtml_Sales_Order_View_Tab_Points->blcg_finishPrepareCollection()

7 -/public_html/includes/src/BL_CustomGrid_Model_Observer.php(544) : eval()'d code(94): BL_CustomGrid_Model_Observer->afterGridPrepareCollection(Object(BL_CustomGrid_Block_Rewrite_Adminhtml_Sales_Order_View_Tab_Points))

8 -/public_html/includes/src/Mage_Adminhtml_Block_Widget_Grid.php(626): BL_CustomGrid_Block_Rewrite_Adminhtml_Sales_Order_View_Tab_Points->_prepareCollection()

9 -/public_html/includes/src/Mage_Adminhtml_Block_Widget_Grid.php(632): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()

10 -/public_html/includes/src/__default.php(2540): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()

11 -/public_html/includes/src/Mage_Adminhtml_Block_Widget_Tabs.php(303): Mage_Core_Block_Abstract->toHtml()

12 -/public_html/app/design/adminhtml/default/default/template/widget/tabs.phtml(38): Mage_Adminhtml_Block_Widget_Tabs->getTabContent(Object(BL_CustomGrid_Block_Rewrite_Adminhtml_Sales_Order_View_Tab_Points))

13 -/public_html/includes/src/__default.php(3336): include('-/p...')

14 -/public_html/includes/src/__default.php(3367): Mage_Core_Block_Template->fetchView('adminhtml/defau...')

15 -/public_html/includes/src/__default.php(3381): Mage_Core_Block_Template->renderView()

16 -/public_html/includes/src/Mage_Adminhtml_Block_Template.php(81): Mage_Core_Block_Template->_toHtml()

17 -/public_html/includes/src/__default.php(2541): Mage_Adminhtml_Block_Template->_toHtml()

18 -/public_html/includes/src/__default.php(13451): Mage_Core_Block_Abstract->toHtml()

19 -/public_html/includes/src/__default.php(2541): Mage_Core_Block_Text_List->_toHtml()

20 -/public_html/includes/src/__default.php(2260): Mage_Core_Block_Abstract->toHtml()

21 -/public_html/includes/src/__default.php(2204): Mage_Core_Block_Abstract->_getChildHtml('left', true)

22 -/public_html/app/design/adminhtml/default/default/template/page.phtml(58): Mage_Core_Block_Abstract->getChildHtml('left')

23 -/public_html/includes/src/__default.php(3336): include('-/p...')

24 -/public_html/includes/src/__default.php(3367): Mage_Core_Block_Template->fetchView('adminhtml/defau...')

25 -/public_html/includes/src/__default.php(3381): Mage_Core_Block_Template->renderView()

26 -/public_html/includes/src/Mage_Adminhtml_Block_Template.php(81): Mage_Core_Block_Template->_toHtml()

27 -/public_html/includes/src/__default.php(2541): Mage_Adminhtml_Block_Template->_toHtml()

28 -/public_html/includes/src/__default.php(27704): Mage_Core_Block_Abstract->toHtml()

29 -/public_html/includes/src/__default.php(13844): Mage_Core_Model_Layout->getOutput()

30 -/public_html/app/code/core/Mage/Adminhtml/controllers/Sales/OrderController.php(119): Mage_Core_Controller_Varien_Action->renderLayout()

31 -/public_html/includes/src/__default.php(13872): Mage_Adminhtml_Sales_OrderController->viewAction()

32 -/public_html/includes/src/__default.php(18234): Mage_Core_Controller_Varien_Action->dispatch('view')

33 -/public_html/includes/src/__default.php(17768): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))

34 -/public_html/includes/src/__default.php(20368): Mage_Core_Controller_Varien_Front->dispatch()

35 -/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)

36 -/public_html/index.php(87): Mage::run('', 'store')

37 {main}

[mage-eag]

Hi,

Thanks ! You can check https://support.sweettoothrewards.com/entries/22292751-BL-CustomGrid-Conflict for a solution to your problem.