blythescherrer
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: [Post Next] How to Resolve WP Database Updte ERROR … ?Hi, just for the benefit of everyone on the codex I figured out the problem and solved it! For a newbie like me I’m pretty impressed with myself!
First, I found a site about database repair (https://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/) that instructed me to put the following line in my wp-config.php file:
define(‘WP_ALLOW_REPAIR’, true);
Once I did that, I could see the settings by visiting this page: https://www.yoursite.com/wp-admin/maint/repair.php
I clicked on “REPAIR” and it gave me a report that told me my comments table was marked as ‘crashed’… yikes!
So I googled that and found that I could go into my hosting account and into PhPMyAdmin (under database tools) . From there, I selected the comments table and there was an ‘operations’ tab that had a repair button. I clicked the button, and VOILA.
Then I went back and did the database update again. No error and I got into my admin interface.
Forum: Fixing WordPress
In reply to: [Post Next] How to Resolve WP Database Updte ERROR … ?I am also having the same issue. My user is trying to access his site, and he gets a database upgrade required message. Clicks on ‘update’ and this is the error he gets.
Catchable fatal error: Object of class WP_Error could not be converted to string in /data/15/2/74/79/2726405/user/2995896/htdocs/wordpress1/wp-admin/includes/upgrade.php on line 1352
Line 1349 – 1353 of updgrade.php says
“SELECT comment_ID FROM $wpdb->comments
WHERE comment_date_gmt > ‘2015-04-26’
AND CHAR_LENGTH( comment_content ) >= $content_length
AND ( comment_content LIKE ‘%<%’ OR comment_content LIKE ‘%>%’ )”
);I can get to the backend of the install using FTP, fish out the code and put it into Dreamweaver to see it, but I don’t know php and I don’t want to alter it without some expert advice.
Help!