Mysql2::Error: 您的 SQL 语法有错误

Question

我刚刚使用这个来切换我的rails app db 从 sqlite3 到 mysql2 ，这似乎工作正常。

但是当我启动我的应用程序时，我现在得到了这样的信息：

A ActionView::Template::Error occurred in pages#dashboard:

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 '== 1) LIMIT 20 OFFSET 0' at line 1: SELECT `tickets`.* FROM `tickets` WHERE (archived == 1) LIMIT 20 OFFSET 0
activerecord (3.0.3) lib/active_record/connection_adapters/abstract_adapter.rb:202:in `log'

不确定在哪里可以使其正常工作。任何帮助将不胜感激。谢谢！

Answer 1

试试这个：

# Notice single = vs ==
WHERE (archived = 1)

---

更新
最终做到了

scope :is_archived, where('archived != ?', 1)
scope :not_archived, where('archived = ?', 1)

这效果很好。谢谢！