Getting an error when trying to run update -

Question

could not execute SQL statement:
Error 1062 (23000): Duplicate entry '1311522-3935086' for key 'daily_betfair_mappings.PRIMARY'
Could not fetch latest timestamp for feed daily_runners_insights:
Error 1100 (HY000): Table 'daily_runners_insights' was not locked with LOCK TABLES
Could not fetch latest timestamp for feed historic:
Error 1100 (HY000): Table 'historic_races' was not locked with LOCK TABLES
Could not fetch latest timestamp for feed historic_beta:
Error 1100 (HY000): Table 'historic_races_beta' was not locked with LOCK TABLES
Could not fetch latest timestamp for feed historic_betfair_win_prices:
Error 1100 (HY000): Table 'historic_betfair_win_prices' was not locked with LOCK TABLES
Could not fetch latest timestamp for feed historic_runners_insights:
Error 1100 (HY000): Table 'historic_runners_insights' was not locked with LOCK TABLES
Could not fetch latest timestamp for feed non_runners:
Error 1100 (HY000): Table 'non_runners' was not locked with LOCK TABLES

Answer 1

Hi - this is because the daily_betfair_mappings table was updated yesterday per this question:

https://answers.betwise.net/1527/daily_betfair_mappings

However, your local database still has the old data. with an existing entry for yesterday's races in it, so cannot be updated, hence this error:

1062 (23000): Duplicate entry '1311522-3935086' for key 'daily_betfair_mappings.PRIMARY'

And also because it looks like you are running the smartform-updater for all-feeds.   Therefore it stops as soon as it encounters the error.

To fix the problem, see yeterday's question - in this case you will need to delete all data since yesterday, so follow these steps:

# log in to smartform database

> delete from daily_betfair_mappings where date >= "2024-03-31";

# log out of database and rerun smartform updates

smartform-updater daily_betfair_mappings

Answer 2

Y co dieu toi ma yeu co dieu vong *, dao ly don gian nhu vay le nao Kieu Du khong hieu?(*)Y la yeu nhung khong the hien dung cach, tinh yeu bi hieu sai, se chet dan.La anh noi, bon ho khong the di tiep cung nhau, vi the co khong do du ma xoay nguoi buoc di, nhung anh van o lai do cho doi.

https://butraco.vn