Whats the gem version of the mysql adapter?
On Oct 9, 3:13 am, Gisborne <[email protected]> wrote: > I am custom-generating some SQL, which I execute via > > ActiveRecord::Base.connection.execute query > > I get to the point in the MySQL adapter inside execute where it's > doing this: > > log(sql, name) { @connection.query(sql) } > > I take the value of sql at that point and put it into Sequel Pro and > execute it, and it works fine. But when I execute it through the MySQL > adapter, I get the below. > > I've checked that I'm using the same credentials to log into the same > database in Sequel Pro and in Rails. Can anyone suggest why this is > failing in this manner? > > (Rails 2.2, MySQL 5.1.3.7) > > ActiveRecord::StatementInvalid in DevicesController#update > > 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 'DELETE FROM > micro_provenances > WHERE > provenable_i' at line 7: DELETE FROM > micro_provenances > WHERE > provenable_id = 9 AND > provenable_type = 'Device' AND > field_name = 'wifi_n_ie' AND > attachment_source_id NOT IN (54);DELETE FROM > micro_provenances > WHERE > provenable_id = 9 AND > provenable_type = 'Device' AND > field_name = 'wifi_b_ie' AND > attachment_source_id NOT IN (54,53,52);DELETE FROM > micro_provenances > WHERE > provenable_id = 9 AND > provenable_type = 'Device' AND > field_name = 'wifi_g_ie' AND > attachment_source_id NOT IN (53);INSERT INTO > micro_provenances( > provenable_id, > provenable_type, > field_name, > attachment_source_id, > created_at, > updated_at) > VALUES(9, "Device", "wifi_n_ie", 54, "2009-10-08 20:57:11", > "2009-10-08 20:57:11"), (9, "Device", "wifi_b_ie", 54, "2009-10-08 > 20:57:11", "2009-10-08 20:57:11"), (9, "Device", "wifi_b_ie", 53, > "2009-10-08 20:57:11", "2009-10-08 20:57:11"), (9, "Device", > "wifi_b_ie", 52, "2009-10-08 20:57:11", "2009-10-08 20:57:11"), (9, > "Device", "wifi_g_ie", 53, "2009-10-08 20:57:11", "2009-10-08 > 20:57:11") > ON DUPLICATE KEY UPDATE > attachment_source_id = VALUES(attachment_source_id), > updated_at = VALUES(updated_at) --~--~---------~--~----~------------~-------~--~----~ SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby -~----------~----~----~----~------~----~------~--~---
