Awaiting Feedback Pickem seems to have reverted ladders etc back to a previous week.

[BIGLLC]

This week all of our competitions seem to have reverted ladders etc backwards to an earlier week.

We've not touched anything in a while, not sure at all why this is happening.

This looks like it is back to about round 4 while AFL is up to round 16:

2025 Official BigFooty AFL Tipping - $1k Cash Prizes - Ladder through week 16

Australian Football League, 2025 AFL H&A and Finals

www.bigfooty.com

Survivor comp seems to have brought back a ton of players who have been eliminated:

Official 2025 BigFooty AFL Knockout Tipping - Game 2 - Week 15

Australian Football League, 2025 AFL H&A and Finals

www.bigfooty.com

Compared to:

Official 2025 BigFooty AFL Knockout Tipping - Game 2 - Week 16

Australian Football League, 2025 AFL H&A and Finals

www.bigfooty.com

Looking at this, week 16 is showing as week ID 415 as it might have been renamed after some games had to be moved from the opening round due to a cyclone? When they were re-scheduled maybe I renamed the round and changed the date? I am guessing this is not something anticipated by the software.

That's my best guess as to how this happened anyway.

So the week IDs go:
427 (round 14)
445 (round15)
415 (round 16)
447 (round 17)
448 (round 18)

Week 446 does not exist.

Any thoughts on how to fix this one? Move every game from round 16 onwards up one round up so the week IDs are in ascending order?

 

[Bob]

If you added the weeks IN ORDER like you are supposed to, round 16 should be week_id 446, not 415. The system would have generated that week_id after week_id 414! Round 15 is week_id 445, so the next week that you create, would have been round 16 and it would have been week_id 446 as they are auto incremented!

Any thoughts on how to fix this one? Move every game from round 16 onwards up one round up so the week IDs are in ascending order?

You can TRY this, but this is NOT an Official Supported Answer/Fix! In theory (untested) it should work.

If week_id 446 does not exist, then rename week_id 415 to week_id 446.

And of course, you'll also need to update all records in other tables that store week_id , so those records are correctly associated with week_id 446 instead of week_id 415.

Tables with week_id that you will need to make sure get updated as well.

• xf_xa_pkm_game
• xf_xa_pkm_pick
• xf_xa_pkm_pool_week_winners
• xf_xa_pkm_tie_breaker

Make sure to BACKUP EVERYTHING so that you can revert back if something goes wrong.