Unexpected Result in Player List

  • I am experience some unexpected behavior with player list. I have a list which list the players on a team. If I switch move a player from another team (eg Steve from Team 12 moves to Team 4) and I display a player list for Team 4, Steve correctly shows up on the list, but the Team Name he is listed on still shows as Team 12. Interestingly, if I edit the player list and do no changes but simply resave it, Steve will show with the correct Team name. Here is the link for the player list before editing:
    Incorrect Player List/

    Here is the link for the player list after resaving.
    Correct Player List/

    I’m concerned that the link to the old team is orphaned data in the database which should be erased when the player is moved to the new team.

    Questions:
    How to permanently fix the player list so it displays properly.
    How do I check the integrity of the sportspress data base to ensure that all data linkages are intact and there is no orphaned data?

    BTW, I have changed to the rookie theme to ensure the problem is not theme related.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 16 through 20 (of 20 total)
  • Thread Starter pcvcadmin

    (@pcvcadmin)

    OK. Thanks for verifying. Hopefully Brian has a suggestion.

    Plugin Contributor Savvas

    (@savvasha)

    Hi @pcvcadmin,

    Can you try the following fix to see if it is solving your issue?

    https://github.com/ThemeBoy/SportsPress/commit/7cc4ec19a0d29410199afa8e20fa121f538e1b77

    It will be included to our next update.

    Thanks,
    Savvas

    Thread Starter pcvcadmin

    (@pcvcadmin)

    Hi @savvasha, unfortunately it did not fix the issue. The displayed list in Team 4 still shows the old team. I replaced the player-list.php file with the modified one. Let me know if there are additional files which needed to be replaced.

    Also of concern: Clearly the association between the player (Steve) and his old team (Team 12) is being stored somewhere. That association should be deleted but it is not. That means even if the code is fixed to properly display his new team, there is still orphaned data in the database associating Steve with his old team. Over time there will be more and more of this orphaned data in the database without the ability to clean up the associations.

    Thread Starter pcvcadmin

    (@pcvcadmin)

    I guess there is no resolution on this?

    Plugin Contributor Savvas

    (@savvasha)

    Hi @pcvcadmin,

    I thought that the solution from @brianmiyaji (see GitHub patch) has solve it.

    Sorry about that. We will dig to it a little bit further for a solution and let you know.

    Thanks,
    Savvas

Viewing 5 replies - 16 through 20 (of 20 total)
  • The topic ‘Unexpected Result in Player List’ is closed to new replies.