User ranking zero for all users

  • Resolved treb2021

    (@treb2021)


    3 years, 9 months ago

    Hi,

    I have a EK2020 football pool. Users have entered predictions.
    Dates and times working correct, users can enter or update predictions till 5 minutes before a match will start.
    Scores for first four matches are entered in admin panel, calculations running very fast.
    Still a message is shown, no results yet, a list off all users is shown with 0 points.
    When I click on a username in this list I get the list with real scores, user predictions and points for all games played for that user.
    When I click on View predictions of other players a get a list with all users, their predictions, use of joker and points. (statistics page):

    Playername home away points
    Player 1 0 – 3 7
    Player 2 1 – 2 2
    Player 3 1 – 2 2

    The tables scorehistory_s1_t1 and scorehistory_s1_t2 are empty.

    What can be the problem and how to solve it?

    Thanks in advance!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author AntoineH

    (@antoineh)

    calculations running very fast

    The tables scorehistory_s1_t1 and scorehistory_s1_t2 are empty.

    The reason your calculations are running fast, is because it is not doing anything. Otherwise, your scorehistory tables should contain data.

    Can you check if you have data in your rankings and leagues tables? If one of them is empty (or both are), then execute the relevant query to enter the default values again*:

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

INSERT INTO pool_wp_leagues (id, name, user_defined, image)
VALUES (1, 'all users', 0, '');

    *) change table names if you have a different prefix

    • This reply was modified 3 years, 9 months ago by AntoineH. Reason: Added sql to fix empty tables
    Thread Starter treb2021

    (@treb2021)

    pool_wp_leagues has data, 2 records
    pool_wp_rankings was empty.
    Query excuted, has 1 record. ??
    Recalcutaltion done, rankings updated!
    Use graphics activated and also working!

    Problem solved ??

    Thanks a lot for the very quick and usefull help, even on a Sunday!!
    TOP

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘User ranking zero for all users’ is closed to new replies.