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