# Rails reverses apostrophes

**URL:** <https://www.ruby-forum.com/t/rails-reverses-apostrophes/116679>\
**Category:** Rails\
**Created:** [October 8, 2007, 6:25pm UTC](https://www.ruby-forum.com/t/rails-reverses-apostrophes/116679 "2007-10-08T18:25:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kusako](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/b4bc9f/32.png) [@kusako](https://www.ruby-forum.com/u/kusako)\
**Post date:** [October 8, 2007, 6:25pm UTC](https://www.ruby-forum.com/t/rails-reverses-apostrophes/116679/1 "2007-10-08T18:25:39Z")

</div>

Hi,

I am quite new to Ruby on Rails so this might have a very simple  
answer… My problem gives the following error message when I try to  
call the count function for an item.

Mysql::Error: Unknown column ‘TournamentTemplate’ in ‘where clause’:  
SELECT count(\*) AS count\_all FROM action\_logs WHERE  
(action\_logs.loggable\_id = 1 AND action\_logs.loggable\_type =  
`TournamentTemplate`)

The row that generates the error looks like this:  
\<% if item and item.action\_logs.count \> 0 %\>

Action\_logs is a polymorphic class, so “item” can be one of many  
loggable classes. The model file looks like this:

class ActionLog \< ActiveRecord::Base  
belongs\_to :loggable, :polymorphic =\> true  
belongs\_to :user  
end

By the way, the application was working fine until I moved it to a  
different server. That server is fresh install of red hat enterprise 4.  
I’m most grateful for any help to fix this.

Thanks /Markus

---

<div class="post-metadata">

**Author:** ![kusako](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/k/b4bc9f/32.png) [@kusako](https://www.ruby-forum.com/u/kusako)\
**Post date:** [October 8, 2007, 7:01pm UTC](https://www.ruby-forum.com/t/rails-reverses-apostrophes/116679/2 "2007-10-08T19:01:17Z")

</div>

Addendum: I was a bit tired when I wrote the subject. What I meant is  
that in the sql query, the apostrophes are replaced with 'grave accents  
(`). I’ve tried googlign, but I really can’t find anything. Below is a  
trace on the error log:

/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in`execute’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/mysql\_adapter.rb:399:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:19:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:212:in`execute\_simple\_calculation’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:121:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:117:in`catch’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:117:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:45:in`count’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/associations/has\_many\_association.rb:55:in  
`count' #{RAILS_ROOT}/app/views/shared/_display_log.rhtml:1:in`\_run\_rhtml\_47app47views47shared47\_display\_log46rhtml’  
#{RAILS\_ROOT}/app/views/tournament\_template/update.rhtml:15:in  
`\_run\_rhtml\_47app47views47tournament\_template47update46rhtml’

/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in`execute’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/mysql\_adapter.rb:399:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:19:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:212:in`execute\_simple\_calculation’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:121:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:117:in`catch’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:117:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:45:in`count’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/associations/has\_many\_association.rb:55:in  
`count' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:326:in`send’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:326:in  
`compile_and_render_template' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:301:in`render\_template’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:260:in  
`render_file' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:275:in`render’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/partials.rb:59:in  
`render_partial' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:30:in`benchmark’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/partials.rb:58:in  
`render_partial' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:287:in`render’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:326:in  
`send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:326:in`compile\_and\_render\_template’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:301:in  
`render_template' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:260:in`render\_file’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/base.rb:806:in  
`render_file' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:711:in`render\_with\_no\_layout’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/layout.rb:247:in  
`render_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:50:in`render’  
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:50:in`render’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/base.rb:1096:in  
`perform_action_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:632:in`call\_filter’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/filters.rb:638:in  
`call_filter' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:438:in`call’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/filters.rb:637:in  
`call_filter' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:638:in`call\_filter’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/filters.rb:438:in  
`call' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:637:in`call\_filter’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/filters.rb:619:in  
`perform_action_without_benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/benchmarking.rb:66:in`perform\_action\_without\_rescue’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/rescue.rb:83:in  
`perform_action' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:430:in`send’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/base.rb:430:in  
`process_without_filters' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/filters.rb:624:in`process\_without\_session\_management\_support’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/session\_management.rb:114:in  
`process' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_controller/base.rb:330:in`process’  
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/dispatcher.rb:41:in  
`dispatch' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi_handler.rb:168:in`process\_request’  
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi\_handler.rb:143:in  
`process_each_request!' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi_handler.rb:109:in`with\_signal\_handler’  
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi\_handler.rb:142:in  
`process_each_request!' /usr/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:612:in`each\_cgi’  
/usr/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in `each' /usr/lib/ruby/gems/1.8/gems/fcgi-0.8.7/lib/fcgi.rb:609:in`each\_cgi’  
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi\_handler.rb:141:in  
`process_each_request!' /usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi_handler.rb:55:in`process!’  
/usr/lib/ruby/gems/1.8/gems/rails-1.2.3/lib/fcgi\_handler.rb:25:in  
`process!’  
#{RAILS\_ROOT}/public/dispatch.fcgi:24

/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/mysql_adapter.rb:243:in`execute’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/mysql\_adapter.rb:399:in  
`select' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/connection_adapters/abstract/database_statements.rb:13:in`select\_one’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:19:in  
`select_value' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:212:in`execute\_simple\_calculation’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:121:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:117:in`catch’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/calculations.rb:117:in  
`calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/calculations.rb:45:in`count’  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active\_record/associations/has\_many\_association.rb:55:in  
`count' #{RAILS_ROOT}/app/views/shared/_display_log.rhtml:1:in`\_run\_rhtml\_47app47views47shared47\_display\_log46rhtml’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:326:in  
`send' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:326:in`compile\_and\_render\_template’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:301:in  
`render_template' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/base.rb:260:in`render\_file’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:275:in  
`render' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/partials.rb:59:in`render\_partial’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_controller/benchmarking.rb:30:in  
`benchmark' /usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action_view/partials.rb:58:in`render\_partial’  
/usr/lib/ruby/gems/1.8/gems/actionpack-1.13.3/lib/action\_view/base.rb:287:in  
`render' #{RAILS_ROOT}/app/views/tournament_template/update.rhtml:15:in`\_run\_rhtml\_47app47views47tournament\_template47update46rhtml’