Magento - Can't add products - General Forum - eCommerce Software for Growth, Powered by Open Source

Skip to site navigation »
Skip to main content »
Skip to footer content »

Sales: Call 877.832.5289 (N America)|310.295.4144 (International)

Magento Forum

Can’t add products

dwdonline Total Posts: 28 Joined: 2008-03-06 Knoxville, TN Ignore user	I get this error when I try to add a product after entering in all the info and clicking Save. I am running 1.0 on a Plesk Centos server. PHP 5.2.5 and MySQL 5 also. `SQLSTATE[HY093]: Invalid parameter number: no parameters were bound`
	Posted: April 1 2008 \| top

dwdonline Total Posts: 28 Joined: 2008-03-06 Knoxville, TN Ignore user	I figured out what makes it give the error. I set up a number of attributes with text areas. If it goes over a certain number of letters in one of the boxes it gives an error. What can I do to fix this? Thanks, Philip
	Posted: April 1 2008 \| top \| # 1

finch8243 Total Posts: 51 Joined: 2007-08-31 Ignore user	I’m getting the same issue. I’m unable to add products or edit existing ones. Any help? SQLSTATE[HY093]: Invalid parameter number: no parameters were bound Trace: #0 /home/dparcs/public_html/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/dparcs/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array) #2 /home/dparcs/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array) #3 /home/dparcs/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array) #4 /home/dparcs/public_html/magento/app/code/core/Mage/Core/Model/Mysql4/Translate.php(100): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select)) #5 /home/dparcs/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Eav/Attribute.php(114): Mage_Core_Model_Mysql4_Translate->getTranslationArrayByStrings(Array, '0') #6 /home/dparcs/public_html/magento/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(68): Mage_Catalog_Model_Resource_Eav_Attribute::initLabels('0') #7 /home/dparcs/public_html/magento/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(148): Mage_Adminhtml_Catalog_ProductController->_initProduct() #8 /home/dparcs/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Adminhtml_Catalog_ProductController->editAction() #9 /home/dparcs/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(148): Mage_Core_Controller_Varien_Action->dispatch('edit') #10 /home/dparcs/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http)) #11 /home/dparcs/public_html/magento/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch() #12 /home/dparcs/public_html/magento/index.php(40): Mage::run() #13 {main}
	Posted: June 16 2008 \| top \| # 2

Magento Community

Magento Community

Back to top

1.0 installed and working for anyone?

Sales: Call 877.832.5289 (North America) 310.295.4144 (International)

© Copyright 2008 Varien. Magento, eCommerce software, is a trademark of Irubin Consulting Inc. DBA Varien
Privacy Policy|Terms of Service Magento Community Count
52316 users|488 users currently online|105643 forum posts