mysql - .include 的 Rails mysql2 gem 错误？

Question

这可以在本地运行，但不能在生产服务器上运行。

使用 ubuntu 10.04、rails 3.0.7、ruby 1.9.2 和 mysql2 gem

我做错了什么？

哈姆 View :

- unless current_user.surveys.include?(survey)

返回

ActionView::Template::Error (Mysql2::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 'NULL))) LIMIT 1' at line 1: SELECT  1 FROM `surveys` INNER JOIN `response_sets` ON `surveys`.id = `response_sets`.survey_id WHERE `surveys`.`id` = 1 AND ((`response_sets`.user_id = 1) AND ((completed_at NOT NULL))) LIMIT 1):

编辑

使用称为测量员的 gem 。在不编辑实际 gem 的情况下，我必须在用户模型中创建像这样的关联:

has_many :response_sets
has_many :surveys, :through => :response_sets, :conditions => ["completed_at NOT NULL"]
has_many :responses, :through => :response_sets

数据库表:

Answer 1

我很确定语法是“IS NOT NULL”，而不仅仅是“NOT NULL”。我在 MySQL 实例上运行了测试，当我遗漏 IS 时出现错误