Category Archives: Wordpress

CMS that is easily to use, free, but give us many beautiful features

how to delete wordpress spam comments via PHPmyAdmin

WordPress spam comment is very disturbing and can take so large size of database. From my experience for around 18.000 spam comments we will get 19 MB of spam database. Deleting via wordpress dashboard (in my case) didn’t work, si i have to manually delete this spam comments via PHPmyadmin.

to delete spam commment
1. go to PHPmyAdmin
2. choose your wordpress database
3. choose dbprefix_comments table
4. choose sql in menu bar
5. enter sql command
DELETE FROM `dbprefix_comments` WHERE `comment_approved`=’spam’
6. Choose ‘Go’ or other button than ask you to run the command
7. viola, your spam comments is now deleted 😀

Automatically Create Read More Page WordPress

For your each of your wordpress web you have your own themes. Each theme has its own setting. For example, originally my themes didnt create “Read More” for each article in home page. Manually i can set it up in my new post. Simply by clicking more icon in the middle or after some words in article. The result will be home page with list of my posts, but now it has read more section that will drive the user to single post format.

If you want to do it automatically u can choose or use the_excerpt() function instead the_content() function.
You can do this to you home page by doing these steps :
1. Open Your dashboard
2. Go to Appereance ===> Editor
3. Choose index.php to be modified
4. Find string the_content()
5. Replace it with the_excerpt()
6. Update/Save this modification

Now you will have automatically created read more section for all your posts displayed on your homepage

Add and Enable Gravatar on WordPress

Gravatar or global avatar is nice service that enables us to share our avatar anywhere. The main function of this service or application is to add our profile, including photos and short explanation about us into our web page. In wordpress this application is useful in comments. We can put our photos to our comments on our own site and also on the other site.

gravatar
my gravatar

Gravatar is not enable by default in wordpress. It is on separate .com site. To enable this gravatar in wordpress u just need to signup to gravatar.com with your email address that u use in wordpress. there is the step to make it work.

1. Go to your wordress dashboard, Settings, choose General.
2. Check or fill the email address
3. Open new tab, www.gravatar.com
4. Sign up to gravatar.com with the same email address on your General Setting wordpress
5. Confirm your gravatar account on your inbox email
6. Log-in to gravatar.com, upload some images, Try make new comment, it will works

Some other explanation can u find in wordpress.org/codecs

How to fix wordress redirected to install.php

make sure you have started your mysql
/usr/local/etc/rc.d/mysql-server start

repair the database using phpmyadmin
1. check database using phpmyadmin
-choose database you use in your wordpress
-select all table (check all)
-in menu with selected, select check table
-you will get error message for error table, now what you need to do is to repair it

2. repair table using phpmyadmin
-choose tables you want to repair
-select those tables
-in menu with selected, select repair

now you will get your right page 🙂

How to edit wordpress permalink

permalink is permanent link, it is link that is readable by human. this permalink is used to make it easier for us to read a link and use the link when we want to cite the link. permalink also useful for increase the traffic of your blog. this link usually is generated by rewrite engine. http://en.wikipedia.org/wiki/Rewrite_engine

if you want to edit permalink in you wordpress you can edit it in menu setting > permalink. first you need to go to the dashboard and click the setting icon which is located in right side in the bottom. and choose permalink for example

http://caleudum.com/?p=123
http://caleudum.com/2012/11/18/sample-post/
http://caleudum.com/2012/11/sample-post/
http://caleudum.com/archives/123
http://caleudum.com/sample-post/

after you choose the setting you want, you need to remember it, to make you easier if you want to move or create new wordpress installation using you old post/database.

WordPress Proxy Setting

When you install wordpress on you web hosting server that located behind proxy such as squid, some features may be disabled. those features like plugin installation and themes selection from internet will be disabled. You may receive message like this.

An Unexpected HTTP Error occurred during the API request.

inside your plugin page or

An Unexpected HTTP Error occurred during the API request.

on a wordpress error, blankpage

you will also receive this error message when you are trying to access theme installation page. if in ordinary hosting we find no problem, than in wordpress behind firewall it becomes a little problem, it make work little bit harder when we want to choose, install, and activate new themes or plugin that supported by wordpress.

we can solve this wordpress proxy setting by adding these lines in wp-config.php

define(‘WP_PROXY_HOST’, ‘192.168.84.101’);
define(‘WP_PROXY_PORT’, ‘8080’);
define(‘WP_PROXY_USERNAME’, ‘my_user_name’);
define(‘WP_PROXY_PASSWORD’, ‘my_password’);
define(‘WP_PROXY_BYPASS_HOSTS’, ‘localhost, www.example.com’);

but you have to make sure you knowproxy configuration in your work place or your hosting server. change the value inside wordpress proxy setting like this according to your own setting.

here is the example
define(‘WP_PROXY_HOST’, ‘cache.caleudum.com’);
define(‘WP_PROXY_PORT’, ‘8080’);
define(‘WP_PROXY_USERNAME’, ‘caleudum’);
define(‘WP_PROXY_PASSWORD’, ‘mypassword’);
define(‘WP_PROXY_BYPASS_HOSTS’, ‘localhost, www.example.com’);

delete / remove ?wpmp_switcher=desktop

After i use wordpress plugin for mobile web application “WordPress Mobile Pack”  i found that it caused duplicate meta description. Each of my link/permalink will be appended “?wpmp_switcher=desktop”, which indicates that instead of using the web mode display, we will use desktop mode display.

since it created miss configuration to meta description tag, i prefer to remove the plugin. but the affected links seem still the same. trying to understand this thing, i did these 2 things.

1. Clear the dns cache and browser history just to make sure these aren’t the thing that causes the problem.

2. Deleting completely any “WordPress Mobile Pack” in folder wp-include>>themes.

It seems working on my website, u can try to do it with yours too. hope this helpful for you.

 

 

Error establishing a database connection

Some of the problems sometimes arise with Mysql database and WordPress. One problem that sometimes arises is the web displays the error Establish a database connection, this problem usually occurs because we haven’t started yet our mysql-server program, or already started but not run well. The solution is simply to check whether or not our mysql running and try to run it.

To view mysql process id
ps -ax | grep mysql

If this command return you no result, it means your mysql doesn’t run.

To start mysql-server

On FreeBSD enter this command
/usr/local/etc/rc.d/ mysql-server start

On Ubuntu/Centos enter this command
service mysql start

It should solve your problem.