Try the Demo

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
Sr. Member
 
Avatar
Total Posts:  154
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'

 Signature 

Bronze Partner of Magento
• A high-leveled development company – Providing easy, comfortable and useful Magento extensions
• The supporters of qualified and fast service. Find out more here: http://www.gomage.com

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