This is a huge problem that is even affecting my own games from 2004. Database searches indicate that it affects FinishedGames and GameLogs, but it doesn't affect GameSettings or OngoingGames. Since it didn't affect OngoingGames, it flew under the radar for people who didn't look back at past games. The solution has two parts. One is to clean the database. I will probably have to use a script, since a mass delete might get some rows that shouldn't be deleted. The other is to figure out what caused this and stop it. In urlencoded URLs, the + sign is sometimes used to represent the space. So, it looks like it has been saving urlencoded game names into the database. Since I know which tables in the database have been affected, I know to look at the scripts that write to those tables and to compare them to those that write to the unaffected tables.
This is a huge problem that is even affecting my own games from 2004. Database searches indicate that it affects FinishedGames and GameLogs, but it doesn't affect GameSettings or OngoingGames. Since it didn't affect OngoingGames, it flew under the radar for people who didn't look back at past games. The solution has two parts. One is to clean the database. I will probably have to use a script, since a mass delete might get some rows that shouldn't be deleted. The other is to figure out what caused this and stop it. In urlencoded URLs, the + sign is sometimes used to represent the space. So, it looks like it has been saving urlencoded game names into the database. Since I know which tables in the database have been affected, I know to look at the scripts that write to those tables and to compare them to those that write to the unaffected tables.