magento : exception printing is disabled by default for security reasons

Question

I am currently using Magento version 1.7.0.2_2. While installing it's showing following errors:

Exception printing is disabled by default for security reasons.

Error log record number: 1970080033

Error in file says:

a:5:{i:0;s:206:"Error in file: 
"D:\websites\magento\app\code\core\Mage\SalesRule\sql\salesrule_setup\upgrade-1.6.0.0-1.6.0.1.php" - SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'period'"
;i:1;s:930:"
#0 D:\websites\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 D:\websites\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.0.0', '1.6.0.3')
#2 D:\websites\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.0.0', '1.6.0.3')
#3 D:\websites\magento\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 D:\websites\magento\app\code\core\Mage\Core\Model\App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 D:\websites\magento\app\code\core\Mage\Core\Model\App.php(343): Mage_Core_Model_App->_initModules()
#6 D:\websites\magento\app\Mage.php(683): Mage_Core_Model_App->run(Array)
#7 D:\websites\magento\index.php(87): Mage::run('', 'store')
#8 {main}"
;s:3:"url";s:9:"/magento/";s:11:"script_name";s:18:"/magento/index.php";s:4:"skin";s:7:"default";}

p.s.: however each time it shows a different error record number

Answer 1

You can enable printing errors by renaming file local.xml.sample to local.xml. file location magentoRootDirectory/errors/

Answer 2

Magento install error - Exception printing is disabled

Here is a known error which can occur when installing Magento: There has been an error processing your request Exception printing is disabled by default for security reasons. Error log record number: XXXXXXXXXXXXXXX

Here is the solution:

• Navigate to the "errors" folder.
• Change local.xml.sample to local.xml
• You should now see a new list of crazy errors all over the Magento page - this is okay.

• Open magento/lib/Zend/Cache/Backend/File.php and look for:

  protected $_options = array(
  'cache_dir' => 'null',
  

• Change it to:

  protected $_options = array(
  'cache_dir' => 'tmp/',
  

• Save it.
• Now the final step is to go create a tmp folder in the root Magento folder.
• That's it.