Code Singularities

Technical implementations and algorithms

U

Unknown collation: 'utf8mb4_0900_ai_ci' — MySQL Error

Importing a MySQL dump fails with "Unknown collation: utf8mb4_0900_ai_ci"? Find-and-replace it with utf8mb4_general_ci.

Flushing the Local DNS Cache

Flushing the Local DNS Cache

How to flush the local DNS cache on Windows, macOS and Linux.

M

Microsoft Office Account Issue — "Sorry, another account from your organization is already signed in on this computer"

Office won't let you add a work account? Clear the cached credentials and the Identity registry key, then sign in again.

X

Xiuno BBS 4.0 Download

Xiuno BBS 4.0 — a lightweight PHP forum product, archived here after the open-source project closed.

R

Recommended: Sleeky — a Good-looking YOURLS Theme

Sleeky is a clean frontend theme for the YOURLS URL shortener.

C

Compress Your CSS with PHP

Serve CSS through a style.php that strips comments and whitespace on the fly.

A

AlphaSSL SHA-256 Root CA Certificate

The AlphaSSL CA SHA256-G2 intermediate certificate (SHA-256, RSA 2048), for orders from March 31, 2014 onward.

R

Register for Google Services Without an @google.com (@gmail.com) Address

The signup link that lets you register a Google account with your own existing email address.

I

Icons and Browser Colors | Chrome

How to feed browsers the right icons, tiles and theme colors: favicon sizes, apple-touch-icon, msapplication tiles and theme-color.

R

Recommended: Cactus — a Responsive, Clean and Elegant Typecho Theme

Cactus — a clean, responsive Typecho theme ported from the Hexo theme of the same name.