Tables not updating

0 votes

I use the following tables for my betting purposes:

Historic tables:




Daily tables:




From these, the historic tables have stopped updating since 07th July 22; derived from max(loaded_at) from those tables.

The daily tables are updating fine.

I have checked my Task_scheduler (windows) and can see the updates are still enabled and running.

Can you please advise how to fix this; i.e. retrieve the missing data and re-enable the updates for historic tables.

Let me know if you need any further information on this.

Thanks , Naga
asked Nov 15, 2021 in Smartform by chakradharmn Novice (260 points)

1 Answer

0 votes
Hi - if updates are not fetched for more than 60 days then the data tables need to be re-installed.  It sounds like this is what has happened in your instance.  

In this case, you need to re-install the tables by downloading and installing (n.b. the usual install procedure in MySQL will replace your existing, out of date, tables) the latest full tables from the download page after logging in with your membership details.  Once you have installed the latest tables, the updates should work as usual.
answered Nov 16, 2021 by colin Frankel (18,110 points)
Hi Colin,

Thanks for your reply.
I have reinstalled the tables as per your advise.

I still have the same issue, where by:

My historic tables (i.e. histroic_races_beta, historic_runners_beta, histroic_betfair_win_prices) aren't updating daily. The last update is when I reloaded them.
My daily tables (daily_races_beta, daily_runners_beta, daily_betfair_mappings) seem to update fine.

Can you please advise?