I think I found the bug.
I noticed that in 033_add_remember_me_to_user.rb that the column names
are strings as mentioned in the comment:
rename_column :users, 'password', 'crypted_password' #bug in sqlite
requires column names as strings
So I converted the column names to string in 019 and 034 as well and
everything seems to be okay now.
Thanks,
Mohammed Firdaus
On Sun, Apr 6, 2008 at 10:57 PM, Mohammed Firdaus
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> There are dates in the completed column (before) but in the
> completed_at column (after) everything is NULL.
>
> I noticed another column rename where "word" is renamed to "token" in
> the users table and that too is NULL after the db migration.
>
> --trace doesn't appear to add anything to that portion of the output.
>
> I think I'll try exporting my old data to MySQL and migrating from
> there and using MySQL from now on.
>
> Thank you so much for your help,
>
> Mohammed Firdaus
>
>
>
> On Sun, Apr 6, 2008 at 10:35 PM, Reinier Balt <[EMAIL PROTECTED]> wrote:
> > > On Sun, Apr 6, 2008 at 9:50 PM, Mohammed Firdaus
> > > <[EMAIL PROTECTED]> wrote:
> > > > I'm using sqlite.
> > > >
> > > > It seems to be renaming the column and adding it again as seen in
> > > the
> > > > output below but as far as I can tell there are no errors during
> > > > migration.
> > > >
> > > > == ConvertTodoToStateMachine: migrating
> > > =======================================
> > > > -- add_column(:todos, :state, :string, {:null=>false,
> > > > :default=>"immediate", :limit=>20})
> > > > -> 0.0477s
> > > > -- rename_column(:todos, :completed, :completed_at)
> > > > -> 1.8018s
> > > > -- remove_column(:todos, :done)
> > > > -> 1.9843s
> > > > -- remove_column(:todos, :type)
> > > > -> 1.5375s
> > > > == ConvertTodoToStateMachine: migrated (20.8127s)
> > > =============================
> > > >
> >
> > This is strange. The column is renamed without errors. Could you check in
> > the
> > database before and after what happens to the completed column (before)
> and
> > the completed_at column (after). There should be dates in the completed
> > column (before) which should be copied to the completed_at column (after).
> >
> > You can also try to run rake with --trace. Perhaps there is more
> information
> > in
> > The console then
> >
> >
> >
> > > > -- add_column(:projects, :completed_at, :datetime)
> > Indeed the project table :-)
> >
> > Reinier
> >
> >
>
_______________________________________________
Tracks-discuss mailing list
[email protected]
http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
