Elementor loop grid “no results” Unknown column ‘t.term_order’ in ‘order clause’

We added a loop grid and a taxonomy filter for our products but when clicked on  any filter – product tag in our case – there was no results.  Query monitor gave the error : Unknown column ‘t.term_order’ in ‘order clause’ But the default wp _terms table did not have a term_order column anyway. So…

Making WooCommerce coupon codes work with accented – special – characters
|

Making WooCommerce coupon codes work with accented – special – characters

We were promoting our codes with capital letters as a style choice But while the code “burhi” worked the code BURHİ did not because Turkish, “i” and “İ” are considered as different characters, and the lowercase of “İ” is “i”, not “ı”. T. The code should work for other international accented diacritic characters like umlauts

Calculating average amount of memory used by each Apache process
|

Calculating average amount of memory used by each Apache process

You might need to calculate average amount of memory used by each Apache process for several reasons. One being deciding on MaxRequestWorkers . You can do it by running: ps -ylC httpd –sort:rss | awk ‘{x += $8;y += 1} END {print “Apache Memory Usage (MB): “x/1024; print “Average Process Size (MB): “x/((y-1)*1024)}’ Apache Memory…

|

MySQL log file quickly filling and growing large

While optimizing our MySQL server we noticed our mysqld.log was huge in size – 1GB+ – and it was filling every moment with the below message: [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ”mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’ Below article explains the issue https://support.cpanel.net/hc/en-us/articles/16550190886935-MySQL-log-warning-mysql-native-password-is-deprecated-and-will-be-removed-in-a-future-release But it…

Finding out Average and Peak Number of Concurrent Connections for Apache

In order to optimize Apache’s configuration we needed “Average and Peak Number of Concurrent Connections” but we didn’t have an external software like Prometheus or Zabbix to record and analyze historical data. So we needed to find a way with what we had at hand. First comes to mind: Daily Process Log in WHM: This…

WooCommerce notice not going away or stuck

WooCommerce notice not going away or stuck

Sometimes WooCommerce notices get stuck for different reasons, but we’ve had this particular woocommerce notice persisting in more than one woocommerce sites. To get rid of this “Critical vulnerabilities in WooCommerce” notice you have to set the notice to “actioned”. In order to that, you can either go to phpMyAdmin and do it manually like…