Bug Fix Report: 2026-04-15
Five issues were identified and resolved during today's session.
Issues Fixed
| # | Error | Root Cause | Fix |
|---|-------|-----------|-----|
| 1 | SystemPostService: Forum not found (slug: system-alerts-and-notices) | Stale error from previous code version | No action needed — code already uses correct slug important-alerts |
| 2 | Data too long for column icon (badges) | badges.icon was VARCHAR(10), too small for Font Awesome HTML tags | Widened badges.icon and achievements.icon to VARCHAR(255) |
| 3 | Email template not found: email-verification | Admin resend-verification used wrong template name | Changed to correct template name verification-code |
| 4 | Invalid parameter number (Achievement friends query) | PDO does not allow reusing named parameter :uid twice in one query | Added :uid2 as second parameter in friends query |
| 5 | Unknown column user_id in WHERE (Achievement post_edits) | post_edits table uses editor_id, not user_id | Changed query to use editor_id |
Files Modified
src/Models/Achievement.php— Fixed friends query parameter reuse (issue #4) and post_edits column name (issue #5)src/Controllers/AdminUserController.php— Fixed email template name for resend verification (issue #3)badges.iconcolumn — ALTER TABLE to VARCHAR(255) (issue #2)achievements.iconcolumn — ALTER TABLE to VARCHAR(255) (issue #2)
Verification
All errors were from today's log (app-2026-04-15.log). Each fix has been syntax-checked and the root cause confirmed resolved. Tomorrow's log should be clean.