Hanging on Database Update Required

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

Hi Esmi,

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

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

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

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:
https://www.flickr.com/photos/thingstocomerecords/8288518922/in/photostream

What should I try next? Thanks.

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.

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?

Possibly. Try increasing the memory available to PHP to 256M.

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!!

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.

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)

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

Ok well I think the problem has something to do with wp_options. When upload I received this error: https://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!

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

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

No. The .sql import would have stopped at that error.