WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] [closed] Hanging on Database Update Required (43 posts)

  1. OliverC
    Member
    Posted 1 year ago #

    Hello Everyone,

    I could really use some help/advice here. I run the following blog:
    http://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

  2. esmi
    Forum Moderator
    Posted 1 year ago #

    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

  3. OliverC
    Member
    Posted 1 year ago #

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

  4. OliverC
    Member
    Posted 1 year ago #

    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.

  5. esmi
    Forum Moderator
    Posted 1 year ago #

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

  6. OliverC
    Member
    Posted 1 year ago #

    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!

  7. esmi
    Forum Moderator
    Posted 1 year ago #

    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?

  8. Trionic Labs
    Member
    Posted 1 year ago #

    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

  9. OliverC
    Member
    Posted 1 year ago #

    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!

  10. esmi
    Forum Moderator
    Posted 1 year ago #

    Try resetting the plugins folder using PhpMyAdmin.

  11. OliverC
    Member
    Posted 1 year ago #

    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 ;)

  12. esmi
    Forum Moderator
    Posted 1 year ago #

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

  13. OliverC
    Member
    Posted 1 year ago #

    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:
    http://codex.wordpress.org/Restoring_Your_Database_From_Backup ?

    Thank you...

  14. OliverC
    Member
    Posted 1 year ago #

    Hi Esmi,

    My question above is is "Restore" the same as Repairing?

    .

  15. esmi
    Forum Moderator
    Posted 1 year ago #

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

  16. OliverC
    Member
    Posted 1 year ago #

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

    define('WP_ALLOW_REPAIR', true);

    Then went to:
    http://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!

  17. esmi
    Forum Moderator
    Posted 1 year ago #

    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

  18. OliverC
    Member
    Posted 1 year ago #

    Hi Esmi,

    I did everything exactly step by step and again stuck on the white screen with the WordPress logo like this:
    http://www.flickr.com/photos/thingstocomerecords/8288415428/in/photostream

    Please keep giving me advice. What can I try next?

  19. esmi
    Forum Moderator
    Posted 1 year ago #

    Now try repairing the database using Phpmyadmin or whatever database management application that your host provides.

  20. OliverC
    Member
    Posted 1 year ago #

    Hi Esmi,

    I repaired the database using PHPMyadmin as you can see. After I tried to upgrade wordpress again and it didn't work. I'm stuck on the white screen with logo.

    Screenshot of PHPMyadmin after the repair:
    http://www.flickr.com/photos/thingstocomerecords/8288518922/in/photostream

    What should I try next? Thanks.

  21. esmi
    Forum Moderator
    Posted 1 year ago #

    Create a fresh database, restore your backup to it, upload a fresh copy of the WordPress 3.4.2 core files & folders (except for the wp-content folder) and amend your wp-config.php file to point at this new database.

  22. OliverC
    Member
    Posted 1 year ago #

    Hi Esmi,

    I will take your advice. Before I start I tried it one more time and interestingly now I received this error:

    Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 35 bytes) in /home/wiretoth/public_html/wp-includes/wp-db.php on line 1220

    Strange that error never popped up before. Does this clue us in to what may be going wrong?

  23. esmi
    Forum Moderator
    Posted 1 year ago #

  24. OliverC
    Member
    Posted 1 year ago #

    Hi Esmi,

    I increased the memory and now I get this error:

    Fatal error: Maximum execution time of 60 seconds exceeded in /home/wiretoth/public_html/wp-includes/wp-db.php on line 1219

    What do you think? Should I "Create a fresh database, restore your backup to it, upload a fresh copy of the WordPress 3.4.2 core files & folders (except for the wp-content folder) and amend your wp-config.php file to point at this new database." or something else now?

    Thank you!!

  25. esmi
    Forum Moderator
    Posted 1 year ago #

    First try asking your hosts if they can temporarily raise the max_execution_time on your site to allow to you to push this upgrade through.

  26. OliverC
    Member
    Posted 1 year ago #

    Raising the max_execution_time didn't help. I create a fresh database and am restoring my back up to it. I have 15 .sql files uploading each under 50MB using myPHPadmin. There is also an index.php file... do you know if I need to upload that?

    (This part will take some time.. uploading is a bit slow)

  27. esmi
    Forum Moderator
    Posted 1 year ago #

    You don't need to upload the index.php file that came with your backups.

  28. OliverC
    Member
    Posted 1 year ago #

    Ok well I think the problem has something to do with wp_options. When upload I received this error: http://www.flickr.com/photos/thingstocomerecords/8288496009/in/photostream

    Error
    
    SQL query:
    
    INSERT INTO <code>wp_options</code>
    VALUES ( 246, 0, 'vks_ad_flex_niche_content_link_color', '3C657B', 'yes' ) ;
    
    MySQL said: Documentation
    #1062 - Duplicate entry '246' for key 1

    Any ideas? Oh my!

  29. esmi
    Forum Moderator
    Posted 1 year ago #

    That looks like a problem caused by a plugin or possibly a previous theme. That line/record definitely isn't needed by WordPress itself.

  30. OliverC
    Member
    Posted 1 year ago #

    I'm uploading the other files now. How does the backup work? Even though there was en error did that file upload?

Topic Closed

This topic has been closed to new replies.

About this Topic