Tag Archive | "Wordpress"

Tags: ,

WordPress An unknown error occurred

When you login to wordpress admin panel and trying to search a plugin you might get the following error

"An unknown error occurred"

How does the error come out? generally speaking it’s because of the wordpress API, when the returned value is empty or imcomplete it will give out this error, you can install the plugin manually if it’s urgent. But for knowledge sharing purpose, we’ll try to find out what’s going on.

We can refer to this directory and file "wp-admin\includes\plugin-install.php"

and find

$request = wp_remote_post(‘http://api.wordpress.org/plugins/info/1.0/’, array( ’timeout’ => 15, ’body’ => array(‘action’ => $action, ’request’ => serialize($args))) );

then add theh following at the end


You can go to wp-admin and search the plugin again, if there’s any problem it will print out the actual error messages but not just the simple "An unknown error occured".


Posted in WordpressComments (0)


Useful WordPress SQL Queries

Update wordpress site address:

UPDATE wp_options
SET option_value = replace(option_value, ‘http://www.oldsite.com’, ‘http://www.newsite.com’)
WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

Replace the table fields value with new phrase (ex: update urls from old site to new site):

update wp_posts set post_content=REPLACE(post_content,’http://www.olddomain.com’,'http://www.newdomain.com’)

Delete all article/page revision and the tags:
If you revised your wordpress post 3 times and it will insert 3 lines to your database thus 3 times bigger than original size, it’s helpful to delete those unused content.

DELETE FROM wp_posts WHERE post_type = "revision";

Reset admin user password:

UPDATE wp_users SET user_pass = MD5( ‘new_password’ ) WHERE user_login = ‘admin’;

Reset Admin username:

UPDATE wp_users SET user_login = ‘newname’ WHERE user_login = ‘admin’;

Export all email address from comments:

SELECT DISTINCT comment_author_email FROM wp_comments;

Delete all spam comments:

DELETE FROM wp_comments WHERE comment_approved = ‘spam’;

Delete all comments containning links:

DELETE FROM wp_comments WHERE comment_content LIKE "%<a href=%" AND comment_type = ”;


Posted in SQL Server, WordpressComments (0)