Wednesday, October 8, 2025

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');



Wednesday, August 20, 2025

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


Friday, June 6, 2025

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

Tuesday, January 31, 2023

Install Cocoapods on Xcode Project

------Install-----

1.  CD into the project directory 

2. pod init

3. pod install

-------Update----

1. pod update

------ Remove---

1. pod deintegrate



Friday, March 4, 2022

Run Python with Apache on Ubuntu

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


Saturday, January 15, 2022

After installed GCI Windows Server 2019 still error

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