Home » Archive by category "Wordpress Administration"

Really Simple SSL

I recently needed to upgrade an existing wordpress site to SSL/https:. This was made more complicated by the fact that it was on a shared hosting server, AND used cloudflare CDN. This should have been simple: Generate certificate request Buy certificate Install certificate Tell WordPress...

Continue reading »

WordPress post-by-email feature.

The best way to make this work is to use the Jetpack plugin, and enable the post-by-email feature. That gives you an e-mail address where anything it receives is published as a blog post. However, I found I couldn’t get it to work until I...

Continue reading »

No More Jetpack!

If it looks too good to be true, it probably is. It was. Automattic.com “locked-on” to one of my JetPack-using sites, firing thousands of requests, and resulting in my hosting account getting suspended. I’ve had to remove it from ALL sites, just in case. Not...

Continue reading »

Essential WordPress Plugins (Updated)

Why Use Plugins? WordPress is immensely powerful straight out of the box, but it’s possible to add pretty much ANY functionality you want, and it’s usually for free. OUR Favourites This is a list of the TOP Plugins we use at q292u.com. Others may not...

Continue reading »

WordPress Database – Bulk Delete Users

Wordpress Technical

Bulk Delete Users I had 1000 spammer registrations from the same 2 domains. Here’s how I got rid of them all, in seconds.. From the PLESK database “Web Admin”: Delete the users.. delete FROM wp_users WHERE user_email LIKE ‘%@domain.com’ ** you could use ANY criteria...

Continue reading »

WordPress Database – Delete Orphaned Posts

Wordpress Technical

Delete Orphaned Posts After manually using SQL to delete users, you can be left with (potentially a lot) of posts which now belong to users who simply don’t exist. You don’t want this, it wastes space and clogs things up. There are two solutions to...

Continue reading »

WordPress Database – Delete Orphaned Postmeta

Wordpress Technical

Delete Orphaned Postmeta After deleting posts using SQL, you will be left with (potentially a LOT) of orphaned postmeta records. You don’t want that! It wastes space and clogs up site performance. Get rid! From PLESK or CPANEL database web admin: DELETE FROM wp_postmeta WHERE...

Continue reading »

WordPress Database – Delete Orphaned Usermeta

Wordpress Technical

Delete Orphaned Usermeta.. After using SQL to bulk-delete users, you’ll be left with (potentially a lot) of orphaned records in the “usermeta” table. You don’t want that. It’ll just waste space and clog things up. After deleting 1000 user records, I had 20000 orphaned usermeta...

Continue reading »