richpri / board18v2 Goto Github PK

The email column in the players table in the Board18 database is created as a varchar(25). This is too short for some people's email addresses, and this will result in a player's email address getting truncated when their record is created or updated.

According to errata 1690 to RFC 3696 the maximum usable email address length is 254 characters, so this might make a better default for this column.

Steps to reproduce what I'm seeing, using Chrome:

1. Navigate to https://prod1.board18.org/board18Map.php?dogame= to play a game, take a turn
2. Leave tab open for a few hours
3. Come back to the tab to take my next turn
4. Observe a 404 in console
5. Taking actions in the game have no effect, more 404s in the logs
6. No strong UI indication that the actions are failing, but observe that the "Your action has been successfully updated in the database" text is not displayed.
7. Someone has to tell me that my actions did not take effect

Refreshing the page fixes the problem. My group is seeing this frequently across all players. I think this is a regression in the last 1-2 weeks.

See attached console log. Let me know if I can provide more info.

Adding a more prominent error message in the UI to prompt a refresh would be fine, but ideally we can get this back to how things were a few weeks ago where long-running tabs did not hit 404s.

prod1.board18.org-1600129071095.log