Started by Daniel Hofverberg, November 09, 2020, 08:30:02 PM
Quote from: Daniel Hofverberg on November 12, 2020, 06:58:42 PMFor some reason, the database had a default collation of that weird utf8_mb4_0900_ai_ci, which I have never willingly opted for.I can only assume it must have happened when I recently switched to a new server host (as the old host shut down) - it seems that utf8mb4_0900_ai_ci is the default collation since MySQL 8.0 (for some strange reason), so apparently it must have used the default for the database itself when I imported the dump from the old server. Very annoying... I'm so sorry for wasting your time with something that apparently wasn't SMF Arcade's fault.
Quote from: Chen Zhen on November 13, 2020, 10:10:56 PMI assume this is only occurring for games from E-Arcade?If you have the "Auto Adjust Improper Save Types" option enabled then it is likely adjusting the save type the first time when played and a score save has been attempted.E-Arcade did not have game save types in the database therefore some games that were from E-Arcade & never played on SMF Arcade will have the wrong save type in the database (default is SMF v1). With the above option enabled, SMF Arcade should attempt to adjust the save type for you as scores are saved to the database. Unfortunately the game may not save a score the first time because the arcade had to adjust it afterward. You can also use "Enable save type debug logging" temporarily in the arcade settings to see if this is happening so when it adjusts a game it will put a message in the error log.You don't have to keep the setting enabled all the time but it's there to debug these type of problems so you can see what's going on.
Quote from: Chen Zhen on November 17, 2020, 05:33:28 PMIf you have that enabled and saved in arcade settings the member scores should be posted to the arcade shoutbox. Arena and guest scores also have a setting for it.