{"comment":{"created_at":"2011-10-21T04:25:11Z","body":"Quote the field name.\r\n\r\n\"off\" means false in YAML: http://yaml.org/type/bool.html","updated_at":"2011-10-21T04:25:11Z","url":"https://api.github.com/repos/rails/rails/issues/comments/2477618","id":2477618,"user":{"gravatar_id":"24d2f8804e6bb4b7ea6bd11e0a586470","avatar_url":"https://secure.gravatar.com/avatar/24d2f8804e6bb4b7ea6bd11e0a586470?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/jeremy","id":199,"login":"jeremy"}},"action":"created","issue":{"number":3384,"created_at":"2011-10-21T00:20:41Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"I have a fixture file with the following contents:\r\n\r\n    one:\r\n      tsdate: 2011-10-19\r\n      off: false\r\n      vacation: 9.99\r\n      holiday: 9.99\r\n      comment: MyText\r\n      admin_comment: MyText\r\n      approved: false\r\n      employee_id: 1\r\n      breakfast: false\r\n      lunch: false\r\n      dinner: false\r\n      paid: false\r\n      amount: 9.99\r\n\r\n    two:\r\n      tsdate: 2011-10-19\r\n      off: false\r\n      vacation: 9.99\r\n      holiday: 9.99\r\n      comment: MyText\r\n      admin_comment: MyText\r\n      approved: false\r\n      employee_id: 1\r\n      breakfast: false\r\n      lunch: false\r\n      dinner: false\r\n      paid: false\r\n      amount: 9.99\r\n\r\nRails is interpreting the off: in the second column as false, so it tries to insert the value false into the field false, which does not exist.\r\n\r\n    ActiveRecord::StatementInvalid: SQLite3::SQLException: table timesheets has no column named false: INSERT INTO \"timesheets\" (\"comment\", \"vacation\", \"false\",...","comments":1,"title":"Rails 3.1.0, Can't use off: in a fixture file","updated_at":"2011-10-21T04:25:11Z","url":"https://api.github.com/repos/rails/rails/issues/3384","id":2011132,"assignee":null,"milestone":null,"closed_at":"2011-10-21T04:25:11Z","user":{"gravatar_id":"a78ad8661da9bd80a6012fd196b0a493","avatar_url":"https://secure.gravatar.com/avatar/a78ad8661da9bd80a6012fd196b0a493?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/powertoaster","id":160286,"login":"powertoaster"},"html_url":"https://github.com/rails/rails/issues/3384","labels":[],"state":"closed"},"legacy":{"issue_id":2011132,"comment_id":2477618}}