cancel
Showing results for 
Search instead for 
Did you mean: 

Unknown column 'catalog_product_entity_group_price.is_percent

SOLVED

Unknown column 'catalog_product_entity_group_price.is_percent

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Unknown column 'catalog_product_entity_group_price.is_percent

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.

View solution in original post

5 REPLIES 5

Re: Unknown column 'catalog_product_entity_group_price.is_percent

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.

Re: Unknown column 'catalog_product_entity_group_price.is_percent

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";}

Re: Unknown column 'catalog_product_entity_group_price.is_percent

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

Re: Unknown column 'catalog_product_entity_group_price.is_percent

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!

Re: Unknown column 'catalog_product_entity_group_price.is_percent

I followed the same example above for the “catalog_setup”

Only I made the change to “sales_setup”