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

1.6.2 to 1.7.0 Didn’t go well
 
Mike K.
Jr. Member
 
Total Posts:  5
Joined:  2008-04-05
 

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.min_price’ in ‘field list’

The error appears on all product pages… home page is fine.  Admin section was missing all navigation.

Cleaning cache and re-indexing makes no difference.  Upgrade was made through Magento Connect.

Turning off all extensions made no difference - same error.

There is no table named “e”, which the error seems to be looking for.  The logs and that error were a little cryptic to me as to how to fix this.  Has anyone run into this before?  Whats the cure?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Cameron_iWeb
Member
 
Avatar
Total Posts:  62
Joined:  2012-03-22
 

It may appear that a file is missing from the upgrade package as you mention that the navigation was missing from the admin.

Can you post more details on the log files output?

Have you tried, restoring your back up and running again to rule out corrupt upgrade package?
May have to upgrade manually failing that to find the problem.

Thanks

Cameron

 
Magento Community Magento Community
Magento Community
Magento Community
 
gjr
Jr. Member
 
Total Posts:  20
Joined:  2008-08-11
Tilburg, The Netherlands
 

We are getting a similar error.

[test123@server2 magento]$ php shell/indexer.php --reindex catalog_product_price
Product Prices index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test123_magento.catalog_product_index_group_price’ doesn’t exist’ in /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’DELETE FROM `ca...’, Array)
#5 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’DELETE FROM `ca...’, Array)
#6 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(661): Varien_Db_Adapter_Pdo_Mysql->query(’DELETE FROM `ca...’)
#7 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(470): Zend_Db_Adapter_Abstract->delete(’catalog_product...’)
#8 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(380): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prepareGroupPriceIndex()
#9 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#10 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#11 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#12 /home/test123/domains/test.gj-r.nl/public_html/magento/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /home/test123/domains/test.gj-r.nl/public_html/magento/shell/indexer.php(198): Mage_Shell_Compiler->run()
#14 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘test123_magento.catalog_product_index_group_price’ doesn’t exist’ in /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’DELETE FROM `ca...’, Array)
#4 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’DELETE FROM `ca...’, Array)
#5 /home/test123/domains/test.gj-r.nl/public_html/magento/lib/Zend/Db/Adapter/Abstract.php(661): Varien_Db_Adapter_Pdo_Mysql->query(’DELETE FROM `ca...’)
#6 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(470): Zend_Db_Adapter_Abstract->delete(’catalog_product...’)
#7 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price.php(380): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prepareGroupPriceIndex()
#8 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/test123/domains/test.gj-r.nl/public_html/magento/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/test123/domains/test.gj-r.nl/public_html/magento/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /home/test123/domains/test.gj-r.nl/public_html/magento/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

According to http://www.magereverse.com/diff-version/magento-database-structure-comparison/version/1.7.0.0.beta said table is a new table introduced in 1.7.0. We also sometimes get errors regarding the table captcha_log, which is also a new table. This leads me to believe the database structure wasn’t upgraded.

We upgraded from a vanilla/unaltered 1.6.2.0 to 1.7.0.0 using SSH. Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mike K.
Jr. Member
 
Total Posts:  5
Joined:  2008-04-05
 

I am getting a similar error as glr during install, as well as the SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.min_price’ in ‘field list’ on all product pages.

I tried installing using the “connect20.magentocommerce.com/community/Mage_All_Latest” in the “Install New Extensions / Paste extension key to install” But that command brought up 1.6.2 files as the latest.

I edited downloader\lib\Mage\Connect\Validator.php and removed

if (file_exists($dest)) {
$this->addError(“‘{$file}’ already exists");
return false;
}

So the files would over-write - and I got it all to install.  I am still getting the unknown column error on product pages even after multiple manual cache removals and multiple re-indexes.

Here is the lates install log - Im not sure but it seems like its repeating a few things.

Checking dependencies of packages
Starting to download Lib_Js_Calendar-1.51.1.1.tgz ...
...done: 25,133 bytes
Installing package community/Lib_Js_Calendar 1.51.1.1
Package community/Lib_Js_Calendar 1.51.1.1 installed successfully
Package upgraded:
community Lib_Js_Calendar 1.51.1.1

Cleaning cache
Checking dependencies of packages
Starting to download Lib_Js_Ext-1.7.0.0.tgz ...
...done: 266,352 bytes
.Installing package community/Lib_Js_Ext 1.7.0.0
.Package community/Lib_Js_Ext 1.7.0.0 installed successfully
Package upgraded:
community Lib_Js_Ext 1.7.0.0

Cleaning cache
Checking dependencies of packages

CONNECT ERROR: Package community/Lib_Js_TinyMCE 3.4.7.0 conflicts with: community/Mage_Core_Adminhtml 1.6.2.0
Checking dependencies of packages
Starting to download Lib_LinLibertineFont-2.8.14.1.tgz ...
......done: 2,215,420 bytes
.Installing package community/Lib_LinLibertineFont 2.8.14.1
Package community/Lib_LinLibertineFont 2.8.14.1 installed successfully
.Package upgraded:
community Lib_LinLibertineFont 2.8.14.1

Cleaning cache
Checking dependencies of packages
....Starting to download Lib_Varien-1.7.0.0.tgz ...
...done: 152,955 bytes
...Installing package community/Lib_Varien 1.7.0.0
Package community/Lib_Varien 1.7.0.0 installed successfully
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping
Package upgraded:
community Lib_Varien 1.7.0.0

Cleaning cache
Checking dependencies of packages
...Starting to download Lib_Js_Mage-1.7.0.0.tgz ...
....done: 122,755 bytes
..Installing package community/Lib_Js_Mage 1.7.0.0
.Package community/Lib_Js_Mage 1.7.0.0 installed successfully
Starting to download Lib_Js_Prototype-1.7.0.0.3.tgz ...
.....done: 232,816 bytes
..Installing package community/Lib_Js_Prototype 1.7.0.0.3
Package community/Lib_Js_Prototype 1.7.0.0.3 installed successfully
.Package upgraded:
community Lib_Js_Mage 1.7.0.0
community Lib_Js_Prototype 1.7.0.0.3
. Checking dependencies of packages
.Starting to download Lib_Mage-1.7.0.0.tgz ...
....done: 74,161 bytes
Installing package community/Lib_Mage 1.7.0.0
.Package community/Lib_Mage 1.7.0.0 installed successfully
...Package upgraded:
community Lib_Mage 1.7.0.0

Cleaning cache
Checking dependencies of packages
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping

Cleaning cache
Checking dependencies of packages
.........................Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Starting to download Mage_Locale_en_US-1.7.0.0.tgz ...
.......done: 95,147 bytes
.Installing package community/Mage_Locale_en_US 1.7.0.0
.Package community/Mage_Locale_en_US 1.7.0.0 installed successfully
.Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping
Package upgraded:
community Mage_Locale_en_US 1.7.0.0

CONNECT ERROR: ..Package community/Interface_Install_Default 1.7.0.0 conflicts with: community/Mage_All_Latest 1.6.2.0
Package community/Mage_Core_Modules 1.7.0.0 conflicts with: community/Mage_All_Latest 1.6.2.0
Checking dependencies of packages
.........................Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping
.
CONNECT ERROR: Package community/Mage_Centinel 1.7.0.0 conflicts with: community/Mage_All_Latest 1.6.2.0
Package community/Mage_Core_Modules 1.7.0.0 conflicts with: community/Mage_All_Latest 1.6.2.0
Checking dependencies of packages
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping

Cleaning cache
Checking dependencies of packages
..............................................................Starting to download Mage_All_Latest-1.7.0.0.tgz ...
...done: 911 bytes
..Installing package community/Mage_All_Latest 1.7.0.0
Package community/Mage_All_Latest 1.7.0.0 installed successfully
.Starting to download Interface_Adminhtml_Default-1.7.0.0.tgz ...
..........done: 1,123,100 bytes
.......Installing package community/Interface_Adminhtml_Default 1.7.0.0
.............Package community/Interface_Adminhtml_Default 1.7.0.0 installed successfully
.Starting to download Interface_Frontend_Default-1.7.0.0.tgz ...
.........done: 747,663 bytes
.Installing package community/Interface_Frontend_Default 1.7.0.0
...Package community/Interface_Frontend_Default 1.7.0.0 installed successfully
.Starting to download Interface_Install_Default-1.7.0.0.tgz ...
......done: 108,277 bytes
..Installing package community/Interface_Install_Default 1.7.0.0
Package community/Interface_Install_Default 1.7.0.0 installed successfully
..Starting to download Mage_Downloader-1.7.0.0.tgz ...
......done: 280,417 bytes
...Installing package community/Mage_Downloader 1.7.0.0
.Package community/Mage_Downloader 1.7.0.0 installed successfully
..Starting to download Mage_Centinel-1.7.0.0.tgz ...
......done: 36,732 bytes
.Installing package community/Mage_Centinel 1.7.0.0
.Package community/Mage_Centinel 1.7.0.0 installed successfully
..Starting to download Interface_Frontend_Base_Default-1.7.0.0.tgz ...
.......done: 393,090 bytes
......Installing package community/Interface_Frontend_Base_Default 1.7.0.0
.........Package community/Interface_Frontend_Base_Default 1.7.0.0 installed successfully
Starting to download Phoenix_Moneybookers-1.3.1.tgz ...
........done: 364,377 bytes
..Installing package community/Phoenix_Moneybookers 1.3.1
..Package community/Phoenix_Moneybookers 1.3.1 installed successfully
.Starting to download Mage_Compiler-1.7.0.0.tgz ...
.....done: 10,263 bytes
.Installing package community/Mage_Compiler 1.7.0.0
.Package community/Mage_Compiler 1.7.0.0 installed successfully
Starting to download Magento_Mobile-1.7.0.0.22.1.tgz ...
............done: 2,035,082 bytes
.....Installing package community/Magento_Mobile 1.7.0.0.22.1
.........Package community/Magento_Mobile 1.7.0.0.22.1 installed successfully
...Starting to download Mage_Core_Adminhtml-1.7.0.0.tgz ...
.......done: 521,885 bytes
............Installing package community/Mage_Core_Adminhtml 1.7.0.0
...................Package community/Mage_Core_Adminhtml 1.7.0.0 installed successfully
..Starting to download Mage_Core_Modules-1.7.0.0.tgz ...
............done: 3,105,119 bytes
....................................................Installing package community/Mage_Core_Modules 1.7.0.0
....................................................................................Package community/Mage_Core_Modules 1.7.0.0 installed successfully
..Already installed: community/Lib_Js_Ext 1.7.0.0, skipping
Already installed: community/Lib_LinLibertineFont 2.8.14.1, skipping
Starting to download Lib_Js_TinyMCE-3.4.7.0.tgz ...
.........done: 1,085,893 bytes
......Installing package community/Lib_Js_TinyMCE 3.4.7.0
.......Package community/Lib_Js_TinyMCE 3.4.7.0 installed successfully
.Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping
.Package upgraded:
community Mage_All_Latest 1.7.0.0
community Interface_Adminhtml_Default 1.7.0.0
community Interface_Frontend_Default 1.7.0.0
community Interface_Install_Default 1.7.0.0
community Mage_Downloader 1.7.0.0
community Mage_Centinel 1.7.0.0
community Interface_Frontend_Base_Default 1.7.0.0
community Phoenix_Moneybookers 1.3.1
community Mage_Compiler 1.7.0.0
community Magento_Mobile 1.7.0.0.22.1
community Mage_Core_Adminhtml 1.7.0.0
community Mage_Core_Modules 1.7.0.0
community Lib_Js_TinyMCE 3.4.7.0

Cleaning cache
Checking dependencies of packages
...............................................Already installed: community/Interface_Adminhtml_Default 1.7.0.0, skipping
Already installed: community/Mage_Core_Adminhtml 1.7.0.0, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Js_Ext 1.7.0.0, skipping
Already installed: community/Lib_LinLibertineFont 2.8.14.1, skipping
Already installed: community/Lib_Js_TinyMCE 3.4.7.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
.......................................Already installed: community/Interface_Frontend_Default 1.7.0.0, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
Already installed: community/Mage_Downloader 1.7.0.0, skipping

Cleaning cache
Checking dependencies of packages
..................................................Already installed: community/Interface_Frontend_Base_Default 1.7.0.0, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
.Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
...................................................................Already installed: community/Mage_Compiler 1.7.0.0, skipping
Already installed: community/Mage_Core_Adminhtml 1.7.0.0, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Js_Ext 1.7.0.0, skipping
Already installed: community/Lib_LinLibertineFont 2.8.14.1, skipping
Already installed: community/Lib_Js_TinyMCE 3.4.7.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
..Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
....................................................................Already installed: community/Mage_Core_Adminhtml 1.7.0.0, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Js_Ext 1.7.0.0, skipping
Already installed: community/Lib_LinLibertineFont 2.8.14.1, skipping
Already installed: community/Lib_Js_TinyMCE 3.4.7.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
..Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
.......................................................Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
.Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
Checking dependencies of packages
...................................................................Already installed: community/Magento_Mobile 1.7.0.0.22.1, skipping
Already installed: community/Mage_Core_Modules 1.7.0.0, skipping
Already installed: community/Lib_Varien 1.7.0.0, skipping
Already installed: community/Lib_Google_Checkout 1.5.0.0, skipping
Already installed: community/Lib_Js_Calendar 1.51.1.1, skipping
Already installed: community/Lib_Js_Mage 1.7.0.0, skipping
Already installed: community/Lib_Phpseclib 1.5.0.0, skipping
Already installed: community/Mage_Locale_en_US 1.7.0.0, skipping
Already installed: community/Lib_Mage 1.7.0.0, skipping
Already installed: community/Lib_ZF 1.11.1.0, skipping
Already installed: community/Lib_Js_Prototype 1.7.0.0.3, skipping
Already installed: community/Lib_ZF_Locale 1.11.1.0, skipping

Cleaning cache
...............................................................
Exception during cache and session cleaning.................................................................................................................................................................................................................................................
Cache cleaned successfully...................................................................................
Cache cleaned successfully......................................................................
Cache cleaned successfully........................
Cache cleaned successfully..................
Cache cleaned successfully....................
Cache cleaned successfully.................
Cache cleaned successfully................
Cache cleaned successfully..........
Cache cleaned successfully...........
Cache cleaned successfully..........
Cache cleaned successfully.......
Cache cleaned successfully.....
Cache cleaned successfully…
Cache cleaned successfully..
Cache cleaned successfully

and here is the error in full:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.min_price’ in ‘field list’

Trace:
#0 /var/www/vhosts/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/magento/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/magento/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT FLOOR((R...’, Array)
#4 /var/www/vhosts/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT FLOOR((R...’, Array)
#5 /var/www/vhosts/magento/lib/Zend/Db/Adapter/Abstract.php(808): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php(274): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select))
#7 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(158): Mage_Catalog_Model_Resource_Layer_Filter_Price->getCount(Object(Mage_Catalog_Model_Layer_Filter_Price), 1000)
#8 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(115): Mage_Catalog_Model_Layer_Filter_Price->getRangeItemCounts(1000)
#9 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(314): Mage_Catalog_Model_Layer_Filter_Price->getPriceRange()
#10 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Mage_Catalog_Model_Layer_Filter_Price->_getItemsData()
#11 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems()
#12 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems()
#13 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount()
#14 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Block/Layer/View.php(218): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount()
#15 /var/www/vhosts/magento/app/code/core/Mage/Catalog/Block/Layer/View.php(233): Mage_Catalog_Block_Layer_View->canShowOptions()
#16 /var/www/vhosts/magento/app/design/frontend/base/default/template/catalog/layer/view.phtml(34): Mage_Catalog_Block_Layer_View->canShowBlock()
#17 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#18 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/base/d...’)
#19 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#20 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#21 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#22 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#23 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#24 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’left’, true)
#25 /var/www/vhosts/magento/app/design/frontend/default/hellocanvas/template/page/3columns.phtml(48): Mage_Core_Block_Abstract->getChildHtml(’left’)
#26 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#27 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/defaul...’)
#28 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#29 /var/www/vhosts/magento/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#30 /var/www/vhosts/magento/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#31 /var/www/vhosts/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#32 /var/www/vhosts/magento/app/code/core/Mage/Catalog/controllers/CategoryController.php(159): Mage_Core_Controller_Varien_Action->renderLayout()
#33 /var/www/vhosts/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController->viewAction()
#34 /var/www/vhosts/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#35 /var/www/vhosts/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#36 /var/www/vhosts/magento/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#37 /var/www/vhosts/magento/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#38 /var/www/vhosts/magento/index.php(87): Mage::run(’’, ‘store’)
#39 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
connor2k
Jr. Member
 
Total Posts:  14
Joined:  2008-08-06
 

Did any answers ever come out of this? I am still getting an error for the captcha_log table.

 
Magento Community Magento Community
Magento Community
Magento Community
 
kab8609
Enthusiast
 
Avatar
Total Posts:  821
Joined:  2009-04-07
Cleveland
 

Hey Guys,
I also am receiving this error on a Enterprise upgrade to EE1.12.0.0 (which is equivalent to CE1.7.0.0). For me, it is happening when layered navigation is turned on in a category page. Currently debugging right now.

The file in question (at least for me) is
app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php
line 253

 
Magento Community Magento Community
Magento Community
Magento Community
 
Rocket Web
Jr. Member
 
Avatar
Total Posts:  28
Joined:  2010-01-19
Naperville, IL
 

In our case it turned out that TBT_Bss has been altering that query. Disabling that extension in module\’s config file helped.

It looks that this extension (and tbt advanced product grid in our case) is not compatible with magento ee 1.12, what is confirmed on extension page:

http://www.magentocommerce.com/magento-connect/better-store-search.html

 
Magento Community Magento Community
Magento Community
Magento Community
 
Jorge Lima Jr
Jr. Member
 
Total Posts:  8
Joined:  2010-10-14
 

After the update and the problem was solved.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Bosco07
Jr. Member
 
Avatar
Total Posts:  10
Joined:  2012-02-24
 

I am getting a similar error as well. in 1.7.0.0.  Any ideas on fixes??

a:5:{i:0;s:88:"SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.final_price’ in ‘where clause‘“;i:1;s:6574:"#0 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT COUNT(DI...’, Array)
#4 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT COUNT(DI...’, Array)
#5 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Zend/Db/Adapter/Abstract.php(825): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#7 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
#8 /chroot/home/cleancon/cleancontroldirect.com/html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
#9 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1036): Varien_Data_Collection->getCurPage()
#10 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#11 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract->load()
#12 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Review_Model_Observer->catalogBlockProductCollectionBeforeToHtml(Object(Varien_Event_Observer))
#13 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Model/App.php(1311): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Review_Model_Observer), ‘catalogBlockPro...’, Object(Varien_Event_Observer))
#14 /chroot/home/cleancon/cleancontroldirect.com/html/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent(’catalog_block_p...’, Array)
#15 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Catalog/Block/Product/List.php(163): Mage::dispatchEvent(’catalog_block_p...’, Array)
#16 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(862): Mage_Catalog_Block_Product_List->_beforeToHtml()
#17 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#18 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’product_list’, true)
#19 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Catalog/Block/Category/View.php(85): Mage_Core_Block_Abstract->getChildHtml(’product_list’)
#20 /chroot/home/cleancon/cleancontroldirect.com/html/app/design/frontend/em0045/default/template/catalog/category/view.phtml(71): Mage_Catalog_Block_Category_View->getProductListHtml()
#21 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(241): include(’/chroot/home/cl...’)
#22 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/em0045...’)
#23 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#24 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#25 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#26 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#27 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#28 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’content’, true)
#29 /chroot/home/cleancon/cleancontroldirect.com/html/app/design/frontend/em0045/default/template/page/3columns.phtml(49): Mage_Core_Block_Abstract->getChildHtml(’content’)
#30 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(241): include(’/chroot/home/cl...’)
#31 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/em0045...’)
#32 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#33 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#34 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#35 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#36 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Catalog/controllers/CategoryController.php(159): Mage_Core_Controller_Varien_Action->renderLayout()
#37 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController->viewAction()
#38 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’view’)
#39 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#40 /chroot/home/cleancon/cleancontroldirect.com/html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#41 /chroot/home/cleancon/cleancontroldirect.com/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#42 /chroot/home/cleancon/cleancontroldirect.com/html/index.php(87): Mage::run(’’, ‘store’)
#43 {main}”;s:3:"url”;s:26:"/gloves.html?price=100-200”;s:11:"script_name”;s:10:"/index.php”;s:4:"skin”;s:7:"default";}

 
Magento Community Magento Community
Magento Community
Magento Community
 
matt_space48
Jr. Member
 
Total Posts:  1
Joined:  2013-01-14
 

Hi everyone,

Did anyone ever find a fix for this? I have upgraded to 1.7 and I am having exactly the same problem.

I have a module that creates a page with a list of new products, and as soon as I turn the layered navigation on I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.news_from_date’ in ‘where clause’

Trace:
#0 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’SELECT FLOOR((R...’, Array)
#4 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’SELECT FLOOR((R...’, Array)
#5 /var/www/vhosts/mysite.co.uk/production/htdocs/lib/Zend/Db/Adapter/Abstract.php(808): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Price.php(274): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select))
#7 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(158): Mage_Catalog_Model_Resource_Layer_Filter_Price->getCount(Object(Mage_Catalog_Model_Layer_Filter_Price), 100)
#8 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(115): Mage_Catalog_Model_Layer_Filter_Price->getRangeItemCounts(100)
#9 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Price.php(314): Mage_Catalog_Model_Layer_Filter_Price->getPriceRange()
#10 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Mage_Catalog_Model_Layer_Filter_Price->_getItemsData()
#11 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems()
#12 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems()
#13 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount()
#14 /var/www/vhosts/mysite.co.uk/production/htdocs/app/design/frontend/base/default/template/catalog/layer/NewProductsSectionView.phtml(13): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount()
#15 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#16 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/base/d...’)
#17 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#18 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#19 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#20 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#21 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#22 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml(’left’, true)
#23 /var/www/vhosts/mysite.co.uk/production/htdocs/app/design/frontend/enterprise/default/template/page/3columns.phtml(50): Mage_Core_Block_Abstract->getChildHtml(’left’)
#24 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(241): include(’/var/www/vhosts...’)
#25 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(’frontend/enterp...’)
#26 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#27 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#28 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#29 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#30 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/local/Space48/NewProductsSection/controllers/IndexController.php(6): Mage_Core_Controller_Varien_Action->renderLayout()
#31 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Space48_NewProductsSection_IndexController->IndexAction()
#32 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#33 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#34 /var/www/vhosts/mysite.co.uk/production/htdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#35 /var/www/vhosts/mysite.co.uk/production/htdocs/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#36 /var/www/vhosts/mysite.co.uk/production/htdocs/index.php(87): Mage::run(’’, ‘store’)
#37 {main}

I’ve spent days trying to fix this error and cannot get my head around it.

If anyone could help it would be greatly appreciated.

Thanks,

Matt

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  3217
Joined:  2009-02-26
Minneapolis MN
 

Matt, is your error after you complete the upgrade or before?

One note: You will have to re-index after you upgrade and you should remove the “LOCKS” directory in your var folder.

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