New Ways to Change active WordPress theme - Different Ways to Change active WordPress theme

Different Ways to Change active WordPress theme

Here are a few ways you can change the active theme in WordPress: Using WP Dashboard Using the WordPress Administration Screens: You can change the active theme by going to the “Appearance” -> “Themes” page in the WordPress Administration Screens and selecting a new theme. Using functions.php or a custom plugin Using the wp_set_theme function: … Read full article →

WPXSS CLANCI - wp_actionscheduler_actions & wp_actionscheduler_logs tables

wp_actionscheduler_actions & wp_actionscheduler_logs tables

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 →

wpcli export specific tables wordpress - Dumping specific tables using mysqldump or WP-CLI

Dumping specific tables using mysqldump or WP-CLI

For high-traffic websites, I advise developing a stagging website if you make significant updates or even switch the WordPress theme entirely. But one significant problem I encountered while moving from the staging site to the live one is that all database tables are updated, which could result in financial loss if the website receives multiple … Read full article →

2 - Use mysql2date  to convert date string obtained from the database into a readable date

Use mysql2date to convert date string obtained from the database into a readable date

Instruction: Parameter PARAMETER TYPE DESCRIPTION DEFAULT REQUIRED $format string Output can be PHP date format or Unix timestamp. no yes $date string mysql2date() only recognizes “Ymd H:i:s” format, so the original timestamp string needs to be converted to this format. no yes $translate boolean If true, the specified date and format string will be passed … Read full article →

max connections - ⚠️ User already has more than 'max_user_connections' active connections [✅ SOLVED]

⚠️ 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 →

Delete Expired WordPress Transients - Delete Expired WordPress Transients 🚮

Delete Expired WordPress Transients 🚮

WordPress uses transients to temporarily store data for its plugins and themes. By managing transients you can optimize your website for speed and make sure your website is always functioning properly. Here are a few methods how to safely delete expired WordPress transients: Delete Expired WordPress Transients using WPCLI To delete only expired transients use: … Read full article →