Football Pool
[resolved] Points totally crazy (7 posts)

  1. Millvi
    Posted 4 years ago #

    When I add the result for Russia-Czech republic the total points for user get all messed up.
    When I delete the result the points get even more crazy.
    The points get multiplied in some strange way.



  2. Millvi
    Posted 4 years ago #

    The points are right when I look at my on predictions and all other predictions.
    It´s just the point at the page with the list with all players that is totally wrong.
    Everytime I remove the score on a game the scores get multiplied in som estrange way.


  3. AntoineH
    Plugin Author

    Posted 4 years ago #

    update: a few seconds too late to see your post. I'll have a look at your page.

    Can you post some more details about your setup? Version of the plugin, WordPress, PHP and MySQL? Are you using leagues? Using bonus questions?

    The calculation of the scores is a complicated piece of code. That makes it hard to debug. So it won't be easy to pinpoint the problem.
    But it is also one of the oldest pieces of code that is in the plugin. So I'm somewhat surprised with this behaviour.

    Are you absolutely sure the results are off? Not caused by users that have a joker set for a game or bonus question points that are added?

  4. Millvi
    Posted 4 years ago #

    Football pool: Version 1.4.1
    Wordpress: Latest
    PHP and MySQL is up to date at my host but not sure exactly wich versions.

    Im not using leagues
    Using bonus questions

    Look at my page and you will se that it is really messed up.

    Everytime the scores are recalculated for some reason the scores get even more crasy.

  5. AntoineH
    Plugin Author

    Posted 4 years ago #

    The (re)calculation of the score-table does have a multiply factor (points x joker-doubler). But it starts with a TRUNCATE TABLE statement to start with zero points.

    Can you check if you have TRUNCATE TABLE rights on the database?

  6. Millvi
    Posted 4 years ago #

    Worked like a charm!!!


  7. AntoineH
    Plugin Author

    Posted 4 years ago #

    I updated my development code with some extra checks and a DELETE FROM fallback method. Future update will handle this better (or at least give a proper error message).

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Football Pool
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.