Hi all,
Sorry for another newbie question!
I've got a legacy firebird database which I wish to use, and thanks to
help from this group I've used Dr Nic's Magic Models to get RoR
talking to the database.
However, I wish to create a new table ("reports") in this database,
and so generated the scaffold such that the file "db/migrate/
001_create_reports.rb" is as follows:
class CreateReports < ActiveRecord::Migration
def self.up
create_table :reports do |t|
t.string :name
t.string :description
t.string :location
t.timestamps
end
end
def self.down
drop_table :reports
end
end
When I attempt to migrate this (rake db:migrate), I get the following
error:
FireRuby::FireRubyException: Error preparing a SQL statement.
Dynamic SQL Error
SQL error code = -204
Table unknown
SCHEMA_INFO
At line 1, column 21.
Undefined name
SQL Code = -204
Firebird Code = 335544569
: SELECT version FROM schema_info
I've tried running it with --trace, and going through the trace, but I
can't make any sense out of why this is happening. I've also obviously
tried googling, thinking someone must have encountered this before,
but with no luck.
Thanks in advance for any help.