til

Things I've Learned

Categories

• Bash
• Common_Knowledge
• Drupal
• FFMPEG
• Git
• IIS
• JavaScript
• Kentico
• MacOS_X
• Magento
• MySQL
• PHP
• Postfix
• PostgreSQL
• RegEx
• SSH_SSL
• Ubuntu

---

Bash

• Apache Log Processing - Top IP Addresses

Common_Knowledge

• Military Addresses
• Quotes
• US States Copy List

Drupal

• Field Collections - Update older betas
• Fix File Content Permissions
• Notes on REST calls in Drupal 8

FFMPEG

• FFMPEG Crash Course

Git

• Bigger postBuffer

IIS

• Increase File Upload Limit
• Setup SSL Key for IIS

JavaScript

• Return an array of unique values

Kentico

• Custom Transformations
• Filter on Category
• Hide Pages From Navigation
• Order Content By Tree View

MacOS_X

• Delete Time Machine backup via command line
• How to raise the ulimit or How to solve the "Too many open files in system" problem
• How to securely delete a file on MacOS X (sort of...)
• How to securely erase free space on a Mac HD/SSD (sort of...)
• Disable Software Update Notification 'Red dot' on Dock

Magento

• Careful About /var/cache
• Change the baseurl Directly in the MySQL Database
• Changing the Default Order of Products
• Configuring/Altering URL Patterns
• Delete test orders
• Deleting gallery images quick
• Finding Current Skin Path in Magento
• Get FrontEnd for Emails
• How to change a product dropdown attribute to a multi-select in Magento
• How to Clear "Bestsellers" Reporting
• How to get product categories and the parent category of a subcategory in Magento
• How to View and/or Set the Order Incremental ID
• I can't login to Magento admin!
• Magento / Authorize.net "Transaction ID 0" problem in test mode
• Magento / UPS API Integration setup
• Magento 1.9 on PHP7
• Managing URL Rewrites In Magento
• Pulling Sales Info from Database in SQL
• Reloading a collection is sometimes necessary
• Set First Gallery Image to Base Image (and more...)

MySQL

• Optimize Tables By Command Line
• Backup Large Databases

PHP

• PHP Performance Tweaks - Pt.1

Postfix

• Why won't mail send? "Network is unreachable"

PostgreSQL

• A Crash Course in PostgreSQL
• Basic user privilege adding

RegEx

• Extract a video id from a wide variety of YouTube URLs

Ubuntu

• Screw-it - just update everything
• Truncate a File While Maintaining Permissions
• Updates Held Back - How and Why?

SSH_SSL

• How to Extract a Public Key from a Private Key
• How to Extract Organizational Details from a CSR

---

About

I shamelessly stole this idea from thoughtbot/til and jbranchaud/til