Skip to main content
ErrorsMagentoUpgrading

Magento – Exception printing is disabled by default

By May 14, 2014September 21st, 201772 Comments

Another simple error after upgrading or installing Magento is the message “There has been an error processing your request. Exception printing is disabled by default for security reasons.”

This is usually because your Magento install has difficulty in knowing where to put your cache files. Thankfully it’s a simple fix.

If you’ve already set up exception logging (see below) you’ll also have the errors and warnings similar to these in your exception.log

Exception message: Could not determine temp directory, please specify a cache_dir manually

exception ‘Zend_Cache_Exception’ with message ‘Could not determine temp directory, please specify a cache_dir manually’ in …

How to specify a cache_dir

Best way – Change php.ini

Find your php.ini file in the root of your hosting, you might need to create one if it doesn’t exist. Then using your hosting Control Panel File Manager setting insert your file paths.

;tmp directory
upload_tmp_dir = /home/sitename/www/www/tmp/
sys_temp_dir = /home/sitename/www/www/tmp/

 

The php.ini file should be in the root of your hosting e.g. /home/sitename/php.ini

NOT

the root of your hosting e.g. /home/sitename/www/www/php.ini

If there is a php.ini in the root of your hosting e.g. /home/sitename/www/www/php.ini , it will override the main php.ini file and the above is unlikely to work.

 

Not ideal – Change File.php

If you can’t add a php.ini file. You can add a temp folder location in a core Magento file. Changing a core file isn’t ideal as this issue will return if you update your Magento files.

Locate the file;

/lib/Zend/Cache/Backend/File.php

and find;

‘cache_dir’ => null,

which can be found around line 99.

and change it to;

‘cache_dir’ => ‘tmp/’,

 

Magento exception printing is disabled

 

Create a tmp folder

Now create, if it doesn’t already exist, a folder named tmp in the root of your Magento installation.

 

Enable Magento exception printing

If this doesn’t fix your issue or to get a more detailed report on your error, you can temporarily enable exception printing.

Go to;

errors/local.xml.sample

and rename local.xml.sample to local.xml

It’s best to revert this back to .sample after you’ve solved your issue, as throwing out error messages in the front end is a basic way for hackers to debug your server and file set up.

In most cases errors will be logged in the /errors folder and you won’t have any need to do this.

 

Enable Magento exception logging

Enabling exception logging via admin, will also help you to get more information on your Magento errors.

In admin go to;

System > Configuration > Developer > Log Settings > Enabled = Yes

The custom locations for the error log files should be fine, but make sure that the folder is writeable.

Future errors should now be stored in the files;

  • exception.log
  • system.log

which are in the {{base_dir}}/var/log folder.

 

Magento exception logging - admin screenshot

 

Still having issues?

To make sure your site is actually using the latest, updated versions of your files disable caching and reindex your Magento site. Cache should be enabled on your completed live site, to greatly increase its speed for returning visitors, but disabled on test environments.

Disable Cache
System > Cache Management > Select All [check-boxes] > Actions = Disable > Submit

Re-Index All
System > Index Management > Select All [check-boxes] > Actions = Reindex Data > Submit

 

Enable Magento developer Mode

If you’d like your error messages displayed on screen, rather than stored in log files, you can enable developer mode. This is best used only on local, development installations.

Developer mode can be set in your local apache configuration or within your .htaccess file in your root Magento folder.

SetEnv MAGE_IS_DEVELOPER_MODE "true"

 

Again, you don’t want this enabled on your live website.

 

Magento errors

Magento mentions why it doesn’t provide error information on the frontend of a site by default, in its installation documentation.

– such information might give clues about how to attack the website
– it is not very user friendly; most visitors will be confused when seeing such a page

500 Magento errors

This is due to file permissions and can be quickly fixed by loading the magento cleanup tool file in the root of your Magento installation.

503 Magento errors

If you’ve just updated or installed Magento check that the temporary maintenance.flag has been removed.

Magento can be frustrating to get up and running, but errors like these are easy to overcome. Just try not to edit core files directly and remember to backup your files and db before making any big changes.

 

If you’d like help getting your Magento website back on track, Magento error help or view our Magento website portfolio.

Andrew Taylor

A senior UI designer with over 25 years of web design and web development experience working for some of the largest companies in the UK. An expert in all things Magento and WordPress.

72 Comments

  • Fernando says:

    Hi Andrew!

    I have an issue that I think you could tell me what to do… I tried to install a new theme for Magento 1.9.0.1.. the theme is Glamshop. When I upload all the files and try to to install it from the backend, it is required to clean cache but after that, it shows the following error: There has been an error processing your request
    xception printing is disabled by default for security reasons.
    Error log record number: 919100442459
    I followed all your instructions and it allowed me to get into the admin and home page a couple of times but now it is still showing the same error and cannot be fixed….

    Do you have a solution for this error?

    Thanks in advance!

  • Hi Fernando, you’ll need to view your error log files or enable exception printing to get a more detailed description of the problem.

    1) Look at the error files in the “/errors” folder.
    2) Change local.xml.sample to local.xml to enable error messages in the frontend.

  • Ekta says:

    While installing magento 1.9.0 it shows folloeing error:

    There has been an error processing your request

    Exception printing is disabled by default for security reasons.

    Error log record number: 1929359046

  • Ekta says:

    Please give solution for that as early you can

  • Hi Ekta, you’ll need to enable exception printing to get a more detailed description of the problem. If you rename local.xml.sample to local.xml, you’ll then be able to view detailed error messages on your site.

  • Jihn says:

    Hi Andrew,
    How much would it cost to fix this as I am a non-technical person….

  • Asif says:

    Hi Andrew!

    I have same error “Exception printing is disabled by default for security reasons.”

    Error log record number: 3130676031342

    i install magento 1.9.0.1 and upload custom them. it work fine few week. When I click category link on top menu. Its show above error message and other pages working fine , only category link show error message. I need advise to sort out this errors. Thanks

    Kindly Regards

  • Hi Asif,

    Thanks for commenting. Have you tried renaming local.xml.sample to local.xml?

    You’ll find local.xml.sample in the errors/ folder.

    Andrew

  • kiran says:

    whenever i opne any cms page at that time show this error
    Exception printing is disabled by default for security reasons.

    Error log record number: 335882821….

  • Andy Myers says:

    You say:

    Locate the file;

    /lib/Zend/Cache/Backend/File.php

    and find;

    ‘cache_dir’ => null,

    which can be found around line 91.

    But you don’t say what to do with it?? Am I missing something?

  • Thanks for letting me know, I’ve now fixed the above. You need to change the line to;
    'cache_dir' => 'tmp/',
    and then create a matching tmp folder.

  • Carolyn says:

    I have the same error and have gone through the instructions above, I’m still having this error and I have created the ‘tmp/’

    What do I do after that point? I’m not a coder but regrets switching from prestashop to magento.

  • If you’re still able to log into Magento’s Admin section, try reindexing the data (System > Index Management) and cache (System > Cache Management > Refresh). This ensures Magento is using the latest versions of your files, it’s best to disable Cache completely whilst in production.

    Let me know if this fixes the issue. Otherwise have you tried renaming local.xml.sample to local.xml? To get the error in full.

  • Carolyn says:

    Unfortunately, that did not work. I am still unable to add/edit products, and manage categories

  • Hi Carolyn,
    I’ve updated the article, adding a few more ways to enable error reporting on your site. Hopefully it’s not too late.

  • mukul sharma says:

    hi andrew… i am facing same problem after installing magento 1.9.0.1 on local host. i tried all method mention above but problem still exit. i am unable to do reintex step… plz give me some solution.

  • rizky says:

    hi andrew i have done change local.xml.sample to local.xm and change ‘cache_dir’ => ‘tmp/’ but still didnt work, can you help me 🙁

  • Dhruv says:

    While open any product in magento 1.9.0 it shows folloeing error:

    There has been an error processing your request

    Exception printing is disabled by default for security reasons.

    Error log record number: 1929359046

  • Syed Hafeez says:

    I upgrade the magento version 1.6.2 to 1.9.1 through magento connect upgrade botton, after upgrade version front page is showing a error :

    There has been an error processing your request

    Invalid method AW_Blog_Block_Blog::addTopLink(Array
    (
    )
    )

    Trace:
    #0 [internal function]: Varien_Object->__call(‘addTopLink’, Array)
    #1 [internal function]: AW_Blog_Block_Blog->addTopLink()
    #2 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Model/Layout.php(348): call_user_func_array(Array, Array)
    #3 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Model/Layout.php(214): Mage_Core_Model_Layout->_generateAction(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
    #4 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Model/Layout.php(206): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #5 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #6 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
    #7 /var/www/clients/client1/web7/web/app/code/core/Mage/Cms/Helper/Page.php(113): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #8 /var/www/clients/client1/web7/web/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #9 /var/www/clients/client1/web7/web/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #10 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
    #11 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #12 /var/www/clients/client1/web7/web/app/code/community/BalkeTechnologies/StoreMaintenance/Controller/Router/Standard.php(91): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #13 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Controller/Varien/Front.php(172): BalkeTechnologies_StoreMaintenance_Controller_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #14 /var/www/clients/client1/web7/web/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #15 /var/www/clients/client1/web7/web/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #16 /var/www/clients/client1/web7/web/index.php(71): Mage::run(”, ‘store’)
    #17 {main}

    Error log record number: 1316409140313

    Please Tell me how to solve it… Thanks 🙂

  • Hi Syed,

    It looks like an issue with your AW_Blog plugin. Does the plugin also now need an update to bring it in line with your newer Magento version? Disabling it should bring your site back, whilst you contact the plugin support or remove/update that method.

  • Jay says:

    Hello Andrew,

    While I tried to change a new theme only in a multi-launguage site especially in Russia page, there comes an error like above case. Could you please give me a your deep guideline to fix the problem?

    Exception printing is disabled by default for security reasons.
    Error log record number: 1184184010928

    a:5:{i:0;s:85:”SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘quick_view’ in ‘where clause'”;i:1;s:4897:”#0 /home2/han-daigou.com/html/includes/src/Varien_Db_Statement_Pdo_Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /home2/han-daigou.com/html/includes/src/__default.php(72068): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /home2/han-daigou.com/html/includes/src/__default.php(61869): Zend_Db_Statement->execute(Array)
    #3 /home2/han-daigou.com/html/includes/src/__default.php(62907): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(*)…’, Array)
    #4 /home2/han-daigou.com/html/includes/src/__default.php(63765): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(*)…’, Array)
    #5 /home2/han-daigou.com/html/includes/src/__default.php(62217): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
    #6 /home2/han-daigou.com/html/includes/src/__default.php(5931): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
    #7 /home2/han-daigou.com/html/includes/src/__default.php(5115): Varien_Data_Collection_Db->getSize()
    #8 /home2/han-daigou.com/html/includes/src/__default.php(5101): Varien_Data_Collection->getLastPageNumber()
    #9 /home2/han-daigou.com/html/includes/src/__default.php(6222): Varien_Data_Collection->getCurPage()
    #10 /home2/han-daigou.com/html/includes/src/__default.php(6269): Varien_Data_Collection_Db->_renderLimit()
    @

  • mahesh says:

    SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magentodb.sales_order_status’ doesn’t exist,

  • jidendra says:

    Mr.Andrew Taylor . Thank you so much for your Support. Now Website Working. Great Job!

  • Roky says:

    Hey Andrew i am just waiting for your support after spending 2 nights ,I tried installing Magento with XAMPP and WAMP,but problem persist,please help me with your Expertise.

    here is my error log :

    There has been an error processing your request

    Error in file: “C:\wamp\www\magento\app\code\core\Mage\Sales\sql\sales_setup\install-1.6.0.0.php” – SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order’ already exists

    Trace:
    #0 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘install’, ”, ‘1.6.0.8’)
    #2 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘1.6.0.8’)
    #3 C:\wamp\www\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 C:\wamp\www\magento\app\code\core\Mage\Core\Model\App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 C:\wamp\www\magento\app\code\core\Mage\Core\Model\App.php(343): Mage_Core_Model_App->_initModules()
    #6 C:\wamp\www\magento\app\Mage.php(684): Mage_Core_Model_App->run(Array)
    #7 C:\wamp\www\magento\index.php(87): Mage::run(”, ‘store’)
    #8 {main}

    Error log record number: 798536518

  • Hi Roky,

    Is this a fresh install of Magento or an upgrade?

    I’ve had similar errors before when an upgrade has only partially completed. When starting the upgrade again the install finds that some of the tables it needs to install have already been added, so sends out ‘Table ‘xxx’ already exists’ errors.

    To move beyond this error you can drop/delete the table within phpMyAdmin (make a backup first), or alter the command in the that installation file so it drops or ignores that function if the table already exists.

    If this is a clean install, it might be easier to drop the whole Magento table and start over.

  • Roky says:

    Heya Andrew 😉 ,

    I am very pleased to get reply from your side.
    Coming to magneto part its a fresh install ,waiting for your reply eagerly.

  • vinay says:

    Error in file: “/home1/elements/public_html/elementsbd/bshoplove/app/code/local/Sm/Deal/sql/sm_deal_setup/install-0.0.1.php” – SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘deal_deal’ already exists

    Trace:
    #0 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/Resource/Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘install’, ”, ‘0.0.1’)
    #2 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/Resource/Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘0.0.1’)
    #3 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 /home1/elements/public_html/elementsbd/bshoplove/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
    #6 /home1/elements/public_html/elementsbd/bshoplove/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #7 /home1/elements/public_html/elementsbd/bshoplove/index.php(90): Mage::run(”, ‘store’)
    #8 {main}

  • vinay says:

    could some one provide the solution

  • Hi,

    Is sm_deal a plugin or theme? The most common cause of ‘Base table or view already exist’ is when an install has only partially completed. The installation then tries to run again from the start but finds that the database tables it is trying to create are already there.

    If this is a new or dev install, it’s best to drop these plugin/theme tables (such as deal_deal) or to revert back to your backup and to try again.

  • suba says:

    Hi Andrew,

    There has been an error processing your request
    Exception printing is disabled by default for security reasons.

    Error log record number: 506600012505

    Magento is a trademark of Magento Inc. Copyright © 2012 Magento Inc.

    am getting this error. Error log record number varies.I changed the line in /lib/Zend/Cache/Backend/File.php and created a tmp folder but still my site doesnt work.

    The errors are :
    Trace:
    #0 /data/www/magento/release-20140930/www/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
    #1 /data/www/magento/release-20140930/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect()
    #2 /data/www/magento/release-20140930/www/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect()
    #3 /data/www/magento/release-20140930/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SET NAMES utf8’, Array)
    #4 /data/www/magento/release-20140930/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(‘SET NAMES utf8’, Array)
    #5 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource.php(169): Varien_Db_Adapter_Pdo_Mysql->query(‘SET NAMES utf8’)
    #6 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection(‘pdo_mysql’, Object(Mage_Core_Model_Config_Element))
    #7 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection(‘core_write’)
    #8 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection(‘write’)
    #9 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
    #10 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
    #11 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection()
    #12 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Config.php(1348): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
    #13 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Config.php(1380): Mage_Core_Model_Config->getModelInstance(‘core_resource/w…’, Object(Mage_Core_Model_Resource_Website))
    #14 /data/www/magento/release-20140930/www/app/Mage.php(490): Mage_Core_Model_Config->getResourceModelInstance(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #15 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #16 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection()
    #17 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/App.php(608): Mage_Core_Model_Abstract->getCollection()
    #18 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/App.php(466): Mage_Core_Model_App->_initStores()
    #19 /data/www/magento/release-20140930/www/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Model_App->_initCurrentStore(”, ‘store’)
    #20 /data/www/magento/release-20140930/www/app/Mage.php(683): Mage_Core_Model_App->run(Array)
    #21 /data/www/magento/release-20140930/www/index.php(91): Mage::run(”, ‘store’)
    #22 {main}

    Could you please provide me a solution

  • Hi Suba,

    This seems to be a server configuration issue, are your versions of php and mysql sufficient to run Magento?

    Try using the magento-check.php file to confirm your server’s compatibility;
    http://merch.docs.magento.com/ce/user_guide/Magento_Community_Edition_User_Guide.html#magento/magento-compability-check.html

  • neeraj says:

    Dear Sir / Madam

    http://jinni.co.in/

    in this website, I have change lib/zend/cache/Backend/File.php
    where ‘cache_dir’ => null, I change ‘cache_dir’ => tmp/,

    before change my website seen a error but after change this showing null (blank); so please help me, for solve this problem.

    thanks

  • dominique says:

    Hello I’m having this same issue. I have checked the errors and they are as followed…please advise and thank you in advance

    a:5:{i:0;s:30:”Memory limit has been reached.”;i:1;s:4516:”#0 /home/hotmakeup/public_html/lib/Varien/Image.php(70): Varien_Image_Adapter_Gd2->open(‘/home/hotmakeup…’)
    #1 /home/hotmakeup/public_html/lib/Varien/Image.php(52): Varien_Image->open()
    #2 /home/hotmakeup/public_html/app/code/local/Amasty/Conf/Helper/Image.php(86): Varien_Image->__construct(‘/home/hotmakeup…’)
    #3 /home/hotmakeup/public_html/app/code/local/Amasty/Conf/Helper/Data.php(26): Amasty_Conf_Helper_Image->init(‘https://www.hot…’)
    #4 /home/hotmakeup/public_html/app/code/local/Amasty/Conf/Block/Adminhtml/Catalog/Product/Attribute/Edit/Tab/Images.php(113): Amasty_Conf_Helper_Data->getImageUrl(‘955′, ’35’, ’35’)
    #5 /home/hotmakeup/public_html/app/design/adminhtml/default/default/template/amasty/amconf/icons.phtml(156): Amasty_Conf_Block_Adminhtml_Catalog_Product_Attribute_Edit_Tab_Images->getIcon(Object(Mage_Eav_Model_Entity_Attribute_Option))
    #6 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/hotmakeup…’)
    #7 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘adminhtml/defau…’)
    #8 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #9 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #10 /home/hotmakeup/public_html/app/code/local/Amasty/Conf/Model/Observer.php(228): Mage_Core_Block_Abstract->toHtml()
    #11 /home/hotmakeup/public_html/app/code/core/Mage/Core/Model/App.php(1357): Amasty_Conf_Model_Observer->onCoreBlockAbstractToHtmlBefore(Object(Varien_Event_Observer))
    #12 /home/hotmakeup/public_html/app/code/core/Mage/Core/Model/App.php(1336): Mage_Core_Model_App->_callObserverMethod(Object(Amasty_Conf_Model_Observer), ‘onCoreBlockAbst…’, Object(Varien_Event_Observer))
    #13 /home/hotmakeup/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘core_block_abst…’, Array)
    #14 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(906): Mage::dispatchEvent(‘core_block_abst…’, Array)
    #15 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #16 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #17 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #18 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘left’, true)
    #19 /home/hotmakeup/public_html/app/design/adminhtml/default/default/template/page.phtml(58): Mage_Core_Block_Abstract->getChildHtml(‘left’)
    #20 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/hotmakeup…’)
    #21 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘adminhtml/defau…’)
    #22 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #23 /home/hotmakeup/public_html/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml()
    #24 /home/hotmakeup/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml()
    #25 /home/hotmakeup/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #26 /home/hotmakeup/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #27 /home/hotmakeup/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/Product/AttributeController.php(122): Mage_Core_Controller_Varien_Action->renderLayout()
    #28 /home/hotmakeup/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_Product_AttributeController->editAction()
    #29 /home/hotmakeup/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘edit’)
    #30 /home/hotmakeup/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #31 /home/hotmakeup/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #32 /home/hotmakeup/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #33 /home/hotmakeup/public_html/index.php(83): Mage::run(”, ‘store’)
    #34 {main}”;s:3:”url”;s:102:”/index.php/admin/catalog_product_attribute/edit/attribute_id/162/key/614bd90ce9c8bee6e9cb27ad4094233e/”;s:11:”script_name”;s:10:”/index.php”;s:4:”skin”;s:5:”admin”;}

  • Hi Dominique, ‘Memory limit has been reached’ can usually be resolved by making changes to the memory allocated in your php.ini or .htaccess files. Is this occurring when you try to upload product images or add new products?

    php.ini

    Open /etc/php5/apache2/php.ini

    and change memory_limit to:
    memory_limit = 256M

    .htaccess

    For timeout issues when uploading products;

    Open .htaccess
    and change or add the following;

    php_value memory_limit 256M
    php_value max_execution_time 18000

    If this issues only occurs when you’re making lots of admin changes, I’d switch the values back afterwards.

    Thanks

    Andrew

  • sashikant says:

    Hi Andrew,

    I also have the same issue

    There has been an error processing your request
    Exception printing is disabled by default for security reasons.

    Error log record number: 181145146079

    It was working fine but all of a sudden it is showing the same error time and again.. What is the solution to permanent curb this issue. Do you have any step by step process to solve this issue ?? The error numbers are changing but the problem remains the same . Every 3rd day it shows the same errer with different error number..

    Best Regards
    Sashi

  • Hi Sashi,

    You need to use one of the methods described above to get the real error message. If you then paste that error, I can help you to debug it.

    Thanks

    Andrew

  • Anoop says:

    hai brother
    i have error in magento am using Magento ver. 1.9.2.1
    error happen if new patch in not install?

  • Anoop says:

    this is my error report can you please chek ?

    a:5:{i:0;s:407:”SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘e.status’ in ‘where clause’, query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_1` AS `e`
    INNER JOIN `deal_deal_product` AS `related` ON related.product_id = e.entity_id
    INNER JOIN `deal_deal` AS `deal` ON deal.entity_id = related.deal_id WHERE (e.status = 1) AND (deal.status = ‘1’) AND (deal.end_date > ‘2015-08-08 18:17:58’)”;i:1;s:3933:”#0 /home/sandeepkerala50/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /home/sandeepkerala50/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /home/sandeepkerala50/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /home/sandeepkerala50/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT COUNT(DI…’, Array)
    #4 /home/sandeepkerala50/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT COUNT(DI…’, Array)
    #5 /home/sandeepkerala50/public_html/lib/Zend/Db/Adapter/Abstract.php(828): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
    #6 /home/sandeepkerala50/public_html/lib/Varien/Data/Collection/Db.php(225): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
    #7 /home/sandeepkerala50/public_html/lib/Varien/Data/Collection.php(225): Varien_Data_Collection_Db->getSize()
    #8 /home/sandeepkerala50/public_html/lib/Varien/Data/Collection.php(211): Varien_Data_Collection->getLastPageNumber()
    #9 /home/sandeepkerala50/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1034): Varien_Data_Collection->getCurPage()
    #10 /home/sandeepkerala50/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
    #11 /home/sandeepkerala50/public_html/app/code/local/Sm/Deal/Block/List.php(35): Mage_Eav_Model_Entity_Collection_Abstract->load()
    #12 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Block/Abstract.php(293): Sm_Deal_Block_List->_prepareLayout()
    #13 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
    #14 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock(‘deal/List’, ‘deal’)
    #15 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock(‘deal/List’, ‘deal’)
    #16 /home/sandeepkerala50/public_html/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))
    #17 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #18 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
    #19 /home/sandeepkerala50/public_html/app/code/core/Mage/Cms/Helper/Page.php(113): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #20 /home/sandeepkerala50/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #21 /home/sandeepkerala50/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #22 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
    #23 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #24 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #25 /home/sandeepkerala50/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #26 /home/sandeepkerala50/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #27 /home/sandeepkerala50/public_html/index.php(83): Mage::run(”, ‘store’)
    #28 {main}”;s:3:”url”;s:1:”/”;s:11:”script_name”;s:10:”/index.php”;s:4:”skin”;s:7:”english”;}

  • Hi,

    Stack Exchange suggests that this is a re-indexing issue.

    Within your Magento Admin Panel, go to
    System > Index Management

    Then choose;
    Select All
    Submit (Re-index Data)

    http://magento.stackexchange.com/questions/73641/sqlstate42s22-column-not-found-1054-unknown-column-e-status-after-1-9-2-up

    Thanks

    Andrew

  • Garima says:

    Hi Andrew , I am getting the below comment.Please help. I have changed the local.xml.sample to local.xml and pointed change_dir => ‘tmp/’ .Where do we have to create the tmp folder ?

    Error in file: “C:\xampp\htdocs\magento\app\code\core\Mage\Sales\sql\sales_setup\install-1.6.0.0.php” – SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order’ already exists, query was: CREATE TABLE `sales_flat_order` (
    `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT ‘Entity Id’ ,
    `state` varchar(32) NULL COMMENT ‘State’ ,
    `status` varchar(32) NULL COMMENT ‘Status’ ,
    `coupon_code` varchar(255) NULL COMMENT ‘Coupon Code’ ,
    `protect_code` varchar(255) NULL COMMENT ‘Protect Code’ ,
    `shipping_description` varchar(255) NULL COMMENT ‘Shipping Description’ ,
    `is_virtual` smallint UNSIGNED NULL COMMENT ‘Is Virtual’ ,
    `store_id` smallint UNSIGNED NULL COMMENT ‘Store Id’ ,
    `customer_id` int UNSIGNED NULL COMMENT ‘Customer Id’ ,
    `base_discount_amount` decimal(12,4) NULL COMMENT ‘Base Discount Amount’ ,
    `base_discount_canceled` decimal(12,4) NULL COMMENT ‘Base Discount Canceled’ ,
    `base_discount_invoiced` decimal(12,4) NULL COMMENT ‘Base Discount Invoiced’ ,
    `base_discount_refunded` decimal(12,4) NULL COMMENT ‘Base Discount Refunded’ ,
    `base_grand_total` decimal(12,4) NULL COMMENT ‘Base Grand Total’ ,
    `base_shipping_amount` decimal(12,4) NULL COMMENT ‘Base Shipping Amount’ ,
    `base_shipping_canceled` decimal(12,4) NULL COMMENT ‘Base Shipping Canceled’ ,
    `base_shipping_invoiced` decimal(12,4) NULL COMMENT ‘Base Shipping Invoiced’ ,
    `base_shipping_refunded` decimal(12,4) NULL COMMENT ‘Base Shipping Refunded’ ,
    `base_shipping_tax_amount` decimal(12,4) NULL COMMENT ‘Base Shipping Tax Amount’ ,
    `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT ‘Base Shipping Tax Refunded’ ,
    `base_subtotal` decimal(12,4) NULL COMMENT ‘Base Subtotal’ ,
    `base_subtotal_canceled` decimal(12,4) NULL COMMENT ‘Base Subtotal Canceled’ ,
    `base_subtotal_invoiced` decimal(12,4) NULL COMMENT ‘Base Subtotal Invoiced’ ,
    `base_subtotal_refunded` decimal(12,4) NULL COMMENT ‘Base Subtotal Refunded’ ,
    `base_tax_amount` decimal(12,4) NULL COMMENT ‘Base Tax Amount’ ,
    `base_tax_canceled` decimal(12,4) NULL COMMENT ‘Base Tax Canceled’ ,
    `base_tax_invoiced` decimal(12,4) NULL COMMENT ‘Base Tax Invoiced’ ,
    `base_tax_refunded` decimal(12,4) NULL COMMENT ‘Base Tax Refunded’ ,
    `base_to_global_rate` decimal(12,4) NULL COMMENT ‘Base To Global Rate’ ,
    `base_to_order_rate` decimal(12,4) NULL COMMENT ‘Base To Order Rate’ ,
    `base_total_canceled` decimal(12,4) NULL COMMENT ‘Base Total Canceled’ ,
    `base_total_invoiced` decimal(12,4) NULL COMMENT ‘Base Total Invoiced’ ,
    `base_total_invoiced_cost` decimal(12,4) NULL COMMENT ‘Base Total Invoiced Cost’ ,
    `base_total_offline_refunded` decimal(12,4) NULL COMMENT ‘Base Total Offline Refunded’ ,
    `base_total_online_refunded` decimal(12,4) NULL COMMENT ‘Base Total Online Refunded’ ,
    `base_total_paid` decimal(12,4) NULL COMMENT ‘Base Total Paid’ ,
    `base_total_qty_ordered` decimal(12,4) NULL COMMENT ‘Base Total Qty Ordered’ ,
    `base_total_refunded` decimal(12,4) NULL COMMENT ‘Base Total Refunded’ ,
    `discount_amount` decimal(12,4) NULL COMMENT ‘Discount Amount’ ,
    `discount_canceled` decimal(12,4) NULL COMMENT ‘Discount Canceled’ ,
    `discount_invoiced` decimal(12,4) NULL COMMENT ‘Discount Invoiced’ ,
    `discount_refunded` decimal(12,4) NULL COMMENT ‘Discount Refunded’ ,
    `grand_total` decimal(12,4) NULL COMMENT ‘Grand Total’ ,
    `shipping_amount` decimal(12,4) NULL COMMENT ‘Shipping Amount’ ,
    `shipping_canceled` decimal(12,4) NULL COMMENT ‘Shipping Canceled’ ,
    `shipping_invoiced` decimal(12,4) NULL COMMENT ‘Shipping Invoiced’ ,
    `shipping_refunded` decimal(12,4) NULL COMMENT ‘Shipping Refunded’ ,
    `shipping_tax_amount` decimal(12,4) NULL COMMENT ‘Shipping Tax Amount’ ,
    `shipping_tax_refunded` decimal(12,4) NULL COMMENT ‘Shipping Tax Refunded’ ,
    `store_to_base_rate` decimal(12,4) NULL COMMENT ‘Store To Base Rate’ ,
    `store_to_order_rate` decimal(12,4) NULL COMMENT ‘Store To Order Rate’ ,
    `subtotal` decimal(12,4) NULL COMMENT ‘Subtotal’ ,
    `subtotal_canceled` decimal(12,4) NULL COMMENT ‘Subtotal Canceled’ ,
    `subtotal_invoiced` decimal(12,4) NULL COMMENT ‘Subtotal Invoiced’ ,
    `subtotal_refunded` decimal(12,4) NULL COMMENT ‘Subtotal Refunded’ ,
    `tax_amount` decimal(12,4) NULL COMMENT ‘Tax Amount’ ,
    `tax_canceled` decimal(12,4) NULL COMMENT ‘Tax Canceled’ ,
    `tax_invoiced` decimal(12,4) NULL COMMENT ‘Tax Invoiced’ ,
    `tax_refunded` decimal(12,4) NULL COMMENT ‘Tax Refunded’ ,
    `total_canceled` decimal(12,4) NULL COMMENT ‘Total Canceled’ ,
    `total_invoiced` decimal(12,4) NULL COMMENT ‘Total Invoiced’ ,
    `total_offline_refunded` decimal(12,4) NULL COMMENT ‘Total Offline Refunded’ ,
    `total_online_refunded` decimal(12,4) NULL COMMENT ‘Total Online Refunded’ ,
    `total_paid` decimal(12,4) NULL COMMENT ‘Total Paid’ ,
    `total_qty_ordered` decimal(12,4) NULL COMMENT ‘Total Qty Ordered’ ,
    `total_refunded` decimal(12,4) NULL COMMENT ‘Total Refunded’ ,
    `can_ship_partially` smallint UNSIGNED NULL COMMENT ‘Can Ship Partially’ ,
    `can_ship_partially_item` smallint UNSIGNED NULL COMMENT ‘Can Ship Partially Item’ ,
    `customer_is_guest` smallint UNSIGNED NULL COMMENT ‘Customer Is Guest’ ,
    `customer_note_notify` smallint UNSIGNED NULL COMMENT ‘Customer Note Notify’ ,
    `billing_address_id` int NULL COMMENT ‘Billing Address Id’ ,
    `customer_group_id` smallint NULL COMMENT ‘Customer Group Id’ ,
    `edit_increment` int NULL COMMENT ‘Edit Increment’ ,
    `email_sent` smallint UNSIGNED NULL COMMENT ‘Email Sent’ ,
    `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT ‘Forced Do Shipment With Invoice’ ,
    `payment_auth_expiration` int NULL COMMENT ‘Payment Authorization Expiration’ ,
    `quote_address_id` int NULL COMMENT ‘Quote Address Id’ ,
    `quote_id` int NULL COMMENT ‘Quote Id’ ,
    `shipping_address_id` int NULL COMMENT ‘Shipping Address Id’ ,
    `adjustment_negative` decimal(12,4) NULL COMMENT ‘Adjustment Negative’ ,
    `adjustment_positive` decimal(12,4) NULL COMMENT ‘Adjustment Positive’ ,
    `base_adjustment_negative` decimal(12,4) NULL COMMENT ‘Base Adjustment Negative’ ,
    `base_adjustment_positive` decimal(12,4) NULL COMMENT ‘Base Adjustment Positive’ ,
    `base_shipping_discount_amount` decimal(12,4) NULL COMMENT ‘Base Shipping Discount Amount’ ,
    `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT ‘Base Subtotal Incl Tax’ ,
    `base_total_due` decimal(12,4) NULL COMMENT ‘Base Total Due’ ,
    `payment_authorization_amount` decimal(12,4) NULL COMMENT ‘Payment Authorization Amount’ ,
    `shipping_discount_amount` decimal(12,4) NULL COMMENT ‘Shipping Discount Amount’ ,
    `subtotal_incl_tax` decimal(12,4) NULL COMMENT ‘Subtotal Incl Tax’ ,
    `total_due` decimal(12,4) NULL COMMENT ‘Total Due’ ,
    `weight` decimal(12,4) NULL COMMENT ‘Weight’ ,
    `customer_dob` datetime NULL COMMENT ‘Customer Dob’ ,
    `increment_id` varchar(50) NULL COMMENT ‘Increment Id’ ,
    `applied_rule_ids` varchar(255) NULL COMMENT ‘Applied Rule Ids’ ,
    `base_currency_code` varchar(3) NULL COMMENT ‘Base Currency Code’ ,
    `customer_email` varchar(255) NULL COMMENT ‘Customer Email’ ,
    `customer_firstname` varchar(255) NULL COMMENT ‘Customer Firstname’ ,
    `customer_lastname` varchar(255) NULL COMMENT ‘Customer Lastname’ ,
    `customer_middlename` varchar(255) NULL COMMENT ‘Customer Middlename’ ,
    `customer_prefix` varchar(255) NULL COMMENT ‘Customer Prefix’ ,
    `customer_suffix` varchar(255) NULL COMMENT ‘Customer Suffix’ ,
    `customer_taxvat` varchar(255) NULL COMMENT ‘Customer Taxvat’ ,
    `discount_description` varchar(255) NULL COMMENT ‘Discount Description’ ,
    `ext_customer_id` varchar(255) NULL COMMENT ‘Ext Customer Id’ ,
    `ext_order_id` varchar(255) NULL COMMENT ‘Ext Order Id’ ,
    `global_currency_code` varchar(3) NULL COMMENT ‘Global Currency Code’ ,
    `hold_before_state` varchar(255) NULL COMMENT ‘Hold Before State’ ,
    `hold_before_status` varchar(255) NULL COMMENT ‘Hold Before Status’ ,
    `order_currency_code` varchar(255) NULL COMMENT ‘Order Currency Code’ ,
    `original_increment_id` varchar(50) NULL COMMENT ‘Original Increment Id’ ,
    `relation_child_id` varchar(32) NULL COMMENT ‘Relation Child Id’ ,
    `relation_child_real_id` varchar(32) NULL COMMENT ‘Relation Child Real Id’ ,
    `relation_parent_id` varchar(32) NULL COMMENT ‘Relation Parent Id’ ,
    `relation_parent_real_id` varchar(32) NULL COMMENT ‘Relation Parent Real Id’ ,
    `remote_ip` varchar(255) NULL COMMENT ‘Remote Ip’ ,
    `shipping_method` varchar(255) NULL COMMENT ‘Shipping Method’ ,
    `store_currency_code` varchar(3) NULL COMMENT ‘Store Currency Code’ ,
    `store_name` varchar(255) NULL COMMENT ‘Store Name’ ,
    `x_forwarded_for` varchar(255) NULL COMMENT ‘X Forwarded For’ ,
    `customer_note` text NULL COMMENT ‘Customer Note’ ,
    `created_at` timestamp NULL default NULL COMMENT ‘Created At’ ,
    `updated_at` timestamp NULL default NULL COMMENT ‘Updated At’ ,
    `total_item_count` smallint UNSIGNED NOT NULL default ‘0’ COMMENT ‘Total Item Count’ ,
    `customer_gender` int NULL COMMENT ‘Customer Gender’ ,
    `hidden_tax_amount` decimal(12,4) NULL COMMENT ‘Hidden Tax Amount’ ,
    `base_hidden_tax_amount` decimal(12,4) NULL COMMENT ‘Base Hidden Tax Amount’ ,
    `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT ‘Shipping Hidden Tax Amount’ ,
    `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT ‘Base Shipping Hidden Tax Amount’ ,
    `hidden_tax_invoiced` decimal(12,4) NULL COMMENT ‘Hidden Tax Invoiced’ ,
    `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT ‘Base Hidden Tax Invoiced’ ,
    `hidden_tax_refunded` decimal(12,4) NULL COMMENT ‘Hidden Tax Refunded’ ,
    `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT ‘Base Hidden Tax Refunded’ ,
    `shipping_incl_tax` decimal(12,4) NULL COMMENT ‘Shipping Incl Tax’ ,
    `base_shipping_incl_tax` decimal(12,4) NULL COMMENT ‘Base Shipping Incl Tax’ ,
    PRIMARY KEY (`entity_id`),
    INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
    INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
    INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
    UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
    INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
    INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
    INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
    INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
    INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
    CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
    CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
    ) COMMENT=’Sales Flat Order’ ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci

    Trace:
    #0 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘install’, ”, ‘1.6.0.9’)
    #2 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘1.6.0.9’)
    #3 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(428): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(354): Mage_Core_Model_App->_initModules()
    #6 C:\xampp\htdocs\magento\app\Mage.php(684): Mage_Core_Model_App->run(Array)
    #7 C:\xampp\htdocs\magento\index.php(83): Mage::run(”, ‘store’)
    #8 {main}

  • VICTOR says:

    Can this be a problem with Memory Limit?
    Please Help

    Trace:
    #0 /home/importke/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /home/importke/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /home/importke/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /home/importke/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT SUM(orde…’, Array)
    #4 /home/importke/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT SUM(orde…’, Array)
    #5 /home/importke/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(‘SELECT SUM(orde…’, Array)
    #6 /home/importke/public_html/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT SUM(orde…’, Array)
    #7 /home/importke/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1045): Varien_Data_Collection_Db->_fetchAll(‘SELECT SUM(orde…’)
    #8 /home/importke/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
    #9 /home/importke/public_html/lib/Varien/Data/Collection.php(741): Mage_Eav_Model_Entity_Collection_Abstract->load()
    #10 /home/importke/public_html/app/code/local/Magentothem/Bestsellerproduct/Block/Bestsellerproduct.php(33): Varien_Data_Collection->getIterator()
    #11 /home/importke/public_html/app/design/frontend/ma_bautique/ma_bautique2/template/magentothem/bestsellerproduct/bestsellerproduct.phtml(18): Magentothem_Bestsellerproduct_Block_Bestsellerproduct->getProducts()
    #12 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/importke/…’)
    #13 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_bau…’)
    #14 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #15 /home/importke/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #16 /home/importke/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #17 /home/importke/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #18 /home/importke/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #19 /home/importke/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘left’, true)
    #20 /home/importke/public_html/app/design/frontend/ma_bautique/ma_bautique2/template/page/2columns-left.phtml(52): Mage_Core_Block_Abstract->getChildHtml(‘left’)
    #21 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/importke/…’)
    #22 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_bau…’)
    #23 /home/importke/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #24 /home/importke/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #25 /home/importke/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #26 /home/importke/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #27 /home/importke/public_html/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
    #28 /home/importke/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘bautique2_home’)
    #29 /home/importke/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘bautique2_home’)
    #30 /home/importke/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
    #31 /home/importke/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #32 /home/importke/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #33 /home/importke/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #34 /home/importke/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #35 /home/importke/public_html/index.php(83): Mage::run(”, ‘store’)
    #36 {main}

  • Hi Victor,

    Are you using a best seller product plugin or custom code? and when does this error occur?

  • kavya says:

    I can’t understand what is the problem, please help

    SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento.core_store’ doesn’t exist, query was: SELECT `main_table`.* FROM `core_store` AS `main_table` ORDER BY CASE WHEN main_table.store_id = 0 THEN 0 ELSE 1 END ASC, main_table.sort_order ASC, main_table.name ASC

    Trace:
    #0 /var/www/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /var/www/html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /var/www/html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /var/www/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT `main_ta…’, Array)
    #4 /var/www/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT `main_ta…’, Array)
    #5 /var/www/html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(‘SELECT `main_ta…’, Array)
    #6 /var/www/html/lib/Varien/Data/Collection/Db.php(730): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT `main_ta…’, Array)
    #7 /var/www/html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll(‘SELECT `main_ta…’, Array)
    #8 /var/www/html/lib/Varien/Data/Collection/Db.php(566): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
    #9 /var/www/html/app/code/core/Mage/Core/Model/Resource/Store/Collection.php(174): Varien_Data_Collection_Db->load(false, false)
    #10 /var/www/html/lib/Varien/Data/Collection.php(752): Mage_Core_Model_Resource_Store_Collection->load()
    #11 /var/www/html/app/code/core/Mage/Core/Model/App.php(635): Varien_Data_Collection->count()
    #12 /var/www/html/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores()
    #13 /var/www/html/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore(”, ‘store’)
    #14 /var/www/html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #15 /var/www/html/index.php(83): Mage::run(”, ‘store’)
    #16 {main}

  • Jamie says:

    Andrew – I have tried to follow every option that you have suggested to fix… I am still getting this error. Thoughts?

    SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘rule.calculate_subtotal’ in ‘field list’, query was: (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `stnmg_tax_calculation` AS `main_table`
    INNER JOIN `stnmg_tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
    INNER JOIN `stnmg_tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
    LEFT JOIN `stnmg_tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = ‘1’ WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (‘2’)) AND (rate.tax_country_id = ‘US’) AND (rate.tax_region_id IN(0, 44)) AND (rate.zip_is_range IS NULL) AND (rate.tax_postcode IS NULL OR rate.tax_postcode IN(‘*’, ”, ‘27713’, ‘27713*’, ‘2771*’, ‘277*’, ’27*’, ‘2*’))) UNION (SELECT `main_table`.`tax_calculation_rate_id`, `main_table`.`tax_calculation_rule_id`, `main_table`.`customer_tax_class_id`, `main_table`.`product_tax_class_id`, `rule`.`priority`, `rule`.`position`, `rule`.`calculate_subtotal`, `rate`.`rate` AS `value`, `rate`.`tax_country_id`, `rate`.`tax_region_id`, `rate`.`tax_postcode`, `rate`.`tax_calculation_rate_id`, `rate`.`code`, IF(title_table.value IS NULL, rate.code, title_table.value) AS `title` FROM `stnmg_tax_calculation` AS `main_table`
    INNER JOIN `stnmg_tax_calculation_rule` AS `rule` ON `rule`.`tax_calculation_rule_id` = main_table.tax_calculation_rule_id
    INNER JOIN `stnmg_tax_calculation_rate` AS `rate` ON rate.tax_calculation_rate_id = main_table.tax_calculation_rate_id
    LEFT JOIN `stnmg_tax_calculation_rate_title` AS `title_table` ON rate.tax_calculation_rate_id = title_table.tax_calculation_rate_id AND title_table.store_id = ‘1’ WHERE (customer_tax_class_id = 3) AND (product_tax_class_id IN (‘2’)) AND (rate.tax_country_id = ‘US’) AND (rate.tax_region_id IN(0, 44)) AND (rate.zip_is_range IS NOT NULL) AND (‘27713’ BETWEEN rate.zip_from AND rate.zip_to)) ORDER BY `priority` ASC, `tax_calculation_rule_id` ASC, `tax_country_id` DESC, `tax_region_id` DESC, `tax_postcode` DESC, `value` DESC

    Trace:
    #0 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘(SELECT `main_t…’, Array)
    #4 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘(SELECT `main_t…’, Array)
    #5 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
    #6 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Tax/Model/Resource/Calculation.php(358): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select))
    #7 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Tax/Model/Resource/Calculation.php(99): Mage_Tax_Model_Resource_Calculation->_getRates(Object(Varien_Object))
    #8 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Tax/Model/Calculation.php(282): Mage_Tax_Model_Resource_Calculation->getRateInfo(Object(Varien_Object))
    #9 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Catalog/Block/Product/View.php(148): Mage_Tax_Model_Calculation->getRate(Object(Varien_Object))
    #10 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/design/frontend/training-network/default/template/catalog/product/view.phtml(139): Mage_Catalog_Block_Product_View->getJsonConfig()
    #11 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(241): include(‘/var/www/vhosts…’)
    #12 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/traini…’)
    #13 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #14 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #15 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #16 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #17 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #18 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘content’, true)
    #19 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/design/frontend/training-network/default/template/page/1column.phtml(46): Mage_Core_Block_Abstract->getChildHtml(‘content’)
    #20 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(241): include(‘/var/www/vhosts…’)
    #21 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/traini…’)
    #22 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #23 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #24 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #25 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #26 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
    #27 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘no-route’)
    #28 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Cms/controllers/IndexController.php(75): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘no-route’)
    #29 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->noRouteAction()
    #30 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘noRoute’)
    #31 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #32 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #33 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #34 /var/www/vhosts/safetytrainingnetwork.com/httpdocs/store/index.php(83): Mage::run(”, ‘store’)
    #35 {main}

  • Rei says:

    Hi Andrew,

    First Congrats for the great job you are doing!

    I have this error that got my side down and can’t find a way to solved.

    a:5:{i:0;s:2816:”SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active`, IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) AS `include_in_menu`, `core_url_rewrite`.`request_path` FROM `catalog_category_entity` AS `e`
    INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = ’32’) AND `at_is_active_default`.`store_id` = 0
    LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = ’32’) AND (`at_is_active`.`store_id` = 1)
    INNER JOIN `catalog_category_entity_int` AS `at_include_in_menu_default` ON (`at_include_in_menu_default`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu_default`.`attribute_id` = ‘498’) AND `at_include_in_menu_default`.`store_id` = 0
    LEFT JOIN `catalog_category_entity_int` AS `at_include_in_menu` ON (`at_include_in_menu`.`entity_id` = `e`.`entity_id`) AND (`at_include_in_menu`.`attribute_id` = ‘498’) AND (`at_include_in_menu`.`store_id` = 1)
    LEFT JOIN `core_url_rewrite` ON (core_url_rewrite.category_id=e.entity_id) AND (core_url_rewrite.is_system=1 AND core_url_rewrite.store_id=’1′ AND core_url_rewrite.id_path LIKE ‘category/%’) WHERE (`e`.`entity_type_id` = ‘3’) AND (`e`.`entity_id` IN(‘7’, ‘8’, ‘9’, ’10’, ’11’, ’13’, ‘4’, ’50’, ’49’, ‘125’, ’51’, ’48’, ’18’, ’23’, ’24’, ’25’, ’26’, ’27’, ’28’, ’99’, ’52’, ’19’, ’29’, ’30’, ’31’, ’32’, ’33’, ’34’, ’44’, ‘100’, ’53’, ’15’, ’20’, ‘111’, ‘112’, ’21’, ‘113’, ‘114’, ’22’, ‘115’, ‘116’, ‘117’, ‘118’, ’16’, ‘101’, ‘103’, ‘102’, ‘104’, ’39’, ’37’, ’38’, ’54’, ’55’, ’56’, ’57’, ’58’, ’59’, ’60’, ’61’, ’62’, ’63’, ’64’, ’65’, ’66’, ’67’, ’68’, ’69’, ’70’, ’71’, ’72’, ’73’, ’74’, ’40’, ’41’, ’42’, ’43’, ’45’, ’97’, ’98’, ‘107’, ’75’, ’76’, ’77’, ’82’, ’84’, ’85’, ’86’, ’87’, ’88’, ’89’, ’90’, ’91’, ’92’, ’93’, ’94’, ’95’, ’96’, ‘105’, ‘106’, ‘119’, ‘108’, ‘109’, ‘110’, ‘120’, ‘121’, ‘122’, ‘123’, ‘124’, ‘126’, ‘127’, ‘128’, ‘129’, ‘130’, ‘131’, ‘132’, ‘133’, ‘134’, ‘135’, ‘137’, ‘136’, ‘138’, ‘139’, ‘140’, ‘141’, ’78’)) AND (`e`.`entity_id` NOT IN(’37’, ’38’, ’54’, ’55’, ’56’, ’57’, ’58’, ’59’, ’60’, ’61’, ’62’, ’63’, ’64’, ’65’, ’66’, ’67’, ’68’, ’69’, ’70’, ’71’, ’72’, ’73’, ’74’, ’75’, ’76’, ’77’, ’78’, ’82’, ’84’, ’85’, ’86’, ’87’, ’88’, ’89’, ’90’, ’91’, ’92’, ’93’, ’94’, ’95’, ’96’, ‘105’, ‘106’, ‘119’, ‘120’, ‘121’, ‘122’, ‘123’, ‘124’, ‘126’, ‘127’, ‘128’, ‘132’, ‘133’, ‘134’, ‘135’, ‘137’, ‘138’, ‘139’, ‘140’, ‘141’)) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = ‘1’) AND (IF(at_include_in_menu.value_id > 0, at_include_in_menu.value, at_include_in_menu_default.value) = ‘1’)

    “;i:1;s:6889:”#0 /home2/carolkt7/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /home2/carolkt7/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /home2/carolkt7/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /home2/carolkt7/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT `e`.*, I…’, Array)
    #4 /home2/carolkt7/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT `e`.*, I…’, Array)
    #5 /home2/carolkt7/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(‘SELECT `e`.*, I…’, Array)
    #6 /home2/carolkt7/public_html/lib/Varien/Data/Collection/Db.php(734): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT `e`.*, I…’, Array)
    #7 /home2/carolkt7/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1047): Varien_Data_Collection_Db->_fetchAll(‘SELECT `e`.*, I…’)
    #8 /home2/carolkt7/public_html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
    #9 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Model/Resource/Category/Collection.php(225): Mage_Eav_Model_Entity_Collection_Abstract->load(false, false)
    #10 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Model/Resource/Category/Tree.php(168): Mage_Catalog_Model_Resource_Category_Collection->load()
    #11 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Model/Resource/Category.php(576): Mage_Catalog_Model_Resource_Category_Tree->addCollectionData(NULL, false, ‘2’, true, true)
    #12 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Model/Category.php(818): Mage_Catalog_Model_Resource_Category->getCategories(‘2’, 0, false, false, true)
    #13 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Helper/Category.php(82): Mage_Catalog_Model_Category->getCategories(‘2’, 0, false, false, true)
    #14 /home2/carolkt7/public_html/app/code/core/Mage/Catalog/Model/Observer.php(217): Mage_Catalog_Helper_Category->getStoreCategories()
    #15 /home2/carolkt7/public_html/app/code/core/Mage/Core/Model/App.php(1338): Mage_Catalog_Model_Observer->addCatalogToTopmenuItems(Object(Varien_Event_Observer))
    #16 /home2/carolkt7/public_html/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Catalog_Model_Observer), ‘addCatalogToTop…’, Object(Varien_Event_Observer))
    #17 /home2/carolkt7/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘page_block_html…’, Array)
    #18 /home2/carolkt7/public_html/app/code/core/Mage/Page/Block/Html/Topmenu.php(74): Mage::dispatchEvent(‘page_block_html…’, Array)
    #19 /home2/carolkt7/public_html/app/design/frontend/default/theme577/template/page/html/topmenu.phtml(34): Mage_Page_Block_Html_Topmenu->getHtml(‘level-top’)
    #20 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home2/carolkt7…’)
    #21 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/defaul…’)
    #22 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #23 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #24 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #25 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #26 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #27 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘topMenu’, true)
    #28 /home2/carolkt7/public_html/app/design/frontend/default/theme577/template/page/html/header.phtml(85): Mage_Core_Block_Abstract->getChildHtml(‘topMenu’)
    #29 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home2/carolkt7…’)
    #30 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/defaul…’)
    #31 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #32 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #33 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #34 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘header’, true)
    #35 /home2/carolkt7/public_html/app/design/frontend/default/theme577/template/page/1column.phtml(42): Mage_Core_Block_Abstract->getChildHtml(‘header’)
    #36 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home2/carolkt7…’)
    #37 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/defaul…’)
    #38 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #39 /home2/carolkt7/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #40 /home2/carolkt7/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #41 /home2/carolkt7/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #42 /home2/carolkt7/public_html/app/code/core/Mage/Cms/Helper/Page.php(137): Mage_Core_Controller_Varien_Action->renderLayout()
    #43 /home2/carolkt7/public_html/app/code/core/Mage/Cms/Helper/Page.php(52): Mage_Cms_Helper_Page->_renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #44 /home2/carolkt7/public_html/app/code/core/Mage/Cms/controllers/IndexController.php(45): Mage_Cms_Helper_Page->renderPage(Object(Mage_Cms_IndexController), ‘home’)
    #45 /home2/carolkt7/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Cms_IndexController->indexAction()
    #46 /home2/carolkt7/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #47 /home2/carolkt7/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #48 /home2/carolkt7/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #49 /home2/carolkt7/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #50 /home2/carolkt7/public_html/index.php(87): Mage::run(”, ‘store’)
    #51 {main}”;s:3:”url”;s:1:”/”;s:11:”script_name”;s:10:”/index.php”;s:4:”skin”;s:7:”english”;}

    This is te result running magento-check.php
    Congratulations! Your server meets the requirements for Magento.

    You have PHP 5.2.0 (or greater)
    Safe Mode is off
    You have MySQL 4.1.20 (or greater)
    You have the curl extension
    You have the dom extension
    You have the gd extension
    You have the hash extension
    You have the iconv extension
    You have the mcrypt extension
    You have the pcre extension
    You have the pdo extension
    You have the pdo_mysql extension
    You have the simplexml extension

    Any help will be really appreciated.
    Regards,
    Rei

  • Hi Rei, The error seems to hit quite early when rendering the page, making lots of references to the menu and header includes. Have you made any changes to these files? If the site works when switching back to the default theme, it would suggest it was a theme issue and not the database.

  • Did this error appear when trying to update Magento? You could try adding the missing column ‘rule.calculate_subtotal’, but if the upgrade failed via the downloader, it might be safer to finish the upgrade manually. e.g. copying the latest Magento core files, calling in your current database and then adding your theme, plugin, media files.

  • Are you moving your current Magento site or setting up one from scratch? ‘magento.core_store’ is one of the main Magento tables, suggesting that something is a miss with the set up. If you’re just starting out I’d suggest starting the installation again.

  • troy says:

    hey andrew please help me i tried all steps now i get the specific error

    SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘herbali6_mage886.mg_cmsmart_promotionproduct’ doesn’t exist, query was: SELECT `main_table`.* FROM `mg_cmsmart_promotionproduct` AS `main_table` WHERE (`product_id` = ‘0’)

    Trace:
    #0 /home/herbali6/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /home/herbali6/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /home/herbali6/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /home/herbali6/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT `main_ta…’, Array)
    #4 /home/herbali6/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT `main_ta…’, Array)
    #5 /home/herbali6/public_html/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query(‘SELECT `main_ta…’, Array)
    #6 /home/herbali6/public_html/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract->fetchAll(‘SELECT `main_ta…’, Array)
    #7 /home/herbali6/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(521): Varien_Data_Collection_Db->_fetchAll(‘SELECT `main_ta…’, Array)
    #8 /home/herbali6/public_html/app/code/local/Cmsmart/Promotion/Model/Adminhtml/Observer.php(38): Mage_Core_Model_Resource_Db_Collection_Abstract->getData()
    #9 /home/herbali6/public_html/app/code/core/Mage/Core/Model/App.php(1357): Cmsmart_Promotion_Model_Adminhtml_Observer->catalog_product_save_after(Object(Varien_Event_Observer))
    #10 /home/herbali6/public_html/app/code/core/Mage/Core/Model/App.php(1336): Mage_Core_Model_App->_callObserverMethod(Object(Cmsmart_Promotion_Model_Adminhtml_Observer), ‘catalog_product…’, Object(Varien_Event_Observer))
    #11 /home/herbali6/public_html/app/Mage.php(448): Mage_Core_Model_App->dispatchEvent(‘catalog_product…’, Array)
    #12 /home/herbali6/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(671): Mage::dispatchEvent(‘catalog_product…’, Array)
    #13 /home/herbali6/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(725): Mage_Adminhtml_Catalog_ProductController->_initProductSave()
    #14 /home/herbali6/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->saveAction()
    #15 /home/herbali6/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘save’)
    #16 /home/herbali6/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #17 /home/herbali6/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #18 /home/herbali6/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #19 /home/herbali6/public_html/index.php(83): Mage::run(”, ‘store’)
    #20 {main}

  • Hi Troy,

    This appears to relate to a cmsmart promotion product plugin. Are you able to disable this via the Magento admin, to get the site running again?

  • Pooja says:

    Hi, my frontend and even backend of magento or not working.As you told i have done the changes in my cpanel but still im getting this errors.Plz help me to solve this problem.Thanks in advace and waiting for your reply

    SQLSTATE[HY000] [1045] Access denied for user ‘printurg_mage597’@’localhost’ (using password: YES)

    Trace:
    #0 /home/printurg/public_html/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
    #1 /home/printurg/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect()
    #2 /home/printurg/public_html/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect()
    #3 /home/printurg/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SET NAMES utf8’, Array)
    #4 /home/printurg/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query(‘SET NAMES utf8’, Array)
    #5 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query(‘SET NAMES utf8’)
    #6 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection(‘pdo_mysql’, Object(Mage_Core_Model_Config_Element))
    #7 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection(‘core_write’)
    #8 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection(‘write’)
    #9 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
    #10 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
    #11 /home/printurg/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection()
    #12 /home/printurg/public_html/app/code/core/Mage/Core/Model/Config.php(1348): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
    #13 /home/printurg/public_html/app/code/core/Mage/Core/Model/Config.php(1380): Mage_Core_Model_Config->getModelInstance(‘core_resource/w…’, Object(Mage_Core_Model_Resource_Website))
    #14 /home/printurg/public_html/app/Mage.php(491): Mage_Core_Model_Config->getResourceModelInstance(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #15 /home/printurg/public_html/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #16 /home/printurg/public_html/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection()
    #17 /home/printurg/public_html/app/code/core/Mage/Core/Model/App.php(619): Mage_Core_Model_Abstract->getCollection()
    #18 /home/printurg/public_html/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores()
    #19 /home/printurg/public_html/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore(”, ‘store’)
    #20 /home/printurg/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #21 /home/printurg/public_html/index.php(83): Mage::run(”, ‘store’)
    #22 {main}

  • Pooja says:

    Hi Andrew ,

    Plz help me out in solving the above issue which i have posted,Still my site i m getting the error.

  • Kumar says:

    Hi Andrew, Hope your are doing good,

    Please have a look on below errors, let me know your expert advice, thank you in advance 🙂

    Trace:
    #0 /home4/zlbata/public_html/reliant/reliant/lib/Credis/Client.php(362): Credis_Client->connect()
    #1 /home4/zlbata/public_html/reliant/reliant/lib/Credis/Client.php(447): Credis_Client->connect()
    #2 /home4/zlbata/public_html/reliant/reliant/lib/Credis/Client.php(440): Credis_Client->__call(‘select’, Array)
    #3 /home4/zlbata/public_html/reliant/reliant/lib/Cm/Cache/Backend/Redis.php(117): Credis_Client->select(0)
    #4 /home4/zlbata/public_html/reliant/reliant/lib/Zend/Cache.php(153): Cm_Cache_Backend_Redis->__construct(Array)
    #5 /home4/zlbata/public_html/reliant/reliant/lib/Zend/Cache.php(94): Zend_Cache::_makeBackend(‘Mage_Cache_Back…’, Array, true, true)
    #6 /home4/zlbata/public_html/reliant/reliant/app/code/core/Mage/Core/Model/Cache.php(137): Zend_Cache::factory(‘Varien_Cache_Co…’, ‘Mage_Cache_Back…’, Array, Array, true, true, true)
    #7 /home4/zlbata/public_html/reliant/reliant/app/code/core/Mage/Core/Model/Config.php(1348): Mage_Core_Model_Cache->__construct(Array)
    #8 /home4/zlbata/public_html/reliant/reliant/app/Mage.php(462): Mage_Core_Model_Config->getModelInstance(‘core/cache’, Array)
    #9 /home4/zlbata/public_html/reliant/reliant/app/code/core/Mage/Core/Model/App.php(401): Mage::getModel(‘core/cache’, Array)
    #10 /home4/zlbata/public_html/reliant/reliant/app/code/core/Mage/Core/Model/App.php(295): Mage_Core_Model_App->_initCache(Array)
    #11 /home4/zlbata/public_html/reliant/reliant/app/code/core/Mage/Core/Model/App.php(337): Mage_Core_Model_App->baseInit(Array)
    #12 /home4/zlbata/public_html/reliant/reliant/app/Mage.php(683): Mage_Core_Model_App->run(Array)
    #13 /home4/zlbata/public_html/reliant/reliant/index.php(71): Mage::run(”, ‘store’)
    #14 {main}

  • Ayoub sadrafe says:

    please help on this problem

    There has been an error processing your request
    Le fichier image n’a pas été trouvé.

    Trace:
    #0 /home3/casamall/public_html/app/code/core/Mage/Catalog/Helper/Image.php(166): Mage_Catalog_Model_Product_Image->setBaseFile(‘/t/e/tenda-150-…’)
    #1 /home3/casamall/public_html/app/design/frontend/ma_mozar/ma_mozar1/template/catalog/product/list.phtml(143): Mage_Catalog_Helper_Image->init(Object(Mage_Catalog_Model_Product), ‘rotator_image’)
    #2 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home3/casamall…’)
    #3 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_moz…’)
    #4 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #5 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #6 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #7 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘product_list’, true)
    #8 /home3/casamall/public_html/app/code/core/Mage/Catalog/Block/Category/View.php(90): Mage_Core_Block_Abstract->getChildHtml(‘product_list’)
    #9 /home3/casamall/public_html/app/design/frontend/ma_mozar/ma_mozar1/template/catalog/category/view.phtml(70): Mage_Catalog_Block_Category_View->getProductListHtml()
    #10 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home3/casamall…’)
    #11 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_moz…’)
    #12 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #13 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #14 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #15 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #16 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #17 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘content’, true)
    #18 /home3/casamall/public_html/app/design/frontend/ma_mozar/ma_mozar1/template/page/2columns-right.phtml(70): Mage_Core_Block_Abstract->getChildHtml(‘content’)
    #19 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home3/casamall…’)
    #20 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_moz…’)
    #21 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #22 /home3/casamall/public_html/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #23 /home3/casamall/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #24 /home3/casamall/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #25 /home3/casamall/public_html/app/code/local/Magentothem/Layerednavigationajax/controllers/CategoryController.php(127): Mage_Core_Controller_Varien_Action->renderLayout()
    #26 /home3/casamall/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Magentothem_Layerednavigationajax_CategoryController->viewAction()
    #27 /home3/casamall/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘view’)
    #28 /home3/casamall/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #29 /home3/casamall/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #30 /home3/casamall/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #31 /home3/casamall/public_html/index.php(87): Mage::run(”, ‘store’)
    #32 {main}

    Error log record number: 999295480271

  • Tinku says:

    Hi,
    I am facing some problem in the back-end. New customer is not able to sign up in my website.
    It is showing following below errors when I am trying to view the customer details from back-end:

    There has been an error processing your request
    Exception printing is disabled by default for security reasons.

    Error log record number: 952153948670

    Can anyone help me out regarding this issue plz?
    Thanks in advance.

    Regards
    Tinku Kumar

  • Hi Tinku,

    You’ll need to follow the steps in the article to find the specific error message. There were changes to the Magento registration page template, that caused the form not to be submitted (Magento 1.9.2.2 adds a hidden form field). Did you recently update your Magento site? If so you’ll need to compare your theme’s version of the registration files, with the defaults found here;
    app/design/frontend/base/default/template/customer/form/register.phtml
    app/design/frontend/base/default/template/persistent/customer/form/register.phtml

    Thanks

    Andrew

  • Yogesh says:

    Plz Andrew sir help on me on this error …!!
    There has been an error processing your request

    SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

    Trace:
    #0 /opt/lampp/htdocs/magento_2/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
    #1 /opt/lampp/htdocs/magento_2/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
    #2 /opt/lampp/htdocs/magento_2/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
    #3 /opt/lampp/htdocs/magento_2/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(‘SELECT `catalog…’, Array)
    #4 /opt/lampp/htdocs/magento_2/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query(‘SELECT `catalog…’, Array)
    #5 /opt/lampp/htdocs/magento_2/lib/Zend/Db/Adapter/Abstract.php(756): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
    #6 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Eav/Model/Entity/Abstract.php(943): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
    #7 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Catalog/Model/Resource/Abstract.php(698): Mage_Eav_Model_Entity_Abstract->load(Object(Mage_Catalog_Model_Product), Array, NULL)
    #8 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Catalog_Model_Resource_Abstract->load(Object(Mage_Catalog_Model_Product), Array, NULL)
    #9 /opt/lampp/htdocs/magento_2/app/code/local/BuyX/GetY/controllers/Frontend/Checkout/CartController.php(27): Mage_Core_Model_Abstract->load(Array)
    #10 /opt/lampp/htdocs/magento_2/app/code/local/BuyX/GetY/controllers/Frontend/Checkout/CartController.php(11): BuyX_GetY_Frontend_Checkout_CartController->buyXgetYfree()
    #11 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Core/Controller/Varien/Action.php(418): BuyX_GetY_Frontend_Checkout_CartController->indexAction()
    #12 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘index’)
    #13 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #14 /opt/lampp/htdocs/magento_2/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #15 /opt/lampp/htdocs/magento_2/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #16 /opt/lampp/htdocs/magento_2/index.php(87): Mage::run(”, ‘store’)
    #17 {main}

  • Anil says:

    Hi Andrew,

    Please have a look on below errors,
    I have changed the local.xml.sample to local.xml and pointed change_dir => ‘tmp/’ .I have created tmp folder on magneto root ….let me know your expert advice for solve this problem.

    Trace:
    #0 /home/webaspiration/public_html/furmito/app/code/core/Mage/Catalog/Helper/Image.php(166): Mage_Catalog_Model_Product_Image->setBaseFile(‘/i/m/img048.jpg’)
    #1 /home/webaspiration/public_html/furmito/app/code/community/Cloudinary/Cloudinary/Helper/Image.php(31): Mage_Catalog_Helper_Image->init(Object(Mage_Catalog_Model_Product), ‘rotator_image’, NULL)
    #2 /home/webaspiration/public_html/furmito/app/design/frontend/ma_vanese/ma_vanesa6/template/catalog/product/list.phtml(164): Cloudinary_Cloudinary_Helper_Image->init(Object(Mage_Catalog_Model_Product), ‘rotator_image’)
    #3 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/webaspira…’)
    #4 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_van…’)
    #5 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #6 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #7 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #8 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘product_list’, true)
    #9 /home/webaspiration/public_html/furmito/app/code/core/Mage/Catalog/Block/Category/View.php(90): Mage_Core_Block_Abstract->getChildHtml(‘product_list’)
    #10 /home/webaspiration/public_html/furmito/app/design/frontend/ma_vanese/ma_vanesa6/template/catalog/category/view.phtml(70): Mage_Catalog_Block_Category_View->getProductListHtml()
    #11 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/webaspira…’)
    #12 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_van…’)
    #13 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #14 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #15 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
    #16 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml()
    #17 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml()
    #18 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml(‘content’, true)
    #19 /home/webaspiration/public_html/furmito/app/design/frontend/ma_vanese/ma_vanesa6/template/page/2columns-left.phtml(54): Mage_Core_Block_Abstract->getChildHtml(‘content’)
    #20 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(241): include(‘/home/webaspira…’)
    #21 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView(‘frontend/ma_van…’)
    #22 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
    #23 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template->_toHtml()
    #24 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
    #25 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
    #26 /home/webaspiration/public_html/furmito/app/code/local/Magentothem/Layerednavigationajax/controllers/CategoryController.php(127): Mage_Core_Controller_Varien_Action->renderLayout()
    #27 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Magentothem_Layerednavigationajax_CategoryController->viewAction()
    #28 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘view’)
    #29 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #30 /home/webaspiration/public_html/furmito/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #31 /home/webaspiration/public_html/furmito/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #32 /home/webaspiration/public_html/furmito/index.php(87): Mage::run(”, ‘store’)
    #33 {main}

    Error log record number: 456518366289

  • jaydev says:

    Hi Andrew,

    I have tried all steps suggested by you.

    Now I am not able to go system > cache management or Index Management. It shows me same error here also

    Thanking you

    Jaydev

  • Hi,

    You’ll need to use one of the methods above (exception logs or local.xml) to find out the real error message. This will then allow you to debug what the issue is.

    Thanks

    Andrew

  • Amit says:

    Hello Andrew,
    While open any product in magento 1.9.1 it shows following error:

    There has been an error processing your request Exception printing is disabled by default for security reasons. Error log record number: 1252009338864
    after enable both use flat catalog category and use flat catalog product.
    How to fix it.

  • Hi Amit, You’ll need to enable error logs to reveal your full error message.
    Thanks, Andrew

  • priyanka says:

    Hi ,

    I am getting below error code on my website .please help .

    he PDO extension is required for this adapter but the extension is not loaded

    Trace:
    #0 /home/hansa321/public_html/lib/Zend/Db/Adapter/Abstract.php(248): Zend_Db_Adapter_Pdo_Abstract->setFetchMode(2)
    #1 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource.php(175): Zend_Db_Adapter_Abstract->__construct(Array)
    #2 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection(‘pdo_mysql’, Object(Mage_Core_Model_Config_Element))
    #3 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection(‘core_write’)
    #4 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection(‘write’)
    #5 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
    #6 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
    #7 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection()
    #8 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Config.php(1354): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
    #9 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Config.php(1386): Mage_Core_Model_Config->getModelInstance(‘core_resource/w…’, Object(Mage_Core_Model_Resource_Website))
    #10 /home/hansa321/public_html/app/Mage.php(491): Mage_Core_Model_Config->getResourceModelInstance(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #11 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel(‘core/website_co…’, Object(Mage_Core_Model_Resource_Website))
    #12 /home/hansa321/public_html/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection()
    #13 /home/hansa321/public_html/app/code/core/Mage/Core/Model/App.php(619): Mage_Core_Model_Abstract->getCollection()
    #14 /home/hansa321/public_html/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores()
    #15 /home/hansa321/public_html/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore(”, ‘store’)
    #16 /home/hansa321/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #17 /home/hansa321/public_html/index.php(83): Mage::run(”, ‘store’)
    #18 {main}

  • Hi,

    Have you tried adding the following to your php.ini file;

    extension=pdo.so
    extension=pdo_sqlite.so
    extension=sqlite.so
    extension=pdo_mysql.so

    http://stackoverflow.com/questions/17440781/how-to-fix-this-error-in-magento

  • Giro says:

    Hello Andrew

    I am getting error code on my website, please help me:

    There has been an error processing your request
    Error in file: “C:\xampp\htdocs\magento\app\code\core\Mage\Sales\sql\sales_setup\install-1.6.0.0.php” – SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘sales_flat_order’ already exists

    Trace:
    #0 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
    #1 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(421): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘install’, ”, ‘1.6.0.8’)
    #2 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(327): Mage_Core_Model_Resource_Setup->_installResourceDb(‘1.6.0.8’)
    #3 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
    #4 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
    #5 C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\App.php(343): Mage_Core_Model_App->_initModules()
    #6 C:\xampp\htdocs\magento\app\Mage.php(683): Mage_Core_Model_App->run(Array)
    #7 C:\xampp\htdocs\magento\index.php(87): Mage::run(”, ‘store’)
    #8 {main}

    Error log record number: 1267479449

  • Hi,

    The most common cause of ‘Base table or view already exist’ is when an install has only partially completed. The installation then tries to run again from the start but finds that the database tables it is trying to create are already there.

    To move beyond this error you can drop/delete the table within phpMyAdmin (make a backup first), or alter the command in that installation file so it drops or ignores that function if the table already exists.

    If this is a clean install, it would be better to drop the whole Magento database and start over.

  • zeeshan khan says:

    Hi, i am confronting with same issue that most of the people are facing in this article, i have tried all the possible solution for this issue but have failed miserably can you please guide me, as too what can be done?

    Source model “ves_brand/system_config_source_ListBrand” not found for attribute “vesbrand”

    Trace:
    #0 /home/letsbuyit/public_html/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(387): Mage::exception(‘Mage_Eav’, ‘Source model “v…’)
    #1 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Form.php(201): Mage_Eav_Model_Entity_Attribute_Abstract->getSource()
    #2 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Attributes.php(70): Mage_Adminhtml_Block_Widget_Form->_setFieldset(Array, Object(Varien_Data_Form_Element_Fieldset), Array)
    #3 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/Block/Widget/Form.php(144): Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Attributes->_prepareForm()
    #4 /home/letsbuyit/public_html/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Adminhtml_Block_Widget_Form->_beforeToHtml()
    #5 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tabs.php(79): Mage_Core_Block_Abstract->toHtml()
    #6 /home/letsbuyit/public_html/app/code/core/Mage/Core/Block/Abstract.php(293): Mage_Adminhtml_Block_Catalog_Product_Edit_Tabs->_prepareLayout()
    #7 /home/letsbuyit/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(IWD_SalesRepresentative_Model_Core_Layout))
    #8 /home/letsbuyit/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock(‘adminhtml/catal…’, ‘product_tabs’)
    #9 /home/letsbuyit/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock(‘adminhtml/catal…’, ‘product_tabs’)
    #10 /home/letsbuyit/public_html/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))
    #11 /home/letsbuyit/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #12 /home/letsbuyit/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
    #13 /home/letsbuyit/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #14 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(Array, true, true)
    #15 /home/letsbuyit/public_html/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(250): Mage_Adminhtml_Controller_Action->loadLayout(Array)
    #16 /home/letsbuyit/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->editAction()
    #17 /home/letsbuyit/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch(‘edit’)
    #18 /home/letsbuyit/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #19 /home/letsbuyit/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
    #20 /home/letsbuyit/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #21 /home/letsbuyit/public_html/index.php(83): Mage::run(”, ‘store’)
    #22 {main}

    Error log record number: 464971285436

    it is problematic, we are unable to open products.

    thanks

  • sachin says:

    Hi, i have same issue that most of the people are facing, i have tried all the possible solution for this issue but have not working for me, please help me to solve this issue ?

    Trace:
    #0 /home/reinforc/public_html/shopers/app/code/core/Mage/Eav/Model/Entity/Attribute/Abstract.php(387): Mage::exception(‘Mage_Eav’, ‘Source model “M…’)
    #1 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/Block/Widget/Form.php(201): Mage_Eav_Model_Entity_Attribute_Abstract->getSource()
    #2 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tab/Attributes.php(70): Mage_Adminhtml_Block_Widget_Form->_setFieldset(Array, Object(Varien_Data_Form_Element_Fieldset), Array)
    #3 /home/reinforc/public_html/shopers/app/code/core/Mage/Bundle/Block/Adminhtml/Catalog/Product/Edit/Tab/Attributes.php(44): Mage_Adminhtml_Block_Catalog_Product_Edit_Tab_Attributes->_prepareForm()
    #4 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/Block/Widget/Form.php(144): Mage_Bundle_Block_Adminhtml_Catalog_Product_Edit_Tab_Attributes->_prepareForm()
    #5 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Adminhtml_Block_Widget_Form->_beforeToHtml()
    #6 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/Block/Catalog/Product/Edit/Tabs.php(79): Mage_Core_Block_Abstract->toHtml()
    #7 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Block/Abstract.php(293): Mage_Adminhtml_Block_Catalog_Product_Edit_Tabs->_prepareLayout()
    #8 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
    #9 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock(‘adminhtml/catal…’, ‘product_tabs’)
    #10 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock(‘adminhtml/catal…’, ‘product_tabs’)
    #11 /home/reinforc/public_html/shopers/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))
    #12 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
    #13 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
    #14 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
    #15 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(Array, true, true)
    #16 /home/reinforc/public_html/shopers/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(250): Mage_Adminhtml_Controller_Action->loadLayout(Array)
    #17 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_Catalog_ProductController->editAction()
    #18 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(‘edit’)
    #19 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
    #20 /home/reinforc/public_html/shopers/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
    #21 /home/reinforc/public_html/shopers/app/Mage.php(684): Mage_Core_Model_App->run(Array)
    #22 /home/reinforc/public_html/shopers/index.php(87): Mage::run(”, ‘store’)
    #23 {main}

  • Rajesh Verma says:

    Dear Andrew,

    Please help me today morning when i check my site i found message error printing-disabled and after check on google i found your help for this error as per your instruction i change my lib/zend/cache/backend/file.php and also create tmp directory in magento root files. but still have same arror and after change local.xml.sample to local.xml i am getting error 500.

    please intimate to me how i can solve this prob.

    waiting for you reply hope you will intimate me asap.

    sorry for wrong english

    thanks
    RAjesh

  • Jane Smith says:

    This article benefits anyone facing the frustrating “Exception printing is disabled by default for security reasons” error in Magento. The step-by-step solutions provided are clear and easy to follow, making the troubleshooting process much more manageable. Thanks for shedding light on this common issue and providing multiple ways to resolve it!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.