username:   password:

error message on daily update to smartform database for historic_runners_insights table

0 votes
error message:

Fetching data from: https://www.betwise.co.uk/smartform_data/xxxx/xxxxxxxxx/xxxxxxxx/historic_runners_insights.sql
could not execute SQL statement: Error 1054: Unknown column 'listed_race' in 'field list'
in Smartform by ronbarr Novice (230 points)

1 Answer

0 votes
There is a new version of the historic_runners_insights table.  This should be downloaded at the usual place, then the updates will work.

We will shortly be uploading a new table definition and sending out a general email about it.
by colin Frankel (19.7k points)

Welcome to the Betwise Q&A, where you can ask questions and receive expert answers from other members of the community.

Choose a category and ask your question!

Categories

Most popular tags

smartform betfair r database package mysql data database-update api api-ng historic_runners sql daily-runners historic_races_beta historic_runners_insights horse-racing handicap error oddsline manual automatic-betting daily_races_beta updater beta accessing-database bug getmarket speed-rating betfair_win_prices data-error cloud inconsistencies sp australia - excel results price race_type form frankel ratings forecast_price racecards perl programming bookmaker query-history entries historic-runners betfair-sp daily_runners_beta historic_runners_beta handicap-race-range out-of-the-handicap -rmysql understanding aws subscriptions abandoned advanced_going commercial yards abettor database-private smartmarkerts columns data-elements ascot royal howto laggers leaders reference private private_handicap pace getmarketprice overseas subcription begginer bf_race_id pandl server r-betfair-library-not-valid-mac-package getcompletemarketpricescompressed curlperform virtual aeb hardware flying cruising automatic-exchange-betting bet sample documentation missing new starting_price overround
Powered by Question2Answer
...