That error happens because with sql_mode including NO_ZERO_DATE or STRICT_TRANS_TABLES

That error happens because MySQL 5.7+ (and MariaDB 10.2+) with sql_mode including NO_ZERO_DATE or STRICT_TRANS_TABLES no longer allows default datetime values like '0000-00-00 00:00:00'.

SET GLOBAL sql_mode = '';

SET SESSION sql_mode = '';

Change Path Word Press from Old to New Domain

 UPDATE wp_options SET option_value = REPLACE(option_value, 'old-domain.com', 'new-domain.com');

UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, 'old-domain.com', 'new-domain.com'');

UPDATE wp_posts SET guid = REPLACE(guid, 'old-domain.com', 'new-domain.com'');

UPDATE wp_posts SET post_content = REPLACE(post_content, 'old-domain.com', 'new-domain.com'');

-----Check if your uploads URL setting is wrong-----

SELECT * FROM wp_options WHERE option_name = 'upload_url_path';

UPDATE wp_options SET option_value = 'https://old-domain.com/wp-content/uploads' WHERE option_name = 'upload_url_path';

wp-config.php

define('WP_HOME', 'https://new-domain.com');

define('WP_SITEURL', 'https://new-domain.com');

Updated IP Routing

 eth1 is DOWN (state DOWN) - it's not activated

No default route in the routing table

eth0 doesn't have an IP address assigned (or it's not showing in routing)

DNS is failing because there's no network connectivity

Let's troubleshoot step by step:

1. First, check if eth0 has the IP address:

bash

ip addr show eth0

2. Bring up eth1 interface:

bash

sudo ip link set eth1 up

3. Check current IP configuration:

bash

ip addr show

4. If eth0 doesn't have the IP, assign it manually:

bash

sudo ip addr add xxx.xxx.xxx.xxx/20 dev eth0

5. Add the default gateway:

bash

sudo ip route add default via xxx.xxx.xxx.x dev eth0

6. Test connectivity:

ping -c 4 xxx.xxx.xx.x  # Test gateway first

ping -c 4 8.8.8.8       # Test internet

Wordpress Error Image Upload: Missing a Temporary Folder

 1. Create .user.ini in your root directory (/var/www/xxxxxxxx/)

upload_tmp_dir = /var/www/briskcoin.org/wp-content/temp

2. sudo systemctl restart apache2