How to fix a login issue after WordPress Multisite split

The slave installation will lose users

wp user list

+—-+————+————–+————+—————–+——-+
| ID | user_login | display_name | user_email | user_registered | roles |
+—-+————+————–+————+—————–+——-+
+—-+————+————–+————+—————–+——-+

And you won’t be able to create new admin user because you don’t have appropriate MySQL tables

wp user create admin [email protected]
Read the rest

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

Error:

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

Example:

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

or

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

How to deal with “ea-php72” is not an EA4 SCL PHP error

Go to your WHM –> Home –> Software –> MultiPHP Manager

You should be able to resolve this by changing the domains to use an available version of PHP, or by installing the missing PHP versions.

You need to either install missed PHP version or set it to inherit

Command line solution:

Find main domain of account in issue and run:

whmapi1 php_set_vhost_versions version=inherit vhost=domainname.com
Read the rest

How to fix exim Could not complete sender verify

Check if you can reach a remote server

dig a gmail.com

If this timeouts then try over one of dns resolver directly

[~]# dig @8.8.8.8 a gmail.com

; <<>> DiG 9.11.4-P2-RedHat-9.11.4-26.P2.el7_9.2 <<>> @8.8.8.8 a gmail.com
; (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 'https://alltime.pp.ua'
wp option update siteurl 'https://alltime.pp.ua'

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

To run in-deep updates read the following article:

https://alltime.pp.ua/blog/how-to-change-wordpress-main-url-to-new-one/Read the rest

How to install/reinstall mailman on cPanel server

Check Tweak Settings, should be ‘0’

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

skipmailman=0

Deprecated scripts

/scripts/reinstallmailman
/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