How to Manually Add a WordPress Administrator to the Database using SQL Queries

May 19, 2015 Iyngaran Iyathurai 0

In a recent WordPress hack attack which we worked on and recovered, the owner’s WordPress administrator account was demoted to a user role, therefore the owner did not have any control over the WordPress installation. To regain back access to WordPress, we manually created a new WordPress user with an Administrator role directly in the database.   In this tutorial I will show you how to manually create a WordPress administrator in the WordPress database […]

Bulk delete pending wordpress comments

April 10, 2015 Iyngaran Iyathurai 0

Been under a comment spam attack lately? Or you just did not have time to delete spam comments over several months and you now have hundreds of spam comments that needs be deleted page by page using the wordpress admin? Don’t worry, there are a couple of easy ways to bulk delete pending comments in your wordpress blog. Method 1: Direct MySQL Query If you know yourself around phpMyAdmin and MySQL queries, just run this […]

Bulk delete pending wordpress comments

January 19, 2014 Iyngaran Iyathurai 0

Been under a comment spam attack lately? Or you just did not have time to delete spam comments over several months and you now have hundreds of spam comments that needs be deleted page by page using the wordpress admin? Don’t worry, there are a couple of easy ways to bulk delete pending comments in your wordpress blog. Direct MySQL Query If you know yourself around phpMyAdmin and MySQL queries, just run this one line […]

How to enable PHP error logging via .htaccess

October 10, 2011 Iyngaran Iyathurai 0

Tracking PHP errors is a must when troubleshooting unexpected issues, related to plugins, themes. But you don’t want to have them visible on your site, especially not your customers. Here is a tutorial how to log all PHP errors behind the scenes to a private file. Tracking your site’s PHP errors is an excellent way to manage and troubleshoot unexpected issues related to plugins and themes. Even better, monitoring PHP errors behind the scenes via […]

How to change wordpress theme directly from database?

September 10, 2011 Iyngaran Iyathurai 0

I had some error in my new wp theme (hybrid-news). When I enabled the new theme, I got this error – Fatal error: Call to undefined function hybrid_get_prefix() in /media/Webroot/projects/wp/wp-content/themes/hybrid-news/functions.php on line 46 . I was unable to access my wordpress blog both from frontend and backend (admin panel). In this case, either I need to change/fix my theme’s code. So I decided to change the theme. To do that, I open the phpMyAdmin, and […]

Speed Up Your Site – Web Site Optimization

February 14, 2011 Iyngaran Iyathurai 0

The load time of websites is one of the most important factors affecting its usability; most Internet users will just skip a site altogether if it fails to load within a couple of seconds. Slow-loading websites are one of the main reasons that visitors may leave a site. As a result, it is important to ensure that your website is fast and regularly make improvements as content changes. The content should make up the majority […]