Magento: can't login to admin panel, can't add product to cart

If ever you encountered issues like you cannot login to the admin panel or cannot even add product to the cart, I have a better solution for you.

Using phpMyAdmin, in your magento database, look for the core_config_data table and click it. Click the "Search" tab.  Then on the "path" column set the operator to LIKE %...% and the Value to cookie and click the "Go" button to search.
Screenshot provided for clarity

After searching, set the value of web/cookie/cookie_path, web/cookie/cookie_domain, web/cookie/cookie_httponly, and web/browser_capabilities/cookies to NULL

Just like this on the screenshot.
Screenshot provided for clarity

Adding product to cart and logging in to the admin panel should work now!




Comments

  1. Unknown18 September 2013 at 09:11

    Thanks for this!
    Save me hours of trouble!
    i've noticed this problem on all my magento installations on a local server.
    is there a way to fix this without changing the database?

    Cheers mate!

    ReplyDelete
    Replies
    1. Shadow On The Sun19 September 2013 at 14:59

      So far it's the best approach rather than editing the core file

      Delete
  2. Laagan18 September 2013 at 10:00

    Whaaat? it's not working on my side. Are you sure Gen Nerdito?

    ReplyDelete
  3. Unknown3 January 2015 at 21:09

    Thanks man! That was an elegant solution.

    ReplyDelete
  4. Anonymous14 September 2015 at 18:21

    ITs not working for me..

    ReplyDelete
  5. Anonymous14 September 2015 at 18:21

    ITs not working for me..

    ReplyDelete
  6. Unknown5 October 2015 at 18:33

    neither for me... any other solution?

    ReplyDelete
  7. Anonymous6 January 2016 at 22:29

    Spot on, many thanks.
    For those having trouble, clear out var/session & var/cache after these steps, worked for me after that.

    ReplyDelete
  8. Unknown12 March 2016 at 01:00

    Thank you so much for this info... I am not sure why I suddenly have this issue, but changing these fields fixed my Shopping Cart is Empty issue. I still cannot login to the backend however. The page just refreshes and adds "/index/index/key/77089e19c1f4cdae2daab32995fc8122/" to the url. Do you have any idea what this means? Thanks!

    ReplyDelete
  9. Unknown13 May 2016 at 13:15

    Hi my magento 2.0.5 ce install does not have the cookie lines in the core_config_dat table but I know when I configured magento I chose the use https option now I can't access the admin panel. Do you have any other suggestions? Thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

How to fix Cignal Top Box error - Please perform a smart card reset by removing your smart card for 15 seconds then reinsert the card. (1/2)

Turn off the top box. Remove the Smart card from the top box. Clean the chip part (usual color of the chip is gold) with an eraser or a soft cloth Blow the Smart card slot to remove excess dirt Replace the Smart card to the slot Wait for 15-20 seconds and restart the top box. Did it help? If so, can you return the favor? Kindly just click any of the ads on this page.
Read more