search for: counter_cache

I am a bit confused about counter_cache here. The API docs http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html say that only the belongs_to association can take the :counter_cache option. When I try to use it on a has_many I get an "unknown key(s): counter_cache" error. Why would this be the ca...

...ache and that it will automatically increment the "children_count" column. I did that but when I create a new page it asks for a "pages_count" column instead. Here is the relevant part of page.rb model: class Page < ActiveRecord::Base acts_as_tree :order => :position, :counter_cache => true acts_as_list :scope => :parent_id end And here is what happens when I create a new page: Mysql::Error: #42S22Unknown column ''pages_count'' in ''field list'': UPDATE pages SET pages_count = pages_count + 1 WHERE (id = 2) Any ideas why it''s...

Hi List, I''m new to and hot on RoR. And I have a question regarding acts_as_tree and counter_cache. What methods actually update the counter_cache column? I''ve only really started the app so i''ve just got it set up so that I can select the parent node (from a list of nodes that exclude all descendants of the current node) with a radio buttoned list named and valued to slip ri...

I have a model that I''ve been indexing and searching with ferret with no problems. I just added a counter_cache for some voting functionality to the same model and now when I perform the voting fxn on an object from that model, I get the FileNotFound error as it looks for a file named "_1c_1.del" ...which breaks my voting function. I tried killing the server and my index directory as suggested for...

Hi list, I''ve got some counter_caches in a model. When these get incremented - say on a page view - my updated_on column also gets updated. How can I conditionally not update updated_on if just these counter_cache columns change? The problem with that is that I am using acts_as_versioned which clones the record each time updated_on c...

Hi, I have the following code: Message, belongs_to :topic, :counter_cache => true topic = Topic.find_from_permalink(params[:id]) topic.messages.create(params[:message]) When the message gets created, then AR issues a supplemental SELECT to retrieve the message''s topic and then updates its messages_count. Why is that happening? If I do it manually: if top...

I''m trying to use counter_cache, but I''m not doing something right. It is unreliable and I keep having to correct it manually. Is there a good tutorial or reference on how to use it on-line? I have the AWDR book, but I need something more complete. TIA, Jeffrey

Before I file a ticket, I''ll query ya''ll about this: The API docs for acts_as_tree''s counter_cache is to create a database column called "children_count" to hold the counter_cache. I have enabled this option in my model. While writing tests I wrote a test for creating children from the a parent: message = @forum_message["parent"].find child = message.children.create(...

Hey everybody, Rails currently offers ''belongs_to :counter_cache'', which is a very basic replacement for count triggers: ":counter_cache - caches the number of belonging objects on the associate class through use of increment_counter and decrement_counter. The counter cache is incremented when an object of this class is created and decremented...

...Item < ActiveRecord Deal < Item Product < Item Category < ActiveRecord Item has_and_belongs_to_many :categories... On each category record I''d like to maintain a product_count and deal_count to increase performance. This doesn''t appear possible with the current "counter_cache" declaration. Anyone have ideas on how to approach this? In the past I''ve just run an hourly cron task to calculate & update all records of this type, but I feel this probably isn''t the most efficient (or accurate). Ideas, comments? -- seth at subimage interactive ht...

Hi All, I''m using a counter_cache, which I believe I''m doing correctly because I can see this SQL query being executed in the development.log file: UPDATE gifts SET bookmarks_count = bookmarks_count + 1 WHERE (id = 276) However, in the gifts table, the bookmarks_count field isn''t incremented (it''s zer...

I''m trying to figure out how to use counter_cache. I''ve got Clients that have many Profiles. And I got things working so that when I add a new Profile, the profiles_count gets updated. profile = client.profiles.new(params[:profile]) profile.save However, I''m stuck trying to figure out how to deal with UPDATING a profile (movi...

..._to table ''states''. In both states, and counties, there''s a column named ''schools_total''. I don''t use Rails built in counter cache because schools don''t belong directly to states. So I want to implement two features. Inside counties: counter_cache :schools avg_cache :schools Inside states: counter_cache :schools, :through => counties avg_cache :schools, :through => counties The first case is straightforward, but on the second case, the "caches" would need to get updated whenever the counties table is modified (apart from w...

Hi I'm using those 2 models: class Topic < ActiveRecord::Base has_many :articles, :order => :rank end class Article < ActiveRecord::Base belongs_to :topic, :counter_cache => true end The "counter_cache" column in the "topics" table does increase when adding a new article, but it does not update when updating article's topic or when deleting the article. Any idea ? _______________________________________________ Rails mailing list Rails...

As far as I can tell, the counter_cache option on a belongs_to model doesn''t actually save anything in the database. For example, I have the following models: class Parent < ActiveRecord::Base has_many :children, :conditions => "deleted_at IS NULL" end class Child < ActiveRecord::Base belongs_...

Hi everyone, Does anybody know who is responsible for updating *_count columns (via :counter_cache) when creating the db and loading fixtures? In my case, the *_count elements remain zero! Thanks, Omid --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send...

...add errors from my object.rb and they never get displayed. class Keyword < ActiveRecord::Base validates_presence_of(:name, :message => "Name is required.") validates_uniqueness_of(:name, :message => "This name is already in use. Please try another.") # counter_cache should be set to true, but it is broken! acts_as_tree :order => "name", :counter_cache => false def set_parent(parent_name) if (parent_name == '''') ###### WHY IS THIS NOT WORKING ????? errors.add_to_base("Name of parent cannot be empty&qu...

Hi, I''m trying to use counter caching in a tree structure (in this case Bob Silva''s threaded list). This is the definition: class Folder < ActiveRecord::Base acts_as_threaded has_many :files end I would like each parent to have the total count of all the childrens member. So when inserting a new file I update the file_count following the parent_id through all the

I have two model classes: class Item < ActiveRecord::Base belongs_to :channel, :counter_cache => true validates_presence_of :channel end class Channel < ActiveRecord::Base has_many :items, :dependent => true end In the Channel controller I have variable channel.items, an Array of Items. I would like to use the Array find method. However, channel.items.find() is a Rails da...

Hi, I''ve been googling and searching the forums for some time but can''t seem to find exactly what I''m looking for. Suppose User HABTM Products (for example a favorites list). I would like to construct a single query for finding Products ordered by the number of Users that have flagged them as favorites. Although I can construct the query using SQL a with a