Tables not updating

0 votes
Hi,

I use the following tables for my betting purposes:

Historic tables:

historic_runners_beta

histroic_races_beta

historic_betfair_win_prices

Daily tables:

daily_runners_beta

daily_races_beta

daily_betfair_mappings

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 (300 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 (19,280 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?

Thanks
...