Magento: Admin login not working for main admin login

Question

My main admin login is not working though sub-admin are working well.

Error produce: I have created few sites and store views as well as few sub-admin with limited access. I deleted a website from admin and after that admin login display below error message. Other sub-admin can login to admin of site but Main administartor is not able to login to admin.

Error message:

There has been an error processing your request Invalid website id requested.

Trace: 0 /app/code/core/Mage/Core/Model/App.php(950): Mage::exception('Mage_Core', 'Invalid website...') 1 /app/code/core/Mage/Core/Model/Store.php(465): Mage_Core_Model_App->getWebsite('3') 2 /app/code/core/Mage/Tax/Block/Adminhtml/Notifications.php(150): Mage_Core_Model_Store->getWebsite() 3 /app/design/adminhtml/default/default/template/tax/notifications.phtml(31): Mage_Tax_Block_Adminhtml_Notifications->getWebsitesWithWrongDiscountSettings() 4 /app/code/core/Mage/Core/Block/Template.php(241): include('/home/develop/d...') 5 /app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') 6 /app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() 7 /app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() 8 /app/code/core/Mage/Tax/Block/Adminhtml/Notifications.php(196): Mage_Adminhtml_Block_Template->_toHtml() 9 /app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Tax_Block_Adminhtml_Notifications->_toHtml() 10 /app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() 11 /app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List->_toHtml() 12 /app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract->toHtml() 13 /app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract->_getChildHtml('notifications', true) 14 /app/design/adminhtml/default/default/template/page.phtml(55): Mage_Core_Block_Abstract->getChildHtml('notifications') 15 /app/code/core/Mage/Core/Block/Template.php(241): include('/home/develop/d...') 16 /app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('adminhtml/defau...') 17 /app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() 18 /app/code/core/Mage/Adminhtml/Block/Template.php(81): Mage_Core_Block_Template->_toHtml() 19 /app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Adminhtml_Block_Template->_toHtml() 20 /app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() 21 /app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() 22 /app/code/core/Mage/Adminhtml/controllers/DashboardController.php(43): Mage_Core_Controller_Varien_Action->renderLayout() 23 /app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Adminhtml_DashboardController->indexAction() 24 /app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index') 25 /app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) 26 /app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() 27 /app/Mage.php(684): Mage_Core_Model_App->run(Array) 28 /index.php(90): Mage::run('', 'store') 29 {main}

How to fix this issue. Urgent help required.

Answer 1

I sorted out this error as:

1. Go to the database tables: core_website, core_store and core_store_group
2. First look for website_id attribute in table core_website and delete that website id from this.
3. Repeat same in tables: core_store and core_store_group.

You can see your website id number in error page. ie getWebsite('3'). Here '3' is website id number

---

Above solution works well if you delete Website ID but if you remove stores (not store view because that deleted with store automatically) from under main website then this solution doesn’t work.

For that you need go to table cms_page_store and delete rows related store_views those are deleted.

SQL: DELETE FROM cms_page_store WHERE store_id NOT IN (SELECT store_id FROM core_store)

Explanation:

You can check your store_view ids in admin->system->manage stores. All CMS pages should be assoicated with these id. If there is any extra/other id is in table cms_page_store field 'store_d' then 404 error will display.

Answer 2

Moving Magento from your Subdomain to your Main Domain (and vice versa): All you need to do is to follow the following steps:-

Step File: Go to your File Manager and click "Select All". Click "Move" and key in "/public_html" to move it to the main domain's directory. You may need to clear the caches at "var/cache" and "var/session" after you have moved all files over.

Step Admin:

Go to Magento Admin --> System --> Configurations --> Web --> Unsecure URL & Secure URL.

Change both the Secure URL and Unsecure URL to the domain that you are going to be moved to. Be sure to include the "/" at the end of the domain name.

Step DataBase:

##Must Be take Backup before do it
TRUNCATE TABLE dataflow_batch_export;
TRUNCATE TABLE dataflow_batch_import;
TRUNCATE TABLE log_customer;
TRUNCATE TABLE log_quote;
TRUNCATE TABLE log_summary;
TRUNCATE TABLE log_summary_type;
TRUNCATE TABLE log_url;
TRUNCATE TABLE log_url_info;
TRUNCATE TABLE log_visitor;
TRUNCATE TABLE log_visitor_info;
TRUNCATE TABLE log_visitor_online;
TRUNCATE TABLE report_event;
TRUNCATE TABLE  log_customer;
TRUNCATE TABLE  log_quote;

You can also perform the Step Admin above through the database instead of going through the Magento admin:- Go to phpMyAdmin. Find and click your Magento database from the list of the left bar. Scroll down and look for core_config_data. Click "Browse" (the first button at the side). Find the path "web/unsecure/base_url" and "web/secure/base_url". Click on the "Pencil" icon of both of the path above and edit the URLs accordingly (one path at a time). Click "Go" after the URLs have been edited.

Note:- It is advisable to backup your files and databases before performing the above stated steps.

If hosting problem you may take help: https://forum.mediatemple.net/topic/2286-help-with-magento-2nd-store-on-subdomain-dv/