Errors in calculations

If you post the actual error messages (see this topic) I can help.

Hi Antoine,

Ive tried adding your code for debug, but no files are being generated in wp-content!

the error message i am seeing is as follows

Something went wrong while (re)calculating the scores. Please check if TRUNCATE/DROP or DELETE rights are available at the database and try again.

I am also seeing the rankings in random order on the ranking page and in widgets

notyet1

If the calculation is not completed, then the rankings won’t be right. One of the steps in the calculation process is to calculate the rankings of the players over time based on their scores.

If no errors are logged, then my best guess is that you run into a server time-out.

You can try to add the following lines to your wp-config and lower the values (the values posted here are the defaults).

define( 'FOOTBALLPOOL_RECALC_STEP2_DIV', 50 ); // add match results for players
define( 'FOOTBALLPOOL_RECALC_STEP3_DIV', 100 ); // calculate scores for match results
define( 'FOOTBALLPOOL_RECALC_STEP4_DIV', 50 ); // calculate scores for bonusquestions
define( 'FOOTBALLPOOL_RECALC_STEP5_DIV', 50 ); // history of score over time
define( 'FOOTBALLPOOL_RECALC_STEP6_DIV', 4 ); // history of ranking over time

The most time-consuming steps are step 5 and 6. So start with lowering those values.

A lower value will cause the script to divide the calculation in smaller sub steps.

If the calculation is not completed, then the rankings won’t be right. One of the steps in the calculation process is to calculate the rankings of the players over time based on their scores.

If no errors are logged, then my best guess is that you run into a server time-out.

You can try to add the following lines to your wp-config and lower the values (the values posted here are the defaults).

define( 'FOOTBALLPOOL_RECALC_STEP2_DIV', 50 ); // add match results for players
define( 'FOOTBALLPOOL_RECALC_STEP3_DIV', 100 ); // calculate scores for match results
define( 'FOOTBALLPOOL_RECALC_STEP4_DIV', 50 ); // calculate scores for bonusquestions
define( 'FOOTBALLPOOL_RECALC_STEP5_DIV', 50 ); // history of score over time
define( 'FOOTBALLPOOL_RECALC_STEP6_DIV', 4 ); // history of ranking over time

The most time-consuming steps are step 5 and 6. So start with lowering those values.

A lower value will cause the script to divide the calculation in smaller sub steps.

Hi Antoine

Its working to a degree, all functions are fine with above settings, except the last, which ive lowered to 1 This is getting past the first ranking but its hanging on the update ranking 2 step 40+

Thanks
Notyet1

ok, was running the update again while typing that last message, and its now completed.

Thanks
Notyet1

I sure hope it keeps working, because there is no more lowering of the values after 1.

I haven’t seen this before with 400 users. I’ve heard of installs with a lot more users that also work with the default settings.