Hanging on Database Update Required

  • Resolved OliverC

    (@oliverc)


    11 years, 11 months ago

    Hello Everyone,

    I could really use some help/advice here. I run the following blog:
    https://www.wiretotheear.com/

    I did the automatic upgrade to 3.5 and although the site is still online when I try and log in via wp-admin I get the following message:

    “Database Update Required WordPress has been updated! Before we send you on your way, we have to update your database to the newest version. The update process may take a little while, so please be patient.”

    When I click “Update WordPress Database” I just get a blank screen with the WordPress logo on top… it never completes anything.

    I’m a novice at the backend of the this stuff. So far I tried increased my PHP memory to 128MB but it has not fixed the issue.

    Any advice would be really appreciated!

    – Oliver

Viewing 15 replies - 1 through 15 (of 42 total)

  • Try:
    – switching to the Twenty Twelve theme by renaming your current theme’s folder inside wp-content/themes and adding “-old” to the end of the folder name using FTP or whatever file management application your host provides.

    – resetting the plugins folder by FTP or phpMyAdmin.

    – re-uploading all files & folders – except the wp-content folder – from a fresh download of WordPress. Make sure that you delete the old copies of files & folder before uploading the new ones.

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

    Thread Starter OliverC

    (@oliverc)

    Thank you for your quick reply. I am trying your recommendations. I will report back.

    Thread Starter OliverC

    (@oliverc)

    Hello esmi,

    I followed your instructions exactly… all 4 steps. Still the same thing though. Do you have any other ideas? I can’t figure out what’s wrong. Thanks for any advice.

    Have you checked your site’s error logs for clues?

    Thread Starter OliverC

    (@oliverc)

    Hi Esmi,

    When I edit my WP-Config file to debug mode I do have 10 errors. I’m really just a blogger so I don’t understand what I am looking at mostly. I see somethings that have to do with plug-ins so I assume when I deactivate them they should no longer be causing the issue. Would you mind looking quickly at these and see if there is something there you think is the problem:

    Notice: add_option was called with an argument that is deprecated since version 2.3 with no alternative available. in /home/wiretoth/public_html/wp-includes/functions.php on line 2910

    Notice: register_sidebar_widget is deprecated since version 2.8! Use wp_register_sidebar_widget() instead. in /home/wiretoth/public_html/wp-includes/functions.php on line 2824

    Notice: register_widget_control is deprecated since version 2.8! Use wp_register_widget_control() instead. in /home/wiretoth/public_html/wp-includes/functions.php on line 2824

    Notice: load_plugin_textdomain was called with an argument that is deprecated since version 2.7 with no alternative available. in /home/wiretoth/public_html/wp-includes/functions.php on line 2910

    Notice: Undefined index: action in /home/wiretoth/public_html/wp-content/plugins/flickr-gallery/flickr- gallery.php on line 105

    Notice: Undefined index: action in /home/wiretoth/public_html/wp-content/plugins/flickr-gallery/flickr- gallery.php on line 107

    Notice: Undefined index: action in /home/wiretoth/public_html/wp-content/plugins/flickr-gallery/flickr- gallery.php on line 109

    Notice: Undefined index: page in /home/wiretoth/public_html/wp-content/plugins/flickr-gallery/flickr- gallery.php on line 113

    Notice: Undefined index: solo-comment-subscribe in /home/wiretoth/public_html/wp- content/plugins/subscribe-to-comments/subscribe-to-comments.php(852) : runtime-created function on line 1

    Warning: Cannot modify header information – headers already sent by (output started at /home/wiretoth/public_html/wp-includes/functions.php:2910) in /home/wiretoth/public_html/wp- includes/pluggable.php on line 876

    Thanks again… if you have a tip jar point me in that direction!

    Looks to me like you have a slightly outdated theme and possibly 1 or more problem plugins. Can you confirm that you have now activated the Twenty Twelve theme by renaming your old theme’s folder inside wp-content/themes?

    Another possibility is just a cookie issue. Go into your browser settings and delete all cookies for your url. Close your browser, restart and log into wordpress and see if that helps.

    The other cause of this is if you are using memcached, you have to clear that cache and restart memcached.

    Good luck.

    Ed

    Thread Starter OliverC

    (@oliverc)

    Hello Esmi,

    I can confirm that I did rename my old theme’s folder. It used to be named ub_enormous and I renamed it to theme-old.

    If you notice… with my plug-in folder now named plugins.hold and old theme renamed the site doesn’t come up at all (which is the way it is currently). If I put back the old names it appears as normal.

    Hello Trionic,

    I deleted all my cookies for my URL and restarted but I still have the problem. I never heard of memecached before.

    Thanks again. Please let me know what you think I should do next. Appreciated!

    Try resetting the plugins folder using PhpMyAdmin.

    Thread Starter OliverC

    (@oliverc)

    Hello Esmi,

    I did that before but just did it now again… still no change it still fails.
    https://www.evernote.com/shard/s1/sh/8116b3a6-1582-49ef-9e87-56d9df9cfeab/651aa4b0db09e91e728d55f1d583e313

    Sorry this is frustration. Anything other ideas? Ive been writing daily to this blog for more than 5 years… want to keep it alive ??

    Try repairing your database. Do you have any recent database backups?

    Thread Starter OliverC

    (@oliverc)

    Hi Esmi,

    I did make a backup before I tried to upgrade using WordPress Database Backup by Austin Matzko. Should I follow the instructions here to “Restore My Database” using MyPHP:
    https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup ?

    Thank you…

    Thread Starter OliverC

    (@oliverc)

    Hi Esmi,

    My question above is is “Restore” the same as Repairing?

    .

    No – the former replaces all of the data with an older copy. The latter attempts to resolve any problems in the existing database.

    Thread Starter OliverC

    (@oliverc)

    I see! I’m learning here. I added the following to my wp-config.php file

    define('WP_ALLOW_REPAIR', true);

    Then went to:
    https://yourdomain.com/wp-admin/maint/repair.php

    It is telling me “Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.”…

    wp_users: 7 clients are using or haven’t closed the table properly
    wp_usermeta: 8 clients are using or haven’t closed the table properly
    wp_posts: 5 clients are using or haven’t closed the table properly
    wp_comments: 5 clients are using or haven’t closed the table properly
    wp_options: 6 clients are using or haven’t closed the table properly
    wp_postmeta: 10 clients are using or haven’t closed the table properly
    wp_terms: 8 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 8 clients are using or haven’t closed the table properly
    wp_term_relationships: 8 clients are using or haven’t closed the table properly
    wp_commentmeta: 10 clients are using or haven’t closed the table properly

    I did try and Update again but still goes to the blank screen with the WordPress logo on top. The website is still online.

    What do you recommend next? Again… appreciate this help!

Viewing 15 replies - 1 through 15 (of 42 total)
  • The topic ‘Hanging on Database Update Required’ is closed to new replies.