Mysql2::Error: You have an error in your SQL syntax

Question

I just used this to switch my rails app db from sqlite3 to mysql2 and that seemed to work out properly.

But when I start up my app I'm now getting this:

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'

Not sure where to look to get this working properly. Any help would be appreciated. Thanks!

I have this error when I navigate to rails admin and try to edit one of my users.do you have any ideas ? — Afsanefda, Sep 05 '17 at 10:33

score 4 · Accepted Answer · edited Feb 23 '12 at 02:41

4

Try this:

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

Update Ended up doing

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

This worked great. Thanks!

edited Feb 23 '12 at 02:41

Marc

2,584
5
33
47

answered Feb 23 '12 at 01:52

Mike Purcell

19,847
10
52
89

so like this: ```scope :not_archived, where('archived == ?', 1)```?? – Marc Feb 23 '12 at 01:53
scope :not_archived, where('archived = ?', 1) – Ben Simpson Feb 23 '12 at 01:54
alternately, scope :not_archived, where(:archived => 1) – Ben Simpson Feb 23 '12 at 01:54
what about when i want to do: ```scope :is_archived, where('archived != ?', 1)```? – Marc Feb 23 '12 at 01:55
Damn, sorry, I was only looking at the mysql syntax. I cannot confirm for the ruby construct, but I do know that `==` in mysql context is incorrect. – Mike Purcell Feb 23 '12 at 01:56

Mysql2::Error: You have an error in your SQL syntax

1 Answers1

Linked