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

Error when adding a design
 
dwdonline
Member
 
Avatar
Total Posts:  56
Joined:  2008-03-06
Southern California
 

I installed and had no errors, but as soon as I went to System > Design in the admin, and added a design it give me errors now:

exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘design’ in ‘where clause’’ in /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Zend/Db/Statement/Pdo.php:238
Stack trace:
#0 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(’select count(*)...’, Array)
#3 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Zend/Db/Adapter/Abstract.php(711): Zend_Db_Adapter_Pdo_Abstract->query(’select count(*)...’, Array)
#4 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Varien/Data/Collection/Db.php(112): Zend_Db_Adapter_Abstract->fetchOne(’select count(*)...’)
#5 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Varien/Data/Collection.php(168): Varien_Data_Collection_Db->getSize()
#6 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Varien/Data/Collection.php(154): Varien_Data_Collection->getLastPageNumber()
#7 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Varien/Data/Collection/Db.php(358): Varien_Data_Collection->getCurPage()
#8 /var/www/vhosts/martens-health.com/httpdocs/magento/lib/Varien/Data/Collection/Db.php(388): Varien_Data_Collection_Db->_renderLimit()
#9 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Model/Mysql4/Collection/Abstract.php(181): Varien_Data_Collection_Db->load(false, false)
#10 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(353): Mage_Core_Model_Mysql4_Collection_Abstract->load()
#11 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Adminhtml/Block/System/Design/Grid.php(39): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#12 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(427): Mage_Adminhtml_Block_System_Design_Grid->_prepareCollection()
#13 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(433): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#14 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(548): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#15 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(435): Mage_Core_Block_Abstract->toHtml()
#16 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(412): Mage_Core_Block_Abstract->_getChildHtml(’grid’, true)
#17 /var/www/vhosts/martens-health.com/httpdocs/magento/app/design/adminhtml/default/default/template/system/design/index.phtml(32): Mage_Core_Block_Abstract->getChildHtml(’grid’)
#18 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(112): include(’/var/www/vhosts...’)
#19 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(144): Mage_Core_Block_Template->fetchView(’adminhtml/defau...’)
#20 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(183): Mage_Core_Block_Template->renderView()
#21 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Template->_toHtml()
#22 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Text/List.php(36): Mage_Core_Block_Abstract->toHtml()
#23 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Text_List->_toHtml()
#24 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(435): Mage_Core_Block_Abstract->toHtml()
#25 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(412): Mage_Core_Block_Abstract->_getChildHtml(’content’, true)
#26 /var/www/vhosts/martens-health.com/httpdocs/magento/app/design/adminhtml/default/default/template/page.phtml(132): Mage_Core_Block_Abstract->getChildHtml(’content’)
#27 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(112): include(’/var/www/vhosts...’)
#28 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(144): Mage_Core_Block_Template->fetchView(’adminhtml/defau...’)
#29 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Template.php(183): Mage_Core_Block_Template->renderView()
#30 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Block/Abstract.php(549): Mage_Core_Block_Template->_toHtml()
#31 /var/www/vhosts/martens-health.com/httpdocs/magento/app/code/core/Mage/Core/Model/Layout.php(437): Mage_Core_Block_Abstract->toHtml()

Any help would be appreciated.

Plesk 8.3.0, php 5.2, mysql 5, centos 5.

Thanks,
Philip

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