Unknown column 'catalog_product_entity_group_price.is_percent

[RichardCaldwell]

Just updated to 1.9.3.1 now can't look at any products on the front end or the dashboard in admin getting this error.

a:5:{i:0;s:569:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'catalog_product_entity_group_price.is_percent' in 'field list', query was: SELECT `catalog_product_entity_group_price`.`value_id` AS `price_id`, `catalog_product_entity_group_price`.`website_id`, `catalog_product_entity_group_price`.`all_groups`, `catalog_product_entity_group_price`.`customer_group_id` AS `cust_group`, `catalog_product_entity_group_price`.`value` AS `price`, `catalog_product_entity_group_price`.`is_percent` FROM `catalog_product_entity_group_price` WHERE

Editet: Removed last part of error since this first part is the main reason.

[ptomter · Accepted solution]

Hi @RichardCaldwellThe issue is caused by a missing column named: is_percent in the table catalog_product_entity_group_price

Magento 1.9.3 includes an upgrade file that creates that column in the database. The file is located here: app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.19.1.4-1.6.0.0.19.1.5.php

When the cache is enabled the installer can’t run the upgrade script, causing the error reported by the OP. Another possible cause of a failed upgrade script is if you refresh the frontend or backend before all files have been uploaded via FTP.

If flushing the cache doesn’t solve the problem (be sure to refresh any external cache like Redis) you can try the following:

1. Open the core_resource table
2. Locate the catalog_setup row
3. If the current value for version and data_versions is: 1.6.0.0.19.1.5 then change both values to 1.6.0.0.19.1.2 and refresh any page of the frontend.

This will force Magento to rerun the upgrade script and create the missing column in the database.  If the value for version and data_version is 1.6.0.0.19.1.2 then you are not properly flushing the cache.

[RichardCaldwell]

Thank You that did fix the front end but not the admin dashboard Now I got this missing one.

Fixed below had to rerun the sales_setup

Thank you for the help

a:5:{i:0;s:698:"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sales_bestsellers_aggregated_yearly.product_type_id' in 'field list', query was: SELECT COUNT(*) FROM (SELECT MAX(DATE_FORMAT(period, '%Y-%m-%d')) AS `period`, SUM(qty_ordered) AS `qty_ordered`, `sales_bestsellers_aggregated_yearly`.`product_id`, MAX(product_name) AS `product_name`, MAX(product_price) AS `product_price`, `sales_bestsellers_aggregated_yearly`.`product_type_id` FROM `sales_bestsellers_aggregated_yearly` WHERE (EXISTS (SELECT 1 FROM `catalog_product_entity` AS `existed_products` WHERE (sales_bestsellers_aggregated_yearly.product_id = existed_products.entity_id))) AND (store_id IN(0)) GROUP BY `product_id` LIMIT 5) AS `t`";i:1;s:5692:"#0 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /homepages/42/d472594583/htdocs/dieselcranks/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /homepages/42/d472594583/htdocs/dieselcranks/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(*)...', Array)
#4 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(*)...', Array)
#5 /homepages/42/d472594583/htdocs/dieselcranks/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Data/Collection/Db.php(522): Varien_Data_Collection->getCurPage()
#10 /homepages/42/d472594583/htdocs/dieselcranks/lib/Varien/Data/Collection/Db.php(569): Varien_Data_Collection_Db->_renderLimit()
#11 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Reports/Model/Resource/Report/Collection/Abstract.php(285): Varien_Data_Collection_Db->load(false, false)
#12 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(550): Mage_Reports_Model_Resource_Report_Collection_Abstract->load()
#13 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Dashboard/Tab/Products/Ordered.php(66): Mage_Adminhtml_Block_Widget_Grid->_prepareCollection()
#14 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(643): Mage_Adminhtml_Block_Dashboard_Tab_Products_Ordered->_prepareCollection()
#15 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Widget/Grid.php(649): Mage_Adminhtml_Block_Widget_Grid->_prepareGrid()
#16 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Block/Abstract.php(922): Mage_Adminhtml_Block_Widget_Grid->_beforeToHtml()
#17 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Dashboard/Grids.php(64): Mage_Core_Block_Abstract->toHtml()
#18 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Block/Abstract.php(297): Mage_Adminhtml_Block_Dashboard_Grids->_prepareLayout()
#19 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#20 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Block/Dashboard.php(75): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...')
#21 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Block/Abstract.php(297): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
#22 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#23 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...', 'dashboard')
#24 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('adminhtml/dashb...', 'dashboard')
#25 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#26 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#27 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#28 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#29 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#30 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
#31 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_DashboardController->indexAction()
#32 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#33 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#34 /homepages/42/d472594583/htdocs/dieselcranks/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#35 /homepages/42/d472594583/htdocs/dieselcranks/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#36 /homepages/42/d472594583/htdocs/dieselcranks/index.php(83): Mage::run('', 'store')
#37 {main}";s:3:"url";s:43:"/index.php/Diesel$engine1backend/dashboard/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:5:"admin";}

[ptomter]

Please see my post in the security patches section of the forum and about supee-8788 and different solutions...

[TLGX]

I'm having this same problem and have been unable to fix. Can you please give me details what you meant when you said you had to "rerun sales_setup"?  Site is currently tanked so any quick help is appreciated! Thank you!

[RichardCaldwell]

I followed the same example above for the “catalog_setup”

Only I made the change to “sales_setup”