Required database update killed Azure Admin access

  • I have a WordPress site hosted on Azure. I have searched the forums and this appears to be a current, unsolved problem with the update for Azure users.

    I click on the admin login and get “Database Update Required WordPress has been updated! Before we send you on your way, we have to update your database to the newest version.”

    If I click “update”, the screen goes white, nothing happens, it hangs. Clearly the one-click database update doesn’t play well with Azure’s version of SQL/MYSQL.

    Here is my plea for help: I need to get to my Admin panel. If I can do that, I can export my site using the export RSS file and move it to a more friendly host. Or move it temporarily while WordPress and Azure figure out their issues. Or do a fresh Azure install with current database and re-import it. But I need my site. Is there a workaround that I can use to temporarily halt the database version check to get to my Admin panel to export? Is there a simple solution to “updating the database” at Azure?

    This security update has left me dead in the water, any help would be appreciated. I’ve tried to edit the wp-db.php per another Azure user’s suggestion on the forum and it gave me a database error.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Moderator t-p

    (@t-p)

    – try MANUAL updating. Download a fresh copy of the WordPress .zip file to your computer, unzip it, and use that to copy up all files and folders EXCEPT the wp-config.php file and the /wp-content/ directory. You may need to delete the old copies of files & folder on your server before uploading the new ones.

    Read the Manual Update directions first.

    – running the upgrade manually via wp-admin/upgrade.php

    – If you haven’t already done, always backup everything (including your database) before doing any actions.

    Thread Starter 99azureproblems

    (@99azureproblems)

    The site itself is updated, the whole thing hangs on the database version. The site updated with the autoupdate, but it still needs to “update” the database, which resides on the Azure servers.

    The first message it gives me is, “WordPress has been updated!”

    The second is, “we have to update your database to the newest version.”

    That’s where it hangs. I need to get to the admin panel, or figure out a workaround, I don’t know any way to update an Azure SQL database emulating MYSQL. I’m sure there’s a way, but I’m dead in the water until I figure this out.

    Moderator t-p

    (@t-p)

    I don’t know any way to update an Azure SQL database emulating MYSQL.

    discuss this with your hosting provider.

    Thread Starter 99azureproblems

    (@99azureproblems)

    Is there a workaround to get the startup scripts to not force-update the database? That’s the easy answer. Then I can move the site

    Only stuff that could help you out is

    1- Download https://www.heidisql.com/download.php HeidiSQL
    2- used connections settings from wp-config.php
    3- If you get error add Your IP to firewall and you will be able to access your SQL export the database table by table
    4- Import it in wordpress default tables ( Created by new installations) remember to empty table before importing like if you are importinf wp_users empty the default table created by fresh wp install and import it

    Thread Starter 99azureproblems

    (@99azureproblems)

    nazrulhassanmca is a master, he is correct.

    The issue may be fairly narrow, but significant to those affected. For a while, Azure was using “Brandoo” installations of WordPress, which used a php interpreter to force an Azure SQL database to emulate a mysql database. Brandoo died, so when it came time for a required database update, it was impossible (Brandoo stated that one of the main reasons they quit the project was the constant WP changes). The only answer appears to extract everything from Azure, rebuild an actual mysql database and move the files and new database to host it somewhere that allows mysql.

    Later Azure WordPress implementations use a mysql vendor called Cleardb for a free 20 meg mysql external database. Once you go over 20 meg, the price skyrockets. Azure isn’t a particularly WP friendly host.

    Anyway, nazrulhassanmca knows what he is talking about.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Required database update killed Azure Admin access’ is closed to new replies.