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 = '';
Discover and enjoy a wide range of IT solutions designed to make your digital experience smoother, faster, and more efficient. From software tips to troubleshooting guides, find everything you need in a place. Stay updated, stay secure, and enhance your tech skills with reliable, user-friendly information and resources.
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 = '';
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');
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
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
------Install-----
1. CD into the project directory
2. pod init
3. pod install
-------Update----
1. pod update
------ Remove---
1. pod deintegrate
sudo apt-get install libapache2-mod-wsgi-py3
sudo apt-get install python3 libexpat1 -y
sudo apt-get install apache2 apache2-utils ssl-cert libapache2-mod-wsgi -y
a2enmod cgid
sites-available
Non-SSL
<VirtualHost *:80>
ServerName xxxx
ServerAlias xxxx
<Directory /var/www/xxxx>
Options +ExecCGI
AddHandler cgi-script .cgi .py
Allow from all
DirectoryIndex index.py
</Directory>
ProxyRequests Off
ProxyPreserveHost On
ProxyVia Full
<Proxy *>
Require all granted
</Proxy>
<Location />
ProxyPass http://xxxx:port/
ProxyPassReverse http://xxx:port/
</Location>
DocumentRoot /var/www/xxxx
</VirtualHost>
SSL
<VirtualHost *:443>
ServerName xxx
ServerAlias xxx
SSLEngine on
SSLCertificateFile /etc/ssl/certs/xxxx
SSLCertificateKeyFile /etc/ssl/private/xxxx
SSLCertificateChainFile /etc/ssl/xxxx
<Directory /var/www/xxxx>
Options +ExecCGI
AddHandler cgi-script .cgi .py
#Order allow,deny
Allow from all
AllowOverride All
#Options +ExecCGI
DirectoryIndex index.py
Require all granted
</Directory>
ProxyRequests Off
ProxyPreserveHost On
ProxyVia Full
<Proxy *>
Require all granted
</Proxy>
<Location />
ProxyPass http://xxxx:port/
ProxyPassReverse http://xxx:port/
</Location>
DocumentRoot /var/www/xxxx
ErrorLog ${APACHE_LOG_DIR}/error.log
CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>
systemctl restart apache2
Home page of py added the first line: #!/usr/bin/python If python app is version 3 so need to map python to python3 Check Apache log sudo tail -f /var/log/apache2/error.log Check python version python --version
Note: Python app must be up service
This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false".
Solution:
%windir%\system32\inetsrv\appcmd.exe unlock config -section:system.webServer/handlers