caching not working as expected

[thatfunkymunki]

I ran the migration as shown in the readme, but whenever I do object.get_likes.size it still queries the votes table without hitting the cache. Additionally the cache columns are not automatically updating with new votes. Are there any procedures to perform?

Score: <%[email protected]_likes.size - @card.get_dislikes.size%>
Cached Score: <%[email protected]_votes_up.size - @card.cached_votes_down.size%>

[ryanto]

Open db/schema.rb and paste your the "create_tables 'votes'...." section.

[thatfunkymunki]

create_table "votes", force: true do |t|
t.integer "votable_id"
t.string "votable_type"
t.integer "voter_id"
t.string "voter_type"
t.boolean "vote_flag"
t.string "vote_scope"
t.integer "vote_weight"
t.datetime "created_at"
t.datetime "updated_at"
end

[ryanto]

You don't have any of the cache columns on your table. Please see this page: https://github.com/ryanto/acts_as_votable#caching

[thatfunkymunki]

I have the cached columns under my other model as stated in the link given:

create_table "cards", force: true do |t|
t.text "text"
t.datetime "created_at"
t.datetime "updated_at"
t.integer "cached_votes_total", default: 0
t.integer "cached_votes_score", default: 0
t.integer "cached_votes_up", default: 0
t.integer "cached_votes_down", default: 0
t.integer "cached_weighted_score", default: 0
t.integer "cached_weighted_total", default: 0
end

[ryanto]

Whoops, sorry about that.

What version of ruby and what version of rails?

[thatfunkymunki]

action@cerebral-depravity-120411:/cerebral-depravity(master_)$ rails version
Rails 4.1.0
action@cerebral-depravity-120411:/cerebral-depravity(master_)$ ruby --version
ruby 2.1.1p76 (2014-02-24 revision 45161) [x86_64-linux]

[vietqhoang]

What happens when you try the following?

@card.count_votes_up and @card.count_votes_down

Looking at the votable.rb, it looks like @card.get_likes and @card.get_dislikes will always hit the Vote table. Whereas the above will hit the cache columns of the votable model.

This still doesn't explain why your caching is not updating though...

Did you run the following command force caching of existing votes for the votable model? I am assuming the model is Card.
Card.find_each(&:update_cached_votes)

Also you don't need to call .size on @card.cached_votes_up and @card.cached_votes_down, since the return is an integer.

[thatfunkymunki]

Yep, I ran the

Card.find_each(&:update_cached_votes)

in the migration. Then @card.cached_votes_up still gives me 0. I can't see the column updating either.

[thatfunkymunki]

I guess I was doing something wrong because it is working now. Thanks for your support!!!

[clairity]

if anyone else runs into this issue of the cache seemingly not working, a restart of the rails server just might fix it. =)

[vietqhoang]

Hi,
i have a similar problem, maybe someone can help.
Displaying the cached_weighted score in show, there is no problem.
BUT as soon as i try to order/reorder int wont work
i tried running this:
@movie_suggestions.order(:cached_weighted_score => :desc)
@movie_suggestions.order('cached_weighted_score DESC')
@movie_suggestions.reorder(:cached_weighted_score => :desc)
@movie_suggestions.reorder('cached_weighted_score DESC')
@movie_suggestions.reorder(:weighted_score => :desc)
@movie_suggestions.order(:weighted_score => :desc)
all of this doesnt work, although the value of a single suggestion is displayed correctly in view using this:
suggestion.weighted_score
any suggestions on why it wont work?

What error output are you getting? The information will help in figuring out the source of your issue.

I am going off the assumption your results are not being ordered correctly. Do you have a default scope set on your MovieSuggestion model? Have you tried chaining to_sql to any of your calls to see what the SQL output is like? It may reveal what the issue is.

[YouckFou46]

The problem was in the migration, somehow. Try and rewrite it that might help

[jDeppen]

The issue for me was that I was only utilizing vote_weight as star rating, so I left vote_flag: nil. I needed to set vote_flag in order for the cache to update these:

cached_weighted_average # vote_flag must be true for the vote to count
cached_votes_total # vote_flag can't be nil or the vote won't count

note: cached_weighted_total worked fine with vote_flag: nil
(these are the only three cache columns I'm using, so I can't speak to the others)