FunTester

Sep 20, 2020 · Databases

When VIP Expiration Hits 2038: The MySQL INT Overflow Bug

A hidden bug occurs when a user's VIP subscription is repeatedly extended, causing the stored expiration timestamp to exceed MySQL's signed INT maximum of 2147483647 (January 19, 2038), which prevents the date from being saved correctly.