I admitted that POPULARITY CONTEST plugin (for wordpress) were the coolest plugin ever create. Thanks to Alex King for invented this technology. Unfortunately, this plugin were HARD to be activated!. Even for me that have been blogging in 1 years. When i activate this plugin, error message always shown up. It say that this plugin Trigger some ERROR in my wordpress. How can we fix it?
At last, i have found the problems. And i have already implementing this into my blog, and it has works perfectly. Hurray!!
Last time, i assume that this error massage shown up due to my hosting problems, because some of my friend could use this popularity contest plugin easily. No problem at all. Then, i try to use another hosting provider to solve this problems. It Suck!!. It still give me a same problems. Now, i assume that hosting were never be a cause for this error. It must be something else!.
Today, i have informed by my other friend, that have already success to use this plugin. He say that sometimes, this plugin could not make DATABASE correctly, that’s why error message shown up. The point is, WE MUST CREATE DATABASE MANUALLY.
To create database manually, see my tutorial below :
TUTORIAL TO USE POPULARITY CONTENT (WORDPRESS PLUGIN)
1. Login into your CPANEL account, and select phpMyAdmin
2. Choose your database name, according to your blogs
3. If there is lots of database name (maybe you use many subdomain blog that use wordpress), you can find the perfect database name with find the information from WP-CONFIG.PHP file. Please login into your account with your FTP, and download the ‘wp-config.php’ files, and open it with dreamweaver or notepad or other software.
4. When you open ‘wp-config.php’ with your software, you will see this information like image below. DB_NAME will show your database name for your specified wordpress blog.
5. When you have know the correct database name, then open those database to create NEW database manually. When it have opened perfectly, you will see like this image below. You can create new table using ‘Querry Window’ button as shown in images below.
6. Blank windows will be show up. All you need is copy some script in this block, and click ‘GO’ button.
Inside those querry area, please insert this code to make database automatically. It will make your job faster than using manual ways. There is two script that you must do. Do it Step by step!
First Script : creating ‘wp_ak_popularity’ table
CREATE TABLE `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 NOT NULL
)
Second Script : creating ‘wp_ak_popularity_options’ table
CREATE TABLE `wp_ak_popularity_options` (
`option_name` VARCHAR( 50 ) NOT NULL ,
`option_value` VARCHAR( 50 ) NOT NULL
)
Just remember that do this works step by step. You can not make those two table at once.
When this table have created successfully, then IT’S TIME TO ACTIVATE POPULARITY CONTEST PLUGIN.
To place the report list of popularity article, put this script in sidebar. You should edit your ’sidebar.php’ and put it manually. I dont think that this plugin could implemented by adding widget.This is script to call the LIST to show up :
<?php akpc_most_popular(); ?>
If your plugin still didn’t works, you can download popularity plugin that i have modified here :
Download POPULARITY CONTEST Plugins
Popularity: 4% [?]
Viewed 1013 times by 293 viewers
