Code Singularities

Technical implementations and algorithms

One SKU, Five Markets: Where the iPhone 18 Pro Pre-order Broke

One SKU, Five Markets: Where the iPhone 18 Pro Pre-order Broke

Eight availability queries across five markets in the first half hour of iPhone 18 Pro pre-orders. Pro Max 1TB Burgundy was at zero in Hong Kong and Shenzhen while Pro Max 2TB sat in stock down the road, which makes this SKU concentration rather than a shortage.

W

What Is SSO? From 玉玺 to WeChat Login

Guan Yu had to fight through five gates. You just click "Sign in with WeChat." A culturally-biased look at what Single Sign-On really is, why Asia's SSO story is different from the West's, and the price of one seal that opens every door.

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.

X

Xiuno BBS 4.0 Download

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

What Each File in Typecho's Admin Directory Does

What Each File in Typecho's Admin Directory Does

A file-by-file reference for Typecho's admin directory — handy when hacking on the backend.

Troubleshooting ionCube Loader on aaPanel (宝塔)

Troubleshooting ionCube Loader on aaPanel (宝塔)

Two causes of "ionCube Loader not installed" on aaPanel: it really is missing, or multiple PHP versions each have their own ionCube.

W

WHMCS 7.x: "Something went wrong and we couldn't process your request" After Moving Servers

Moving WHMCS to a new server hit the generic Oops page. The culprit: a leftover DirectAdmin addon encrypted for PHP 5.6.