I just tested trunk and it works great. You guys rock.
Thanks, Mohammed Firdaus On Mon, Apr 7, 2008 at 3:31 PM, Reinier Balt <[EMAIL PROTECTED]> wrote: > 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
