hello to all, i am getting weird syntax error while running the rake db:migrate syntax error, unexpected tSYMBEG, expecting kDO or '{' or '('
Apparently i am creating an engine in my main application using 'ruby script/generate plugin' command in rails 2.3.0 with engine having its own separate database define in database.yml of main application something like this #database of my main application development: adapter: mysql encoding: utf8 database: user_development pool: 5 username: root password: root123 host: localhost
#database of the engine PMS: adapter: mysql database: pms username: root password: root123 host: localhost
i have also define the necessary code inside my all engine models and migration files like this code of project.rb
class Project < ActiveRevcord::Base self.establish_connection :pms end
/db/migrate/20090715172542_create_projects.rb
class CreateProjects < ActiveRecord::Migration def self.connection Project.connection end
def self.up create_table :projects do |t| t.string :name t.text :description t.integer :manager_id
t.timestamps end end
def self.down drop_table :projects end end
and one finale thing is that i have also setup many-to-many association between Model of my main application and Model of my engine i.e between User model of main application and Project Model of engine
The point of telling all this is i am starting to think whether i done something wrong somewhere cuz the databases is created but i always get the error define above while running migrations