MySQL and rails syntax error

Question

I configured rails to work fine with Rails 3. I am trying to create a migration, and here it is its code:

class CreateObservations < ActiveRecord::Migration
  def change
    create_table :observations do |t|
      t.integer :user_id
      t.integer :start
      t.integer :end
      t.string :videoID
      t.string :event
      t.string :content

      t.timestamps
    end
    add_index :observations, [:user_id, :created_at]

  end
end

now when I run 'rake db:migrate' I get this strange error: why?

demo_app/test/factories/observations.rb:7:syntax error, unexpected tINTEGER, expecting keyword_end
demo_app/test/factories/observations.rb:12: syntax error, unexpected keyword_end, expecting $end

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

I am NOT doing any testing now. Just development. so I run this:

 rake db:migrate RAILS_ENV=development

and I get the same error.

here is the code in the factory girl which I dont want to include!!!

FactoryGirl.define do
  factory :observation do
    user_id 1
    start 1
    end 1
    videoID "MyString"
    event "MyString"
    content "MyString"
  end
end

What's in demo_app/test/factories/observations.rb?

ramblex
– ramblex

2012-03-25 15:29:25 +00:00
Commented Mar 25, 2012 at 15:29 — ramblex
– ramblex, Commented Mar 25, 2012 at 15:29

Said Kaldybaev · Accepted Answer · 2012-03-25 15:31:58Z

1

It's probably because of using end field try to change it to something different

answered Mar 25, 2012 at 15:31

Said Kaldybaev

10.1k8 gold badges39 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Test Test Over a year ago

omg, I just noticed that. is there a way to change that without re creating the whole model?!? or changing loads of files?

Holger Just Over a year ago

@TestTest You could avoid it by carefully programming around it but it will generally be a pain in the ass. Better suck it up and change your model.

Said Kaldybaev Over a year ago

rake db:drop && rake db:create && rake db:migrate should work

Test Test Over a year ago

yeah but I still need to delete my model right? (the views etc etc)

Said Kaldybaev Over a year ago

no, no need to delete your model, first rake db:drop, then delete end from migration then rake db:create && rake db:migrate

|

Collectives™ on Stack Overflow

MySQL and rails syntax error

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related