error.rb

2.1.5 :001 > require './app'
 => true 
2.1.5 :002 > @cal = DreamColorMonitor.from('calibrations c').joins('JOIN dream_color_monitors.id = c.dream_color_monitor_id').where("date > date('now') - 90").group('tag')
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR:  syntax error at or near "="
LINE 1: ... FROM calibrations c JOIN dream_color_monitors.id = c.dream_...
                                                             ^
: SELECT "dream_color_monitors".* FROM calibrations c JOIN dream_color_monitors.id = c.dream_color_monitor_id WHERE (date > date('now') - 90) GROUP BY tag
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `async_exec'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `block in exec_no_cache'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:473:in `block in log'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activesupport-4.2.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract_adapter.rb:467:in `log'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:592:in `exec_no_cache'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/postgresql_adapter.rb:584:in `execute_and_clear'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:347:in `select'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/querying.rb:39:in `find_by_sql'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/relation.rb:638:in `exec_queries'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/relation.rb:514:in `load'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/relation.rb:243:in `to_a'
        from /usr/local/rvm/gems/ruby-2.1.5/gems/activerecord-4.2.1/lib/active_record/relati n.rb:629:in `inspect'