(I know ''version'' is the only field, but in case this changed one day my question will still apply) ;) I had to drop all my tables to re-run my migrations from version 1. When I executed ''rake db:migrate'' everything ran successfully. Which puts my database ''state'' at migration 007_xxx. Now when I add a migration (008_xxx) and re-run ''rake db:migrate'' I got an error saying the table being create in migration 001_xxx already exists. When I checked the table "select * from schema_info" there was nothing in the table. Inserting the proper version number by hand and re-running my migrate worked and migration 008 worked. All ''rake db:migrate'' being run from here update the table successfully. I can re-create this 100% of the time. Comments? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Jean Nibee wrote:> (I know ''version'' is the only field, but in case this changed one day my > question will still apply) ;) > > I had to drop all my tables to re-run my migrations from version 1. When > I executed ''rake db:migrate'' everything ran successfully. Which puts my > database ''state'' at migration 007_xxx. > > Now when I add a migration (008_xxx) and re-run ''rake db:migrate'' I got > an error saying the table being create in migration 001_xxx already > exists. > > When I checked the table "select * from schema_info" there was nothing > in the table. Inserting the proper version number by hand and re-running > my migrate worked and migration 008 worked. All ''rake db:migrate'' being > run from here update the table successfully. > > I can re-create this 100% of the time. > > Comments?/bump Issue: schema_info not updating / inserting prope migration version after a ''wipe'' and re-creation of the database. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---