cancel
Showing results for 
Search instead for 
Did you mean: 

How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

Hi Everyone!
I have a new magento site running magento 1.9  not installed on my local machine. I used to be able to log in via the admin login page. Now I am unable to. I don’t know what happened to cause the problem but the symptoms are as following.  If I log in with my correct username/password i am immediately redirected back to the login page with no error message.
the browswer looks like this after login
:: mysite.com/index.php/admin/index/index/key/f43c7ebxxxxxxxxxxxxxxxxxx/::
If i log in with an incorrect username password I get an error message saying my username or password is invalid. I have tried many of the solutions suggested on different websites, including commenting out various lines in my /app/code/core/Mage/Core/Model/Session/Abstract/Varien.php file, making sure that my web/cookie/cookie_domain entry in the database is set to my site domain, setting web/secure/use_in_adminhtml to 0, clearing the var/cache folder and var/session folders more times than I can count, etc.

I have no idea how to troubleshoot that. I hope you can help me. I’m banging my head against a wall here.
Thanks in advance.





12 REPLIES 12

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

Hi there,

 

We had this problem before and cleaning browser's cache fixed it.

You can also try a different browser (FF vs Chrome for example).

hope this helps.

 

Anton Pachkine @ magento2.hosting : Magento Small Business Package.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

Hi Finestshops, Thanks for your answer.
I have tried different browsers such as IE,Safari,Firefox,OpERA non of them solve the issue. And also cleaning browser caches didn't fix the problem at all.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

try deleting all files in /var/session folder.

 

if did not help, try to run this sql statement on your magento database:

 

SET FOREIGN_KEY_CHECKS=0;
UPDATE core_store SET store_id = 0 WHERE code='admin';
UPDATE core_store_group SET group_id = 0 WHERE name='Default';
UPDATE core_website SET website_id = 0 WHERE code='admin';
UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;

 

Anton Pachkine @ magento2.hosting : Magento Small Business Package.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

I deleted files from var/session folder, cleaned caches still no luck.

The second part regarding SQL statement, I really do not know how to run the code into MYSQL. If you can guide or refer me to some tutorial on how to do it it would be a great help.
Thanks in advance.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

I'd suggest asking your hosting support on how to run mysql query. this process is different depending on your hosting configuration.

 

did you try to login from HTTP vs HTTPS url?

 

for some reasons, magento can not set or save your session.

maybe your server is out of space or you used up all available space if you on a shared hosting account?

 

Anton Pachkine @ magento2.hosting : Magento Small Business Package.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

I use HTTP to login and not able to use HTTPS to login. I have sent them an email asking about how to run mysql query.

I am on a shared hosting account but how do i know if i have used all available space ? There must be away to see it?=

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

I am on a shared hosting account but how do i know if i have used all available space ? There must be away to see it?

 

you should have a control panel for your hosting account - usually "used space" is reported there. access to mysql to run queries is usually there as well. your host will be able to help find this. 

 

Anton Pachkine @ magento2.hosting : Magento Small Business Package.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

Thanks, I have a control panel and i can see the db space is set to 200MB.  I figured out that i am not using all the space i have there.

Re: How to Fix Magento’s Admin Login/Customer Login Failing (no error message)

after running this sql statement

SET FOREIGN_KEY_CHECKS=0;
UPDATE core_store SET store_id = 0 WHERE code='admin';
UPDATE core_store_group SET group_id = 0 WHERE name='Default';
UPDATE core_website SET website_id = 0 WHERE code='admin';
UPDATE customer_group SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;


i get the following error:

Error
SQL query:


UPDATE core_store SET store_id = 0 WHERE code='admin'
MySQL said: Documentation

#1146 - Table 'MYDBNAME_COM_db.core_store' doesn't exist