WordPress Database Error – Force Upgrade Not Working

Resolved luckie777
(@luckie777)

11 years, 1 month ago

I’ve installed the WP-Portfolio plugin and created a Portfolio Group. The following error is presenting at the bottom of the page:

WordPress database error: [Table ‘pagesullivan2.wp_comments’ doesn’t exist]
SELECT comment_approved, COUNT( * ) AS num_comments FROM wp_comments GROUP BY comment_approved

I’ve activated & deactivated the plugin. I’ve tried the “Force Upgrade” option several times. Neither option worked. Please advise a solution that will resolve this issue.

The URL – http://www.taosrealestate.com/media-gallery/

Thanks – Luckie

https://ww.wp.xz.cn/plugins/wp-portfolio/

Viewing 2 replies - 1 through 2 (of 2 total)

Jennifer Moss

(@mossifer)

11 years ago

Getting this too

Plugin Author

puravida1976

(@puravida1976)

10 years, 6 months ago

Hello,

I was going through all the unresolved issues and came across this one. I’m not sure why nobody replied before now, but this issue is not related to the plugin itself. This is a bug with WordPress.

After searching around for a bit, I found the following database query to create a missing wp_comments table (USE AT YOUR OWN RISK!!) which may or may not be sufficient (as tables may have changed in recent versions):

CREATE TABLE wp_comments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID int(11) NOT NULL default '0',
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default '',
comment_author_url varchar(200) NOT NULL default '',
comment_author_IP varchar(100) NOT NULL default '',
comment_date datetime NOT NULL default '0000-00-00 00:00:00',
comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default '0',
comment_approved varchar(20) NOT NULL default '1',
comment_agent varchar(255) NOT NULL default '',
comment_type varchar(20) NOT NULL default '',
comment_parent bigint(20) NOT NULL default '0',
user_id bigint(20) NOT NULL default '0',
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

That should fix the error and also fix issues with missing or inaccurate comments.

Best regards,

Brandon

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress Database Error – Force Upgrade Not Working’ is closed to new replies.

Tags