Cannot log to admin after update

  • Resolved buliin

    (@buliin)


    2 years ago

    Recently, my website was updated to WordPress 5.9.5 and it crashed. There was a message with critical error, so I turned on Debug mode, disabled plugins by renaming the folder and switched to default theme in MySQL db.

    However the steps did not helped and I cannot log to admin panel.
    When I try to log there, the error appears saying that the user is not existing.

    However, I checked directly in DB and this user exists (tried both email and nickname). I have even reset the password, but still same result.

    In logs I can see the following error:
    Error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY wp_posts.post_date DESC LIMIT 0, 10' at line 1 of the WordPress database while executing a query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1 = 1 AND ((wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 0, 10 sent by require (''), wp, WP-> main, WP-> query_posts, WP_Query-> query, WP_Query- > get_posts

    I can see that there is one “)” but I have no idea where this function is being build and how can I fix it, since I am not an advanced user.

    Do you have any ideas how I could fix it?

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

  • Hi @buliin

    That sounds frustrating. I was wondering if you have cleared your browser cache and cookies to ensure the problem is real?

    Secondly, which hosting company are you using?

    Cheers
    Wes

    Thread Starter buliin

    (@buliin)

    Hi @west7,

    Thank you for quick reply.

    When I cleared cache, I received on a /wp-admin/ page info that there was a critical error and additional instructions were sent to mail. However, I have not received this email. I checked SPAM folder and there is no email.

    So now I do not even have the login page for admin panel ??

    The hosting company is az.pl from Poland.

    You can always contact your hosting company for support as well: https://pomoc.az.pl/kontakt/

    Check if you must update your database. To see if there’s an update available for your WordPress database, follow the path wp-admin/upgrade.php on your website URL.

    Example: https://www.yourdomain.pl/wp-admin/upgrade.php

    Thread Starter buliin

    (@buliin)

    I tried to use the /wp-admin/upgrade.php but nothing changes ??

    I have created a new WordPress instance and used UpdraftPlus backup files to restore the website and here is what I have found:
    – restoring everything apart from db files works ok
    – while restoring the db, I get a notification that the backup was created with PHP 7.1. The earliest version of PHP that I have on my hosting company is 7.2.
    When I try to restore it, the website crashes. So I guess there must have been some changes in the DB structure / interface that broke the website. Do you know if there is any way of restoring the content of the website from the DB itself?

    I will contact the support as well.

    Thread Starter buliin

    (@buliin)

    Not knowing what to do, I changed the PHP version on the hosting from 7.1 to 8.1 and the webpage started to work again! I reactiveated all themes and plugins and I only needed to “Save” permalinks and everything is ok now.

    @west7 thank you for your help!

    • This reply was modified 2 years ago by buliin.

    That is great news!

    All the best

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Cannot log to admin after update’ is closed to new replies.

Tags