stall in calculation and i cant fix it

Same for me, would love some solution to this.

Hi! Same for me!

And Debug log show it:

[20-Nov-2022 19:18:50 UTC] PHP Fatal error: Football Pool => default ranking with ID 1 is missing in the pool_wp_rankings table in /wp-content/plugins/football-pool/admin/class-football-pool-admin-score-calculation.php on line 1080

Any solution?
Thanks

• This reply was modified 2 years ago by andre.piovesan.
• This reply was modified 2 years ago by andre.piovesan.

@andrepiovesan thanks for posting the error. For you this error can be resolved by adding the default ranking back in the database. Please try executing the below query in a tool like phpMyAdmin:

INSERT INTO pool_wp_rankings (id, name, user_defined, calculate) VALUES (1, 'default ranking', 0, 1);

@elmariachi09 @pafelopez124 if you post the error in your error log, I may be able to help you. Without this info I do not know what the root cause is.

Thank you @antoineh!
It worked! ??

i had the same log thatandre. do the insert and now works. Thxs!

Hello, I have the following error messages:

-There is already a calculation in progress. Please wait for it to finish before starting a new one.

– Step ‘question_scores’: Something went wrong while (re)calculating the scores. See the help page for details on solving this problem.

I put the code to the sql, but I got the following error message:

#1442 – Can’t update table ‘pool_wp_rankings’ in stored function/trigger because it is already used by statement which invoked this stored function/trigger`

Could help me please anyone?

• This reply was modified 2 years ago by szucsibalazs.

I checked the sql structure is ok, if I see it right. Here is the screen: https://sulysapma.hu/phpmy.jpg

@szucsibalazs To be honest, I have no idea what is going wrong. Do you have a trigger defined on this table?
Can you show which rows are currently available in your pool_wp_rankings table?

Dear Antonie, thank you for your answer! I sent you an email regarding this issue.

If we change the constant in define.php to other than 1, then the calculation will stall / stuck forever. I had to change back this to 1 then the calculation works again. In my case, i initially set group stage id = 2 for this constant so that when user click on Ranking (user selected) it will default to the Group Stage ranking which was what I wanted. Unfortunately, I had to change this back to 1 because of the stalling recalculation.

const FOOTBALLPOOL_RANKING_DEFAULT = 1

What is default ranking anyway? Does it calculate all scores in all groups?

hi @af3, if you change code or constants in the plugin that are not meant to be overwritten then you are skating on thin ice ??

The FOOTBALLPOOL_RANKING_DEFAULT is a very important constant and it should not be changed. It indeed defines the overall ranking that contains all scores for all matches and questions.

If you want to change the default display ranking to something else, you can change your menu to point to the ranking page plus the ranking in the querystring, e.g. “/my-ranking-page/?ranking=2”. That is, if you have the option for “Ranking to show” set to “Let the user decide”. You can also set this option to “Custom” and then set it to the ranking that you want to always (and only) show this ranking.

Hope this helps.

Thank you so much for the info @antoineh !