Popularity Plugin for WordPress SQL Error

• October 8, 2008
• 1 Comment
• Guides
• Posted by Gee

Table ‘MYSQL_TABLE NAME.wp_ak_popularity_options‘ doesn’t exist on line: ( line number )

did you get this error after you install popularity plugin of wordpress? read this guide “fix it yourself”

go to PHPMYADMIN
go to SQL Tab

paste this:

CREATE TABLE IF NOT EXISTS wp_ak_popularity (
post_id int(11) NOT NULL,
total int(11) NOT NULL,
feed_views int(11) NOT NULL,
home_views int(11) NOT NULL,
archive_views int(11) NOT NULL,
category_views int(11) NOT NULL,
single_views int(11) NOT NULL,
comments int(11) NOT NULL,
pingbacks int(11) NOT NULL,
trackbacks int(11) NOT NULL,
last_modified datetime,
KEY post_id (post_id)
) ENGINE=MyISAM;# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE IF NOT EXISTS wp_ak_popularity_options (
option_name varchar(50) NOT NULL,
option_value varchar(50) NOT NULL
) ENGINE=MyISAM;# MySQL returned an empty result set (i.e. zero rows).

HIT GO!

Your SQL query has been executed successfully

• Tags: CREATE TABLE IF NOT EXISTS, SQL, SQL error, Wordpress, wp_ak_popularity_options, Your SQL query has been executed successfully