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

Invalid bind-variable position ‘:tr_strings’
 
Anjanesh
Sr. Member
 
Avatar
Total Posts:  136
Joined:  2008-03-15
Mumbai, India
 

I uploaded Magento 1.1.6 on a Linux shared hosting server with mysqli.

For some of the catalog product pages, Im getting this :

There has been an error processing your request.

Invalid bind-variable position ':tr_strings'
Trace:
#0 /home/username/domains/mywebsite.com/public_html/magento/lib/Zend/Db/Statement.php(108): Zend_Db_Statement->_parseParameters('SELECT `be_core...')
#1 /home/username/domains/mywebsite.com/public_html/magento/lib/Zend/Db/Adapter/Mysqli.php(330): Zend_Db_Statement->__construct(Object(Varien_Db_Adapter_Mysqli), 'SELECT `be_core...')
#2 /home/username/domains/mywebsite.com/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(405): Zend_Db_Adapter_Mysqli->prepare('SELECT `be_core...')
#3 /home/username/domains/mywebsite.com/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Translate.php(105): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#5 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Attribute.php(120): Mage_Core_Model_Mysql4_Translate->getTranslationArrayByStrings(Array, 1)
#6 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Attribute.php(102): Mage_Catalog_Model_Resource_Eav_Attribute::initLabels()
#7 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Attribute.php(93): Mage_Catalog_Model_Resource_Eav_Attribute->_getLabelForStore()
#8 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Eav/Model/Entity/Attribute/Frontend/Abstract.php(84): Mage_Catalog_Model_Resource_Eav_Attribute->getFrontendLabel()
#9 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Catalog/Block/Product/View/Attributes.php(65): Mage_Eav_Model_Entity_Attribute_Frontend_Abstract->getLabel()
#10 /home/username/domains/mywebsite.com/public_html/magento/app/design/frontend/electric1/default/template/catalog/product/view/attributes.phtml(33): Mage_Catalog_Block_Product_View_Attributes->getAdditionalData()
#11 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(144): include('/home/username/...')
#12 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('frontend/electr...')
#13 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#14 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#15 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#16 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml('additional', true)
#17 /home/username/domains/mywebsite.com/public_html/magento/app/design/frontend/electric1/default/template/catalog/product/view.phtml(117): Mage_Core_Block_Abstract->getChildHtml('additional')
#18 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(144): include('/home/username/...')
#19 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('frontend/electr...')
#20 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#21 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#22 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#23 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Text_List->_toHtml()
#24 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(503): Mage_Core_Block_Abstract->toHtml()
#25 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(454): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#26 /home/username/domains/mywebsite.com/public_html/magento/app/design/frontend/electric1/default/template/page/2columns-left.phtml(60): Mage_Core_Block_Abstract->getChildHtml('content')
#27 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(144): include('/home/username/...')
#28 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(176): Mage_Core_Block_Template->fetchView('frontend/electr...')
#29 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Template.php(193): Mage_Core_Block_Template->renderView()
#30 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Block/Abstract.php(643): Mage_Core_Block_Template->_toHtml()
#31 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Model/Layout.php(515): Mage_Core_Block_Abstract->toHtml()
#32 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(326): Mage_Core_Model_Layout->getOutput()
#33 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Catalog/controllers/ProductController.php(129): Mage_Core_Controller_Varien_Action->renderLayout()
#34 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(349): Mage_Catalog_ProductController->viewAction()
#35 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(163): Mage_Core_Controller_Varien_Action->dispatch('view')
#36 /home/username/domains/mywebsite.com/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(174): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#37 /home/username/domains/mywebsite.com/public_html/magento/app/Mage.php(447): Mage_Core_Controller_Varien_Front->dispatch()
#38 /home/username/domains/mywebsite.com/public_html/magento/index.php(52): Mage::run()
#39 {main}
Im getting this only for those products where there is only one image. (No More Views)

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
nasha
Sr. Member
 
Avatar
Total Posts:  138
Joined:  2009-04-15
 

Hi
Same problem here.did you find any solution.
i found this thread but did,t understand
http://www.magentocommerce.com/boards/text/javascript/viewthread/10029/

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