Hi Mohammed, I changed both migrations in trunk. Also found two other instances in 003 and 019. Can you help me test these on your sqlite?
Reinier > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:tracks- > [EMAIL PROTECTED] Namens Mohammed Firdaus > Verzonden: maandag 7 april 2008 7:58 > Aan: [email protected] > Onderwerp: Re: [Tracks-discuss] All hail release 1.5 > > 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 _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
