WooCommerce plugin uses the wp_actionsscheduler_actions table in the database to log scheduled actions such as cron’s running, product synchronization, upgrade, etc. These actions should be deleted once they are executed but this doesn’t always happen, in most cases, this table uses an InnoDB database engine with a row-level locking feature meaning that multiple queries can … Read full article →
![max connections - ⚠️ User already has more than 'max_user_connections' active connections [✅ SOLVED]](https://wpxss.com/wp-content/webp-express/webp-images/uploads/2022/09/max-connections.png.webp "⚠️ User already has more than 'max_user_connections' active connections [✅ SOLVED]")
Noticed a lot of Crawler errors on the Google Adsense console: So I enabled the WP_DEBUG and run a stress test with vegeta on the website: the website became unavailable and the following error was shown: User already has more than ‘max_user_connections’ active connections This explains the errors in Google SC because the crawler most … Read full article →
Here is a handy snippet that displays a random post, so each time a user refreshes the page a different post will appear. The snippet should be saved as a PHP template for pages and a page has to use it. Step 1. Create a new file random.php inside your active theme folder and put … Read full article →
Recently I was migrating a website from GoDaddy shared hosting using WP-CLI and noticed the PHP version in cli was outdated. Here is how to install WP-CLI and set custom PHP version for the cli. Setup WP-CLI To download WP cli: To run it use php wp-cli.phar To make it easier to call We’ll rename … Read full article →
After optimizing a WooCommerce store I noticed the following HTML comment appears at the beginning of every page when viewing the source code: Alter HTML was skipped because the HTML is too big to process! After troubleshooting the issue, it seems to be caused by the WebP Express WordPress plugin when the feature Alter HTML … Read full article →
Google’s PageSpeed Insights tool gives you a score between 0-100, with 100 being the fastest loading time. Slow websites rank lower in Google, have lower conversion rates, and generate less revenue with higher expenses. In this guide We will first check what is actually showing down a WordPress website by running a test for a … Read full article →
Here are a few WP-CLI tricks and tips that might be useful: Aliases Use aliases to make commands shorter and easier to remember. You can use the –alias=<alias> flag when defining a command to specify a shorter alias for the command. For example, if you use a command wp my-command: you could define a command … Read full article →
When it comes to cleaning huge websites of malware, if the database is several GB in size, it becomes difficult to navigate and remove bad code. PHPMyAdmin and text editors become completely useless for databases over 2GB in size. Here’s a script I came across recently and turned to be quite helpful in removing malware … Read full article →
To display the total number of WooCommerce products, you can use the following code snippet: <?php $products = wc_get_products(array( ‘limit’ => -1 )); echo count($products); ?> This code uses the wc_get_products() function to retrieve all published products, with no limit on the number of products returned. The count() function is then used to count the … Read full article →
If you’re running the Redis Object Cache plugin on a client site, you’ve probably seen this ugly white-screen error at some point: Error establishing a Redis connection To disable Redis, delete the object-cache.php file in the /wp-content/ directory. By default, if Redis becomes unreachable (server restart, memory limit hit, network hiccup, provider maintenance..) the plugin throws a fatal error … Read full article →