~/talk

Curing a Critical Security Bug

Talkat WordCamp US 2015 · 2015-12-04..12-06· [security, wordpress]
links:none on file
slides:none on file

The Trojan emoji bug is a MySQL truncation issue that cuts a string immediately before an unsupported character (emoji), turning otherwise validated HTML into injectable payloads and enabling XSS and potential full site takeover; about 95% of sites used the legacy utf8 MySQL set. Fix adds preflight checks in WP_DB that test inserts and reads, uses a utf-8 regex + MySQL validation instead of unreliable mbstring conversions, handles column-length truncation and legacy charsets, and ships via WordPress auto-updates.

AI-written summary · about

  1. 0:00Introduction to Trojan emoji bug
  2. 4:54Root cause and impact
  3. 11:35Developing the fix
  4. 15:55Lessons learned
  5. 17:43Team and acknowledgments
  6. 18:04Q&A begins
  7. 18:32Supporting legacy configurations
  8. 19:36Impact on other CMS
  9. 20:38Emoji inclusion rationale
  10. 21:42WordPress security team
  11. 22:47Bug severity explained
  12. 23:53Working with character sets
  13. 24:36Tracking security breaches
  14. 25:41Rolling out the fix
  15. 26:28Closing remarks
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.