ちなみにエラーコピペ ActiveRecord::StatementInvalid in Map#index
Showing app/views/map/_top_custom.html.erb where line #61 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 created_at > '2011-08-07 01:58:25') ORDER BY created_at DESC L' at line 1: SELECT * FROM `illusts` WHERE (open_type = '全公開' and ng_flag = 0 and character != '男*男' and created_at > '2011-08-07 01:58:25') ORDER BY created_at DESC LIMIT 20
Extracted source (around line #61):
58: if view_format == "n" || view_format == "N" 59: view_format == "n" ? num = 10 : num = 20 60: title = "イラスト新着" 61: data = Illust.find(:all , :limit => num.to_i, :order => "created_at DESC" , :conditions => [query+" and created_at > ?", Time.now - 24.hour]) 62: end （ｒｙ
Tweet