Watch, Follow, &
Connect with Us
Public Report
Report From: 3rdRail    [ Add a report in this area ]  
Report #:  60637   Status: Resolved
interbase can't migrate
Project:  3rdRail Build #:  v20080311_0801
Version:    unspecifie Submitted By:   Luke Fan
Report Type:  Basic functionality failure Date Reported:  4/8/2008 9:26:47 PM
Severity:    Serious / Highly visible problem Last Updated: 5/6/2010 7:42:43 AM
Platform:    All versions Internal Tracking #:  
Resolution: Need More Info (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 1
Description
can't migrate interbase database
Steps to Reproduce:
1, create a rails 2.02 project with interbase support.
2, edit the database.yml.
3, create a new resource.
4, rake db:migrate

Error message:
rake db:migrate
(in C:/Users/Luke/3rdRail/workspace2/ibtest1)
== 1 CreateUsers: migrating ===================================================
-- create_table(:users)
rake aborted!
You have a nil object when you didn't expect it!
The error occurred while evaluating nil.id2name

(See full trace by running task with --trace)
Workarounds
Vista 32bit
3rdRail 1.1
Interbase 2007 Developer Edition
ruby 1.8.6
rails 2.0.2
Attachment
None
Comments

Robert Ehteshamzadeh at 4/11/2008 11:43:30 AM -
You need to verify the database you are trying to connect to.

To do this, go to the bin directory of the interbase install. specify username, password and fullpath to database:

If isql is not on your path,  go to the directory it is installed in and run it with the username and password for the database and the fullpath to the database.  for example:

To find the fullpath to your newly created database, right click on the project in the rails explorer, select properties, and copy the location. In my case:

C:\Documents and Settings\VMGuy\3rdRail\workspace\Rails2Interbase
look for the database path in database.yml.  In this case:  db/development.ib

concatenate to get the full path to pass to isql ( in quotes if there are spaces ).

C:\Borland\InterBase2\bin>isql -user sysdba -pass masterkey "C:\Documents and Settings\VMGuy\3rdRail\workspace\Rails2Interbase\db\
DEVELOPMENT.IB"

If this is successful, isql will echo the current database and username:

Database:  C:\Documents and Settings\VMGuy\3rdRail\workspace\Rails2Interbase\db\DEVELOPMENT.IB, User: sysdba

To list the tables, use:
sql>  show tables;

to list the fields of a table, use:
sql>  show table (tablename);

Run this test and post your results.

Server Response from: ETNACODE01