Try the Demo

Magento Forum

   
There has been an error processing your request
 
tashitobgay
Jr. Member
 
Total Posts:  1
Joined:  2012-12-31
 

I’m getting following error while installing magento:

Error in file: “C:\xampp\htdocs\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’

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(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘1.6.0.0’, ‘1.6.0.3’)
#2 C:\xampp\htdocs\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 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}

Can anyone please help me out on this?. Thank You

 
Magento Community Magento Community
Magento Community
Magento Community
 
Template fans
Guru
 
Total Posts:  434
Joined:  2009-11-02
 

Try to replace in the file magento\app\code\core\Mage\SalesRule\sql\salesrule_setup\install-1.6.0.0.fp
lines 333-335:

-> addColumn (’period’, Varien_Db_Ddl_Table :: TYPE_DATE, null, array (
‘nullable’ => false,
), ‘Period’)

on

-> addColumn (’period’, Varien_Db_Ddl_Table :: TYPE_DATE, null, array (
‘nullable’ => true,
), ‘Period’)

 Signature 

Magento Themes or VirtueMart Templates, which should I choose?

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