Posted inWordPress
Are you in my blocklist?
Is your IP address in my WordPress .htaccess block list? Here are IP addresses I block manually because of comment spamming.
Posted inWordPress
Query all WordPress posts in MySQL not having a Yoast SEO meta description
Here is a query you can use to query all posts in WordPress not having a Yoast SEO meta description yet. You can run this on your MySQL prompt or in phpMyAdmin.
Posted inWeb applications
Convert SqlCe database to SQL Server
Learn how to convert an SQL Server Compact (SQL CE) database to an SQL Server database. Because the SQL CE database type is unsupported, it’s recommended by Microsoft to upgrade to SQL Server. But how do you convert your SqlCe database?
Posted inUmbraco
How to optimize Umbraco 8 performance
Out of the box, Umbraco is a well built and pretty fast content management system. However, it is still important you perform some steps to further optimize Umbraco's performance and loading speed. Here on Sysadmins of the North, I wrote about "11+ tips to optimize Umbraco CMS" earlier, and in this post I write about implementing them. On a just installed and running website.
Posted inWeb application security
3 Ways of blocking sendmail.php on IIS webserver
Use IIS URL Rewrite Module and Request Filtering in IIS to block access to certain scripts. Sendmail.php for example. To prevent sending spam.
Posted inWeb applications
How to extend TinyMCE in Piranha CMS?
How to extend TinyMCE 5 editor in Piranha .NET CMS and add extra plugins to your project using Visual Studio 2022.
Posted inUmbraco
How to add a trailing slash in Umbraco 8
This article shows you how to add a trailing slash to URL's in Umbraco 8, using IIS URL Rewrite Module, without breaking the Umbraco backend. Forcing one particular URL avoids duplicate content, which is important for SEO.
Posted inWeb applications
Disable Joomla Contacts component (com_contact) in MySQL / phpMyAdmin
How-to disable Joomla's built-in contact forms component and its ability to send a copy to the sender, directly in your MySQL database using phpMyAdmin.
Posted inWordPress
Disable WordPress XCloner Plugin logger in MySQL / phpMyAdmin
If XCloner Logger option is enabled, it will store a log file inside the xcloner-XXXXX folder inside the backup archive. The file is named xcloner-xxxxx.log. This can generate a huge amount of temporary files and log files on your file system. This short article provides you one SQL statement to disable XCloner log directly in your WordPress MySQL database, using phpMyAdmin.
Posted inWordPress
How to Fix Yoast SEO for WordPress DeleteDuplicateIndexables MySQL error
In recent days, there are a number of reports about broken Yoast SEO database operations, related to the DeleteDuplicateIndexables function. The PHP function is located in the file wordpress-seo\src\config\migrations\20200507054848_DeleteDuplicateIndexables.php, and in this post I'll provide you with a possible fix for this statement. Read on.
Posted inWordPress
Count and display number of WordPress users in your Dashboard
WordPress widget plugin to display the number of registered users in your Dashboard.
Posted inWeb application security
Disallow direct access to PHP files in wp-content/uploads/
It's recommended to disallow access to and execution of PHP files in wp-content/uploads folder. Preferably without the use of a security plugin. Blocking access to PHP files in WordPress wp-content/uploads folder is easily achieved with a .htaccess file on Linux Apache, or web.config accesssPolicy in Windows Server IIS, and here is how. Secure your WordPress site with this simple, yet effective, tip!
Posted inWordPress
Delete spam comments after three (3) days
Here is how to change Akismet interval to three (3) days instead of 15 days for deleting spam comments, using the akismet_delete_comment_interval filter in your WordPress functions.php
Posted inWordPress
Reduce Wordfence CPU usage, disable Wordfence “Live Traffic View”
Reduce Wordfence and WordPress CPU usage by checking settings and disabling Live Traffic View. This'll improve the performance and speed of your WordPress website.
Posted inWordPress
Automatically flush Redis cache after publishing a WordPress post
Did you know you can automatically flush opcode caches like Redis when you publishing a post or page in WordPress? Doing so ensures you and your visitors see the newly created content immediately. No more stale / cached content in WP