Skip to content

fix bug with incorrect hot/trends computation on livesync

to fix on production execution of sql function is required: update_hot_and_trending_for_blocks( {some block before head}, head_block_number ) or update_hot_and_trending_for_blocks( 0, head_block_number ) to apdate all not already paid posts.

Of course, firs scripts need to be executed:

      "update_feed_cache.sql",
      "payout_stats_view.sql",
      "update_hive_posts_mentions.sql",
      "find_tag_id.sql",
      "bridge_get_ranked_post_type.sql",
      "bridge_get_ranked_post_for_communities.sql",
      "bridge_get_ranked_post_for_observer_communities.sql",
      "bridge_get_ranked_post_for_tag.sql",
      "bridge_get_ranked_post_for_all.sql",
      "calculate_account_reputations.sql",
      "update_communities_rank.sql",
      "delete_hive_posts_mentions.sql",
      "head_block_time.sql",
      "notifications_view.sql",
      "notifications_api.sql",
      "bridge_get_account_posts_by_comments.sql",
      "bridge_get_account_posts_by_payout.sql",
      "bridge_get_account_posts_by_posts.sql",
      "bridge_get_account_posts_by_replies.sql",
      "bridge_get_relationship_between_accounts.sql",
      "bridge_get_post.sql",
      "condenser_get_discussions_by_created.sql",
      "hot_and_trends.sql"
Edited by Marcin

Merge request reports