When Asynchronous saves enabled, wrong number of predictions are been shown

Hard to tell what the cause is. The report does a simple join query on the predictions and users table. Only thing that I can think of, is a corrupt row in the predictions table. Can you post a CSV dump of this predictions table? This will only contain numbers, no PII data.

Here is a dump of the predictions table: https://www.dropbox.com/scl/fi/unohgl32wirs152ht6u89/pool_ol24_predictions.csv?rlkey=qlnfdcya9tk7gpexo42t0fkgw&dl=0

The table contains null values for a match with ID = 0 (which does not exist). Not sure how these rows ended up in your database, but you can remove them by executing the following query (please always create a database back-up first!):

DELETE FROM pool_ol24_predictions 
WHERE match_id NOT IN (SELECT id FROM pool_ol24_matches);

Assuming your db-prefix is pool_ol24_ based on the filename of your dump. If not, then adjust the 2 table names in the query accordingly.

Thanks a lot, deleting the 3 rows did the trick. Now running the “Football Pool Report” it calculates correctly.
Maybe the switch from manuel saves to asynchronous saves, did something with the NULL values, it’s the only change that has occurred.