Table Unknown - SCHEMA_INFO

rubyonrails-talk
1

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.

2

i can't help you with too much details, but maybe some related info: schema_info is a default table created by Rails. if you use an existing db (or otherwise created, but not by rails) this will be missing. in this table there is a single col named 'version' in which the current migration state is stored (eg 1, after running your 001_create_reports.rb)

maybe it's enough to create this table and set version to 0, but i don't know if it's a good idea, to mix migrations with an existing db that way (should do if you just add tables)

3

Thanks very much for your reply. So just to clarify, I'm probably best off just scrapping what I've done, adding the new table to the existing database, and starting all over again?