This SQL string will extract multiple meta values from an order.
Firstly disable automatic times Then simple set the time manualy, or the time itself will still automatically update. To re-enable automatic date/time updates use To check the status use You should see something like below. the three ‘no’ mean it’s disabled.
Often the Ubuntu upgrades will fail fue to a no space error. The only solution is to remove old kernels manually. The first step is to show which kernel you are currently running, as you do not want to delete this one. So change to the boot directory for simplicity and list all existing kernels […]
Using the WordPress REST API with JWT authentication Step 1. Install this plugin => https://wordpress.org/plugins/advanced-access-manager/. The free version will suffice. This goes on the site you will be xtracting data from. The REST API must be enabled in the WordPress settings. Step 2. Configure the plugin and on it’s Settings tab add the Secret as […]
This applies to self-managed Apache2 servers. Shared servers require different permissions, for example wp-config : set that file’s permissions to 440 or 400. Site Lockdown File permissions to lock down website, from the websites home folder. Do this from the root directory for example and you will break your server. Change the folder ownership of […]
To enable ssl on a localhost website, and stop Chrome from showing is as “unsafe” …. Pertains to Ubuntu 18.04 Bionic, and running Apache 2.4.29 Create localhost.cnf Then use openssl to generate the certificates in 3 steps Edit /etc/apache2/sites-available/default-ssl.conf as below Enable the site … and restart Apache2 As things stand you will be asked […]
Below is a very simple working example of a plugin. Create a directory in your plugins directory, create a php file and copy the below into it. Then from the wordpress plugins menu simply activate it. Just know that this plugin does absolutely nothing other than to show the basic setup, including public and protected […]
As Open Office is part of the standard Ubuntu install, like other software installed as default, I have not listed it. There are a number of must have applications needed to get the most out of Uubuntu 18.04, but first thing to do is change the deskop. Ubuntu’s standard is way too slow and reminds […]
Pertains mostly to Ubuntu 18.04.4 and Apache 2.4.29 Get Ubuntu version Get Apache version Get MySql version Find Files and hide all permission denied messages Copy file with ssh from server to localhost Copy file from localhost to server with ssh Copy directory from server recursively with ssh Copy directory to server from localhost recursively […]
Covers WordPress version 5.3.2 No matter how you use the SQL, be it on the command line, PhpMyAdmin or PHP, These are just the SQL commands needed. There are 4 tables invlovled not counting the variable product data. I’ll be adding that as soon as a get a free moment. wp_posts wp_postmeta wp_woocommerce_order_items wp_woocommerce_order_itemmeta wp_posts […]