Showing app/views/map/_top_custom.html.erb where line #28 raised:
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 ') ORDER BY created_at DESC LIMIT 20' at line 1: SELECT * FROM `illusts` WHERE (created_at > '2011-08-13 06:17:52' and ) ORDER BY created_at DESC LIMIT 20
Extracted source (around line #28):
25: if view_format == "n" || view_format == "N" 26: view_format == "n" ? num = 10 : num = 20 27: title = "イラスト新着" 28: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => ["created_at > ? and " + query[0] , Time.now - 24.hour ]) 29: end 30: 31: # ホット
Trace of template inclusion: app/views/map/index.html.erb
RAILS_ROOT: /data/www/suimy Application Trace | Framework Trace | Full Trace
↓エラー ActiveRecord::StatementInvalid in Map#index Showing app/views/map/_top_custom.html.erb where line #34 raised: 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 'and tag NOT LIKE '%恐怖%' and tag NOT LIKE '%腐向け%') ORDER BY created_at' at line 1: SELECT * FROM `illusts` WHERE (created_at > '2011-08-13 08:28:28' and and tag NOT LIKE '%恐怖%' and tag NOT LIKE '%腐向け%') ORDER BY created_at DESC LIMIT 20 Extracted source (around line #34): 31: if query[0].blank? 32: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => ["created_at != ?",Time.now]) 33: else 34: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => ["created_at > ? and " + query[0] , Time.now - 24.hour ]) 35: end 36: end 37: Trace of template inclusion: app/views/map/index.html.erb RAILS_ROOT: /data/www/suimy Application Trace | Framework Trace | Full Trace /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/mysql_adapter.rb:324:in `execute' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/mysql_adapter.rb:639:in `select' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.11/lib/active_r
Showing app/views/map/_top_custom.html.erb where line #34 raised:
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 'and tag NOT LIKE '%改変%' and tag NOT LIKE '%恐怖%' and tag NOT LIKE '%腐�' at line 1: SELECT * FROM `illusts` WHERE (created_at > '2011-08-13 11:23:29' and and tag NOT LIKE '%改変%' and tag NOT LIKE '%恐怖%' and tag NOT LIKE '%腐向け%' and tag NOT LIKE '%ホモ%' and tag NOT LIKE '%百合%' and tag NOT LIKE '%ふたなり%' and tag NOT LIKE '%スカトロ%' and tag NOT LIKE '%暴力%' and tag NOT LIKE '%注意%') ORDER BY created_at DESC LIMIT 20
Extracted source (around line #34):
31: if query[0].blank? 32: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => ["created_at != ?",Time.now]) 33: else 34: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => ["created_at > ? and " + query[0] , Time.now - 24.hour ]) 35: end 36: end 37:
Trace of template inclusion: app/views/map/index.html.erb
RAILS_ROOT: /data/www/suimy Application Trace | Framework Trace | Full Trace