Magento Forum

   
Magento Admin Problem
 
tannaltd
Jr. Member
 
Total Posts:  2
Joined:  2010-07-09
 

I moved Magento from one host to another (using cPanel) and in the admin everytime I go to login now, I get this:

Invalid yearit must be between -10000 and 10000

Trace
:
#0 /home/dailypow/public_html/app/code/core/Zend/Date.php(2671): Zend_Date->mktime('08', '29', '52', 1, 27, 292277022657, false)
#1 /home/dailypow/public_html/app/code/core/Zend/Date.php(1091): Zend_Date->_calculate('set', '-292277022657-0...', NULL, NULL)
#2 /home/dailypow/public_html/app/code/core/Mage/Reports/Model/Resource/Report/Abstract.php(418): Zend_Date->set('-292277022657-0...')
#3 /home/dailypow/public_html/app/code/core/Mage/Reports/Model/Resource/Report/Abstract.php(363): Mage_Reports_Model_Resource_Report_Abstract->_getTZOffsetTransitions('Etc/GMT+5', Object(Zend_Date), Object(Zend_Date))
#4 /home/dailypow/public_html/app/code/core/Mage/Reports/Model/Resource/Order/Collection.php(252): Mage_Reports_Model_Resource_Report_Abstract->getStoreTZOffsetQuery('sales_flat_orde...', 'created_at', Object(Zend_Date), Object(Zend_Date))
#5 /home/dailypow/public_html/app/code/core/Mage/Reports/Model/Resource/Order/Collection.php(132): Mage_Reports_Model_Resource_Order_Collection->_getTZRangeOffset[removed]'24h', 'created_at', Object(Zend_Date), Object(Zend_Date))
#6 /home/dailypow/public_html/app/code/core/Mage/Reports/Model/Resource/Order/Collection.php(79): Mage_Reports_Model_Resource_Order_Collection->_prepareSummaryLive('24h', 0, 0, false)
#7 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Helper/Dashboard/Order.php(42): Mage_Reports_Model_Resource_Order_Collection->prepareSummary('24h', 0, 0, false)
#8 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Helper/Dashboard/Abstract.php(54): Mage_Adminhtml_Helper_Dashboard_Order->_initCollection()
#9 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Helper/Dashboard/Abstract.php(68): Mage_Adminhtml_Helper_Dashboard_Abstract->getCollection()
#10 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Helper/Dashboard/Abstract.php(73): Mage_Adminhtml_Helper_Dashboard_Abstract->getItems()
#11 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard/Abstract.php(51): Mage_Adminhtml_Helper_Dashboard_Abstract->getCount()
#12 /home/dailypow/public_html/app/design/adminhtml/default/default/template/dashboard/graph.phtml(60): Mage_Adminhtml_Block_Dashboard_Abstract->getCount()
#13 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/dailypow/...')
#14 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...')
#15 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#16 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml()
#17 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Adminhtml_Block_Template->_toHtml()
#18 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard/Diagrams.php(49): Mage_Core_Block_Abstract->toHtml()
#19 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Dashboard_Diagrams->_prepareLayout()
#20 /home/dailypow/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#21 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Block/Dashboard.php(66): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...')
#22 /home/dailypow/public_html/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Adminhtml_Block_Dashboard->_prepareLayout()
#23 /home/dailypow/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#24 /home/dailypow/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('adminhtml/dashb...', 'dashboard')
#25 /home/dailypow/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('adminhtml/dashb...', 'dashboard')
#26 /home/dailypow/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))
#27 /home/dailypow/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#28 /home/dailypow/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#29 /home/dailypow/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#30 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(275): Mage_Core_Controller_Varien_Action->loadLayout(NULL, true, true)
#31 /home/dailypow/public_html/app/code/core/Mage/Adminhtml/controllers/DashboardController.php(40): Mage_Adminhtml_Controller_Action->loadLayout()
#32 /home/dailypow/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_DashboardController->indexAction()
#33 /home/dailypow/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#34 /home/dailypow/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#35 /home/dailypow/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#36 /home/dailypow/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#37 /home/dailypow/public_html/index.php(87): Mage::run('', 'store')
#38 {main}

 
Magento Community Magento Community
Magento Community
Magento Community
 
tannaltd
Jr. Member
 
Total Posts:  2
Joined:  2010-07-09
 

Managed to fix the issue, by going into the SQL and changing the timezone from ETC/GMT+5 to America/New_York

 
Magento Community Magento Community
Magento Community
Magento Community
 
iyahtech
Jr. Member
 
Total Posts:  1
Joined:  2013-02-28
 

Can you be a little more specific ? Where did you change that value ?

I tried to change it in the table “core_config_data” in “config_id 8” but it did not solve the issue.

 
Magento Community Magento Community
Magento Community
Magento Community
 
GoMageTeam
Guru
 
Avatar
Total Posts:  356
Joined:  2013-01-13
Warsaw, Poland
 

Hello,

You can update the time zone using the direct SQL request in phpMyAdmin:

UPDATE `core_config_dataSET `value` = 'America/New_York' WHERE `path` = 'general/locale/timezone'

 
Magento Community Magento Community
Magento Community
Magento Community
 
natron
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2008-06-13
 

I tried the same fix.  I ran the sql query and manually tried to fix the time zone issue.  I manually cleared my Magento cache and manually ran the database indexer and neither worked for me. 

Anything else?

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