Stuck in login loop

  • Resolved meestorx

    (@meestorx)


    1 year, 11 months ago

    I am hitting the dreaded “login loop” issue where I cannot log into the admin page. When you try to login, it just takes me back to the login screen.
    Hadn’t checked this site for a while so I have no idea when this issue started, but it’s happening today and I’m out of ideas.

    wp version 6.0.1

    I have done all the searches I can, and these “fixes” did not work.
    – Clearing Cache
    – Using different browser
    – Using different computer
    – renaming .htaccess
    – renaming plugins folder
    – renaming themes folder

    next I installed wp-cli and tried:
    – changing theme to twenty-twenty
    – updating core
    when I tried this it shows “Error: Another update is currently in progress.”
    when I tried wp option delete core_updater.lock I get
    “Warning: Could not delete ‘core_updater.lock’ option. Does it exist?”

    Anyone have any suggestions?

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)

  • Try turning on debug and seeing all the errors.

    In wp-config.php
    define( ‘WP_DEBUG’, true );

    Thread Starter meestorx

    (@meestorx)

    Thank you for that suggestion.
    Where will I see the errors?
    Is there a wp log file on my server I can check?

    Your hosting site should have logs available on your dashboard. Debug errors also show up when you try the launch the admin page.

    Thread Starter meestorx

    (@meestorx)

    Gotcha. No messages shown on the site, but my log file shows:

    
[Tue Dec 06 19:45:00.392834 2022] [php7:notice] [pid 7535] [client xxx.xxx.xxx.xxx:58235] WordPress database error Duplicate entry '0' for key 'wp_usermeta.PRIMARY' for query INSERT INTOwp_usermeta(user_id,meta_key,meta_value) VALUES (2, 'session_tokens', 'a:1:
.
. [skipped a bit]
.
') made by wp_signon, wp_set_auth_cookie, WP_Session_Tokens->create, WP_Session_Tokens->update, WP_User_Meta_Session_Tokens->update_session, WP_User_Meta_Session_Tokens->update_sessions, update_user_meta, update_metadata, add_metadata, referer: https://mindplacesupport.com/wp-login.php?redirect_to=https%3A%2F%2Fmindplacesupport.com%2Fwp-admin%2F&reauth=1

    Does this shine any light on what’s going wrong?

    • This reply was modified 1 year, 11 months ago by meestorx.
    Thread Starter meestorx

    (@meestorx)

    Ok, here’s the answer, should anyone run into this one…
    Go into mysql, SELECT your WP database and do this:

    
ALTER TABLE wp_usermeta MODIFY COLUMN umeta_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=xx;

    where xx is the last record + 1

    No idea why that database wasn’t set to auto-increment or why this issue didn’t come up before, or whether what I did will break anything. All I know is I can now access the admin page!
    There’s a day I’ll never get back. ??

    • This reply was modified 1 year, 11 months ago by meestorx.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Stuck in login loop’ is closed to new replies.

Tags