This happens whenever there are tinyint rows used to store data that is not 0 or 1, which was the case for the team row in the forts_sightings table. This only started happening when we combined scanning with raid submission, as scanning labels the team id of gyms..
The mysqlconnector will sometimes throw Unable to cast object of type 'System.Boolean' to type 'System.SByte'.
Which, there is a standard solution https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql/issues/285 (Add "TreatTinyAsBoolean=false;" to your connection string)
This happens whenever there are tinyint rows used to store data that is not 0 or 1, which was the case for the team row in the forts_sightings table. This only started happening when we combined scanning with raid submission, as scanning labels the team id of gyms..