# ActiveRecord::StatementInvalid conditionsdeleted?

**URL:** <https://www.ruby-forum.com/t/activerecord-statementinvalid-conditionsdeleted/110443>\
**Category:** Ruby-Forum\
**Created:** [July 26, 2007, 11:56am UTC](https://www.ruby-forum.com/t/activerecord-statementinvalid-conditionsdeleted/110443 "2007-07-26T11:56:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![moo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@moo](https://www.ruby-forum.com/u/moo)\
**Post date:** [July 26, 2007, 11:56am UTC](https://www.ruby-forum.com/t/activerecord-statementinvalid-conditionsdeleted/110443/1 "2007-07-26T11:56:05Z")

</div>

i’m trying latest dracs version as of now. and i get the following  
error:  
ActiveRecord::StatementInvalid (Mysql::Error: Unknown column  
‘conditionsdeleted’ in ‘where clause’: SELECT count(\*) AS count\_all FROM  
posts WHERE (posts.topic\_id = 11143 AND (conditionsdeleted = 0)) ):  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in  
`log' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:184:in`execute’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/mysql\_adapter.rb:336:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:179:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:16:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/calculations.rb:164:in`execute\_simple\_calculation’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/calculations.rb:144:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/calculations.rb:66:in`count’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/associations/has\_many\_association.rb:47:in  
`count' /app/models/topic.rb:115:in`update\_post\_counter’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/associations/association\_proxy.rb:110:in  
`method_missing' /app/models/post.rb:201:in`after\_save’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/callbacks.rb:359:in  
`callback' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/callbacks.rb:254:in`create\_or\_update’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/base.rb:1392:in  
`save_without_validation' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/validations.rb:736:in`save\_without\_transactions’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/transactions.rb:126:in  
`save' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract/database_statements.rb:51:in`transaction’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/transactions.rb:91:in  
`transaction' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:118:in`transaction’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/transactions.rb:126:in  
`save' /app/models/forum.rb:41:in`add\_post’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:51:in  
`transaction' /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/transactions.rb:91:in`transaction’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/transactions.rb:118:in  
`transaction' /app/models/forum.rb:36:in`add\_post’  
/app/controllers/topic\_controller.rb:98:in `new' /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:941:in`perform\_action\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/filters.rb:368:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/benchmarking.rb:69:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/rescue.rb:82:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/base.rb:408:in`process\_without\_filters’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action\_controller/filters.rb:377:in  
`process_without_session_management_support' /usr/lib/ruby/gems/1.8/gems/actionpack-1.12.5/lib/action_controller/session_management.rb:117:in`process’  
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/dispatcher.rb:38:in  
`dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:150:in`process\_request’  
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi\_handler.rb:54:in  
`process!' /usr/lib/ruby/gems/1.8/gems/fcgi-0.8.6.1/./fcgi.rb:600:in`each\_cgi’  
/usr/lib/ruby/gems/1.8/gems/fcgi-0.8.6.1/./fcgi.rb:597:in `each_cgi' /usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi_handler.rb:53:in`process!’  
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/fcgi\_handler.rb:23:in  
`process!’  
/public/dispatch.fcgi:24

any idea? is there any pre-requirement? like gem/activerecord or rails  
version?

---

<div class="post-metadata">

**Author:** ![moo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/c4cdca/32.png) [@moo](https://www.ruby-forum.com/u/moo)\
**Post date:** [July 26, 2007, 12:00pm UTC](https://www.ruby-forum.com/t/activerecord-statementinvalid-conditionsdeleted/110443/2 "2007-07-26T12:00:15Z")

</div>

removing “:conditions =\>” in the topics.rb works, but there’s many other  
count :conditions

and btw, i get it to run by adding some field that is not in db/migrate  
yet. and i’ve also download 2 scripts from [ruby-forum.com](http://ruby-forum.com) which is not  
darcs, pls check in