How to fix Unknown collation utf8mb4_unicode_520_ci error while importing data from an sql dump


ERROR 1273 (HY000) at line 849: Unknown collation: ‘utf8mb4_unicode_520_ci’

To fix simply replace utf8mb4_unicode_520_ci to utf8mb4_unicode_ci inside your SQL dump


sed -i 's/utf8mb4_unicode_520_ci/utf8mb4_unicode_ci/g' yoursqldumphere.sql


replace 'utf8mb4_unicode_520_ci' 'utf8mb4_unicode_ci' -- yoursqldumphere.sql
Read the rest

How to fix exim Could not complete sender verify

Check if you can reach a remote server

dig a

If this timeouts then try over one of dns resolver directly

[~]# dig @ a

; <<>> DiG 9.11.4-P2-RedHat-9.11.4-26.P2.el7_9.2 <<>> @ a
; (1 server found)
;; global options: +cmd
;; connection timed out; no servers could be reached

Timeout means DNS resolver is dead

[~]# cat /etc/resolv.conf
Read the rest

How to change WordPress site URL and home URL using wp-cli tool

To check site url:

wp option get siteurl

To update your website’s URL:

wp option update home ''
wp option update siteurl ''

This will update to MySQL records “home” and “siteurl

To run in-deep updates read the following article: the rest

How to install/reinstall mailman on cPanel server

Check Tweak Settings, should be ‘0’

cat /var/cpanel/cpanel.config |grep skipmailman


Deprecated scripts

/usr/local/cpanel/bin/mailman-install --force

To install mailman run the following:

/usr/local/cpanel/scripts/update_local_rpm_versions --edit target_settings.mailman installed
/usr/local/cpanel/scripts/check_cpanel_rpms --fix --targets=mailman

Run upcp:

/scripts/upcp --force
systemctl start mailman.service

Job for mailman.service failed because a configured resource limit was exceeded.

Read the rest