Magento Forum

Some errors while trying to view a “configurable product” via backend: 
 
Brett
Sr. Member
 
Total Posts:  121
Joined:  2007-12-01
 

Notice: Undefined variable: conditionSql in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php on line 327
[0] in Mage_Eav_Model_Entity_Collection_Abstract->addAttributeToFilter(525, Array[1]) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config/Grid.php on line 78
[1] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config_Grid->_prepareCollection() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php on line 358
[2] in Mage_Adminhtml_Block_Widget_Grid->_prepareGrid() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php on line 364
[3] in Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 180
[4] in Mage_Core_Block_Template->toHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 439
[5] in Mage_Core_Block_Abstract->_getChildHtml("grid", 1) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 417
[6] in Mage_Core_Block_Abstract->getChildHtml("grid") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config.php on line 65
[7] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config->getGridHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/design/adminhtml/default/default/template/catalog/product/edit/super/config.phtml on line 59
[8] in include("/var/www/vhosts/brettmorgan.com/httpdocs/shop/app/design/adminhtml/default/default/template/catalog/") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 116
[9] in Mage_Core_Block_Template->fetchView("adminhtml/default/default/template/catalog/product/edit/super/config.phtml") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 143
[10] in Mage_Core_Block_Template->renderView() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 188
[11] in Mage_Core_Block_Template->toHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tabs.php on line 136
[12] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tabs->_prepareLayout() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 185
[13] in Mage_Core_Block_Abstract->setLayout(Mage_Core_Model_Layout) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Model/Layout.php on line 325
[14] in Mage_Core_Model_Layout->createBlock("adminhtml/catalog_product_edit_tabs", “product_tabs") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php on line 90
[15] in Mage_Adminhtml_Catalog_ProductController->editAction() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Action.php on line 325
[16] in Mage_Core_Controller_Varien_Action->dispatch("edit") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php on line 133
[17] in Mage_Core_Controller_Varien_Router_Admin->match(Zend_Controller_Request_Http) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Front.php on line 166
[18] in Mage_Core_Controller_Varien_Front->dispatch() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/Mage.php on line 380
[19] in Mage::run("base") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/index.php on line 28

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brett
Sr. Member
 
Total Posts:  121
Joined:  2007-12-01
 

Notice: Undefined variable: conditionSql in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php on line 327
[0] in Mage_Eav_Model_Entity_Collection_Abstract->addAttributeToFilter(272, Array[1]) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config/Grid.php on line 78
[1] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config_Grid->_prepareCollection() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php on line 358
[2] in Mage_Adminhtml_Block_Widget_Grid->_prepareGrid() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php on line 364
[3] in Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 180
[4] in Mage_Core_Block_Template->toHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 439
[5] in Mage_Core_Block_Abstract->_getChildHtml("grid", 1) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 417
[6] in Mage_Core_Block_Abstract->getChildHtml("grid") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config.php on line 65
[7] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config->getGridHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/design/adminhtml/default/default/template/catalog/product/edit/super/config.phtml on line 59
[8] in include("/var/www/vhosts/brettmorgan.com/httpdocs/shop/app/design/adminhtml/default/default/template/catalog/") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 116
[9] in Mage_Core_Block_Template->fetchView("adminhtml/default/default/template/catalog/product/edit/super/config.phtml") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 143
[10] in Mage_Core_Block_Template->renderView() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php on line 188
[11] in Mage_Core_Block_Template->toHtml() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tabs.php on line 136
[12] in Mage_Adminhtml_Block_Catalog_Product_Edit_Tabs->_prepareLayout() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php on line 185
[13] in Mage_Core_Block_Abstract->setLayout(Mage_Core_Model_Layout) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Model/Layout.php on line 325
[14] in Mage_Core_Model_Layout->createBlock("adminhtml/catalog_product_edit_tabs", “product_tabs") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php on line 90
[15] in Mage_Adminhtml_Catalog_ProductController->editAction() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Action.php on line 325
[16] in Mage_Core_Controller_Varien_Action->dispatch("edit") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php on line 133
[17] in Mage_Core_Controller_Varien_Router_Admin->match(Zend_Controller_Request_Http) in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Front.php on line 166
[18] in Mage_Core_Controller_Varien_Front->dispatch() in /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/Mage.php on line 380
[19] in Mage::run("base") in /var/www/vhosts/brettmorgan.com/httpdocs/shop/index.php on line 28

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brett
Sr. Member
 
Total Posts:  121
Joined:  2007-12-01
 

exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)
AND ()
AND (e.entity_id in (38, 127, 128, 129, 130, 131))’ at line 6’ in /var/www/vhosts/brettmorgan.com/httpdocs/shop/lib/Zend/Db/Statement/Mysqli.php:85
Stack trace:
#0 /var/www/vhosts/brettmorgan.com/httpdocs/shop/lib/Zend/Db/Statement.php(109): Zend_Db_Statement_Mysqli->_prepare(’select count(DI...’)
#1 /var/www/vhosts/brettmorgan.com/httpdocs/shop/lib/Zend/Db/Adapter/Mysqli.php(330): Zend_Db_Statement->__construct(Object(Varien_Db_Adapter_Mysqli), ‘select count(DI...’)
#2 /var/www/vhosts/brettmorgan.com/httpdocs/shop/lib/Zend/Db/Adapter/Abstract.php(395): Zend_Db_Adapter_Mysqli->prepare(’select count(DI...’)
#3 /var/www/vhosts/brettmorgan.com/httpdocs/shop/lib/Zend/Db/Adapter/Abstract.php(677): Zend_Db_Adapter_Abstract->query(’select count(DI...’, Array)
#4 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1269): Zend_Db_Adapter_Abstract->fetchOne(’select count(DI...’)
#5 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1208): Mage_Eav_Model_Entity_Collection_Abstract->getSize()
#6 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1231): Mage_Eav_Model_Entity_Collection_Abstract->getLastPageNumber()
#7 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(891): Mage_Eav_Model_Entity_Collection_Abstract->_getPageStart()
#8 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(768): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(337): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config/Grid.php(85): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#11 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(358): Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config_Grid->_prepareCollection()
#12 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(364): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#13 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php(180): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#14 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php(439): Mage_Core_Block_Template->toHtml()
#15 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php(417): Mage_Core_Block_Abstract->_getChildHtml(’grid’, true)
#16 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Super/Config.php(65): Mage_Core_Block_Abstract->getChildHtml(’grid’)
#17 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/design/adminhtml/default/default/template/catalog/product/edit/super/config.phtml(59): Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Super_Config->getGridHtml()
#18 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php(116): include(’/var/www/vhosts...’)
#19 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php(143): Mage_Core_Block_Template->fetchView(’adminhtml/defau...’)
#20 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Template.php(188): Mage_Core_Block_Template->renderView()
#21 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tabs.php(136): Mage_Core_Block_Template->toHtml()
#22 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Block/Abstract.php(185): Mage_Adminhtml_Block_Catalog_Product_Edit_Tabs->_prepareLayout()
#23 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Model/Layout.php(325): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#24 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(90): Mage_Core_Model_Layout->createBlock(’adminhtml/catal...’, ‘product_tabs’)
#25 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Action.php(325): Mage_Adminhtml_Catalog_ProductController->editAction()
#26 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(133): Mage_Core_Controller_Varien_Action->dispatch(’edit’)
#27 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/code/core/Mage/Core/Controller/Varien/Front.php(166): Mage_Core_Controller_Varien_Router_Admin->match(Object(Zend_Controller_Request_Http))
#28 /var/www/vhosts/brettmorgan.com/httpdocs/shop/app/Mage.php(380): Mage_Core_Controller_Varien_Front->dispatch()
#29 /var/www/vhosts/brettmorgan.com/httpdocs/shop/index.php(28): Mage::run(’base’)
#30 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
enrico
Jr. Member
 
Total Posts:  5
Joined:  2007-10-03
 

Hi.
It’s the same error that I’ve reported 4 days ago.
I hope that someone will find a solution.
Bye

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brett
Sr. Member
 
Total Posts:  121
Joined:  2007-12-01
 

It’s probably to do with the new version of php. It looks very similar to those errors i encountered upon installing and fixed by replacing the file.php file with one that someone so helpfully included.

Anyways, the cart looks great! I liken it to a popular computer site (not sure if i should advertise it here). If any of you use it, you know what i mean smile

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

Could you try patch in this thread:
http://www.magentocommerce.com/boards/viewthread/1566/

 
Magento Community Magento Community
Magento Community
Magento Community
 
enrico
Jr. Member
 
Total Posts:  5
Joined:  2007-10-03
 
Moshe - 04 December 2007 09:15 AM

Could you try patch in this thread:
http://www.magentocommerce.com/boards/viewthread/1566/

Thank you Moshe!
Now it’s ok.

Can you help me for this question also?
http://www.magentocommerce.com/boards/viewthread/1809/

bye

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