similar to: what happened to my increment_counter method?

Hi, Here''s my controller function: >>> def feed @chriss_monster = ChrissMonster.find(params[:id]) @chriss_monster.feed redirect_to :action => ''list'' end <<< Here''s my model: >>> class ChrissMonster < ActiveRecord::Base def feed ChrissMonster.increment_counter :eat, :id end end <<< When I call the

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

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 when it?s destroyed. This

Hi. I have a problem with counters in Rails. The situation looks like this: -3 simple models class Forum < ActiveRecord::Base has_many :posts end class Topic < ActiveRecord::Base has_many :posts end class Post < ActiveRecord::Base belongs_to :topic, :counter_cache => true belongs_to :forum, :counter_cache => true end - In migrations i have declared t.column :posts_count,

i have this model: class LineItem < ActiveRecord::Base belongs_to :quote end in the console: >>l = LineItem.create ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' , , , )'' at line 1: INSERT INTO line_items (`qty`, `quote_id`,

i better explain a little to get started. in my form for creating a Person, there''s a Company field. People belong to companies and companies have many people. in my person form i have: <%= text_field ''person'', ''Company'' %> in my controller i have def create params[''person''][''Company''] =

i have these two really similar methods in my addressbook controller. def edit_company @company = Company.find(params[:id]) if request.post? and @company.update_attributes(params[:company]) flash[:notice] = ''Company was successfully edited.'' redirect_to :action => ''show'', :id => @company end end def edit_person

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

Hi everyone, I have a Department model that has_many people. How do I go about finding all departments with more than 0 people? Department.find(:all, :conditions => Department.people.size > 0) That, of course, doesn''t work, but it was as close as I could come. Thanks! Sean

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 case? belongs_to means that this model has a field with an id

Hi Folks, BackgrounDRb is a Ruby job server and scheduler. Its main intent is to be used with Ruby on Rails applications for offloading long-running tasks. Since a Rails application blocks while serving a request it is best to move long-running tasks off into a background process that is divorced from http request/response cycle. This new release of BackgrounDRb is also modular and can be used

I am building an invoicing system but cannot use the auto_increment field to determine the invoice number (because they are running 3 different companies off the one system. I need to find the last invoice number from any given company and then add 1 to it to get the next invoice number. BUT, there is a unique case on the very first invoice produced because there is no earlier invoice

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 changes. I am successfully ignoring the counter_cache

The method is here: https://github.com/rails/rails/blob/master/activerecord/lib/active_record/persistence.rb#L288. The method takes the in-memory attribute value and increments it by the specified amount. A safer approach (from an isolation standpoint) would be to let the database determine the value. Instead of telling the database what value to persist in the database, the SQL can written

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

What are the limitations on using: errors.add_to_base to display errors in views? I have tried for days to 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

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 (moving it to a different Client). If I change

Hi, I was thinking of doing this with a stored procedure, but I thought it could be better implemented in Rails. I have several tables that hold a counter cache for other tables, which aren''t directly related. For example: Table ''schools'' has records that belong_to table ''counties'', and that table has records that belong_to table

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

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_to :parent, :counter_cache => true end With the following