How To DROP DATABASE LIKE In MySQL

Author: , Posted on Tuesday, January 21st, 2020 at 6:01:23pm

How To Fix Bamboo Start Errors After Java Upgrade

Author: , Posted on Tuesday, January 21st, 2020 at 10:40:40am

PROBLEM DEFINITION

Bamboo Catalina error found in catalina.out:

SOLUTION SUMMARY
Correct by using Java 8 instead.

Do it manually using alternatives --set, or interactively using alternatives --config.

MANUAL PROCEDURE – two steps, one for java and one for javac

INTERACTIVE PROCEDURE – two steps, one for java and one for javac

How To Fix “TypeError: Language code” JavaScript Errors in WordPress

Author: , Posted on Monday, January 20th, 2020 at 8:08:13am

PROBLEM
Wordpress site broken with Javascript errors with zero plugins or themes installed.
The issue followed different devices, OS’es and different browsers.

SOLUTION
User account corrupted.
The wp_usermeta locale field had an invalid value of “regular”, and nulling the field solved the issue.

DETAILS
JS console shows this:

How To Use a PEM File With rsync

Author: , Posted on Friday, January 10th, 2020 at 2:30:39pm

Use the -e option like so:

How To Convert An RSA Private Key to PEM Format

Author: , Posted on Friday, January 10th, 2020 at 12:04:42pm

How To Properly Specify Command and Arguments to Exec in Perl

Author: , Posted on Wednesday, December 11th, 2019 at 2:39:49pm

When using Perl’s exec() call, the best way to invoke it is as follows:

This syntax does some important things:
– passes a scalar value as the first argument which exec interprets as PROGRAM
– passes an array as the second argument which exec will use as the arguments to pass into PROGRAM

Note the use of the parentheses, which I have found to be required for proper behavior.

For more information, please see: https://perldoc.perl.org/functions/exec.html

How To Change Your Commit Message in Git

Author: , Posted on Monday, December 2nd, 2019 at 8:15:31am

Not pushed + most recent commit:

How To Force vim to Convert Tabs to Spaces

Author: , Posted on Tuesday, November 26th, 2019 at 12:57:23pm

To create indents with 4 space characters which are entered by pressing the TAB key:

To make the above settings permanent add to your ~/.vimrc file.

For more details on any of these see :help ‘optionname’ in vim (e.g. :help ‘tabstop’)

tabstop
The width of a hard tabstop measured in “spaces” — effectively the (maximum) width of an actual tab character.
shiftwidth
The size of an “indent”. It’s also measured in spaces, so if your code base indents with tab characters then you want shiftwidth to equal the number of tab characters times tabstop. This is also used by things like the =, > and < commands. softtabstop
Setting this to a non-zero value other than tabstop will make the tab key (in insert mode) insert a combination of spaces (and possibly tabs) to simulate tab stops at this width.
expandtab
Enabling this will make the tab key (in insert mode) insert spaces instead of tab characters. This also affects the behavior of the retab command.
smarttab
Enabling this will make the tab key (in insert mode) insert spaces or tabs to go to the next indent of the next tabstop when the cursor is at the beginning of a line (i.e. the only preceding characters are whitespace).

How To Remove the MacOS Quarantine Extended File Attribute for an Entire Directory Tree

Author: , Posted on Sunday, November 24th, 2019 at 9:00:34am

xattr -r -d com.apple.quarantine {dirname}
~or~
xattr -r -d com.apple.quarantine *

How To Prevent WordPress from Applying wpautop to a Page or Post

Author: , Posted on Tuesday, November 19th, 2019 at 1:56:03pm

All credit to Graham Walters for this excellent plugin and post, upon which this post is based – thank you, sir!
https://grahamwalters.me/lab/disable-wpautop-on-specific-postspages/

Recently, a client was having problems using a plugin called by a shortcode. As it turned out, the JavaScript embedded in the returned content was being broken by the WordPress auto-paragraph feature known as wpautop.

Thank to a bit of research, I found the following solution, recorded here in case the original blog post becomes unavailable.

  1. Create the file wp-content/plugins/disable-wpautop/disable_wpautop.php based on the code below the procedure.
  2. WordPress » Admin » Plugins » Activate “Disable wpautop”
  3. Go to the page or post to disable the auto-paragraph feature on
  4. If the Screen Options tool is not visible below, locate the Screen Options button in the upper right corner, open it and check the box labeled Custom Fields.
  5. Locate the Custom Fields tool box below, and inside of it the header “Add New Custom Field:”, and under that click on “Enter New”.
  6. Enter wpautop as the Name, and false as the Value, then click the “Add Custom Field” button.
  7. Click the ‘Update’ button to save the settings.

wp-content/plugins/disable-wpautop/disable_wpautop.php: