Hello, I want to use username so I can log in with username. So I made this migration file : class AddDeviseToUsers < ActiveRecord::Migration def self.up change_table(:users) do |t| ## Database authenticatable t.string :username, :null => false, :default => "" t.string :encrypted_password, :null => false, :default => "" ## Recoverable t.string :reset_password_token t.datetime :reset_password_sent_at ## Rememberable t.datetime :remember_created_at ## Trackable t.integer :sign_in_count, :default => 0 t.datetime :current_sign_in_at t.datetime :last_sign_in_at t.string :current_sign_in_ip t.string :last_sign_in_ip ## Confirmable # t.string :confirmation_token # t.datetime :confirmed_at # t.datetime :confirmation_sent_at # t.string :unconfirmed_email # Only if using reconfirmable ## Lockable # t.integer :failed_attempts, :default => 0 # Only if lock strategy is :failed_attempts # t.string :unlock_token # Only if unlock strategy is :email or :both # t.datetime :locked_at ## Token authenticatable # t.string :authentication_token # Uncomment below if timestamps were not included in your original model. # t.timestamps end add_index :users, :email add_index :users, :username, :unique => true add_index :users, :reset_password_token, :unique => true add_index :users, :confirmation_token, :unique => true add_index :users, :unlock_token, :unique => true add_index :users, :authentication_token, :unique => true end def self.down # By default, we don''t want to make any assumption about how to roll back a migration when your # model already existed. Please edit below which fields you would like to remove in this migration. raise ActiveRecord::IrreversibleMigration end end But now I get this error message : SQLite3::SQLException: no such table: users: ALTER TABLE "users" ADD "username" varchar(255) DEFAULT '''' NOT NULL Anyone a idea how to solve this ? This is a clean install. Roelof -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/xpJZWxxT_9IJ. For more options, visit https://groups.google.com/groups/opt_out.
you need create_table meathod instead change_table. Matt''s On Tue, Nov 13, 2012 at 3:08 PM, roelof <rwobben-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote:> Hello, > > I want to use username so I can log in with username. > So I made this migration file : > > class AddDeviseToUsers < ActiveRecord::Migration > def self.up > change_table(:users) do |t| > ## Database authenticatable > t.string :username, :null => false, :default => "" > t.string :encrypted_password, :null => false, :default => "" > > ## Recoverable > t.string :reset_password_token > t.datetime :reset_password_sent_at > > ## Rememberable > t.datetime :remember_created_at > > ## Trackable > t.integer :sign_in_count, :default => 0 > t.datetime :current_sign_in_at > t.datetime :last_sign_in_at > t.string :current_sign_in_ip > t.string :last_sign_in_ip > > ## Confirmable > # t.string :confirmation_token > # t.datetime :confirmed_at > # t.datetime :confirmation_sent_at > # t.string :unconfirmed_email # Only if using reconfirmable > > ## Lockable > # t.integer :failed_attempts, :default => 0 # Only if lock strategy > is :failed_attempts > # t.string :unlock_token # Only if unlock strategy is :email or > :both > # t.datetime :locked_at > > ## Token authenticatable > # t.string :authentication_token > > > # Uncomment below if timestamps were not included in your original > model. > # t.timestamps > end > > add_index :users, :email > add_index :users, :username, :unique => true > add_index :users, :reset_password_token, :unique => true > add_index :users, :confirmation_token, :unique => true > add_index :users, :unlock_token, :unique => true > add_index :users, :authentication_token, :unique => true > end > > def self.down > # By default, we don''t want to make any assumption about how to roll > back a migration when your > # model already existed. Please edit below which fields you would like > to remove in this migration. > raise ActiveRecord::IrreversibleMigration > end > end > > > But now I get this error message : SQLite3::SQLException: no such table: > users: ALTER TABLE "users" ADD "username" varchar(255) DEFAULT '''' NOT NULL > > Anyone a idea how to solve this ? > This is a clean install. > > Roelof > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/xpJZWxxT_9IJ. > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
On 13 November 2012 18:18, Carlos Mathiasen <gunmath987-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> you need create_table meathod instead change_table.And since the users table does not already exist you should uncomment the t.timestamps line. Colin> > Matt''s > > > > On Tue, Nov 13, 2012 at 3:08 PM, roelof <rwobben-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote: >> >> Hello, >> >> I want to use username so I can log in with username. >> So I made this migration file : >> >> class AddDeviseToUsers < ActiveRecord::Migration >> def self.up >> change_table(:users) do |t| >> ## Database authenticatable >> t.string :username, :null => false, :default => "" >> t.string :encrypted_password, :null => false, :default => "" >> >> ## Recoverable >> t.string :reset_password_token >> t.datetime :reset_password_sent_at >> >> ## Rememberable >> t.datetime :remember_created_at >> >> ## Trackable >> t.integer :sign_in_count, :default => 0 >> t.datetime :current_sign_in_at >> t.datetime :last_sign_in_at >> t.string :current_sign_in_ip >> t.string :last_sign_in_ip >> >> ## Confirmable >> # t.string :confirmation_token >> # t.datetime :confirmed_at >> # t.datetime :confirmation_sent_at >> # t.string :unconfirmed_email # Only if using reconfirmable >> >> ## Lockable >> # t.integer :failed_attempts, :default => 0 # Only if lock strategy >> is :failed_attempts >> # t.string :unlock_token # Only if unlock strategy is :email or >> :both >> # t.datetime :locked_at >> >> ## Token authenticatable >> # t.string :authentication_token >> >> >> # Uncomment below if timestamps were not included in your original >> model. >> # t.timestamps >> end >> >> add_index :users, :email >> add_index :users, :username, :unique => true >> add_index :users, :reset_password_token, :unique => true >> add_index :users, :confirmation_token, :unique => true >> add_index :users, :unlock_token, :unique => true >> add_index :users, :authentication_token, :unique => true >> end >> >> def self.down >> # By default, we don''t want to make any assumption about how to roll >> back a migration when your >> # model already existed. Please edit below which fields you would like >> to remove in this migration. >> raise ActiveRecord::IrreversibleMigration >> end >> end >> >> >> But now I get this error message : SQLite3::SQLException: no such table: >> users: ALTER TABLE "users" ADD "username" varchar(255) DEFAULT '''' NOT NULL >> >> Anyone a idea how to solve this ? >> This is a clean install. >> >> Roelof >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To unsubscribe from this group, send email to >> rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org >> To view this discussion on the web visit >> https://groups.google.com/d/msg/rubyonrails-talk/-/xpJZWxxT_9IJ. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> > > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.