-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ok, so rake migrate --trace gets you this: Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake migrate -- trace (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) ** Invoke migrate (first_time) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate ** Execute migrate then it stops, heh. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (Darwin) iD8DBQFErt9QrXJnpd8Tr7MRAuS0AJ9cw2B/07x2TJWR17W5Ku3mXjIXEwCgi+zM 9Kp2HHd7dvfDXT565751yqg=8TpW -----END PGP SIGNATURE-----
On Fri, 2006-07-07 at 17:25 -0500, Samuel Goodwin wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Ok, so rake migrate --trace gets you this: > > > Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake migrate -- > trace > (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) > ** Invoke migrate (first_time) > ** Invoke db:migrate (first_time) > ** Invoke environment (first_time) > ** Execute environment > ** Execute db:migrate > ** Execute migrate > > then it stops, heh.---- what''s the value in the schema_info table? Craig
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Schema info version=0 - --Samuel On Jul 7, 2006, at 5:29 PM, Craig White wrote:> On Fri, 2006-07-07 at 17:25 -0500, Samuel Goodwin wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Ok, so rake migrate --trace gets you this: >> >> >> Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake migrate -- >> trace >> (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) >> ** Invoke migrate (first_time) >> ** Invoke db:migrate (first_time) >> ** Invoke environment (first_time) >> ** Execute environment >> ** Execute db:migrate >> ** Execute migrate >> >> then it stops, heh. > ---- > what''s the value in the schema_info table? > > Craig > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > lists.rubyonrails.org/mailman/listinfo/rails-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (Darwin) iD8DBQFEruKrrXJnpd8Tr7MRAonqAKDb0Iw4/kICojRZrEHDKUV1mRuRywCeKxjO cFidMjpEoFqgNnn6zwbNMKs=aJkc -----END PGP SIGNATURE-----
Since it''s version=0, it won''t be able to create tables in migrations that already exist and you can manually change it to where it should be but recognize that if you migrate backwards, you lose data. HINT - back up entire database before doing anything destructive. Craig On Fri, 2006-07-07 at 17:39 -0500, Samuel Goodwin wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Schema info version=0 > > - --Samuel > > On Jul 7, 2006, at 5:29 PM, Craig White wrote: > > > On Fri, 2006-07-07 at 17:25 -0500, Samuel Goodwin wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA1 > >> > >> Ok, so rake migrate --trace gets you this: > >> > >> > >> Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake migrate -- > >> trace > >> (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) > >> ** Invoke migrate (first_time) > >> ** Invoke db:migrate (first_time) > >> ** Invoke environment (first_time) > >> ** Execute environment > >> ** Execute db:migrate > >> ** Execute migrate > >> > >> then it stops, heh. > > ---- > > what''s the value in the schema_info table? > > > > Craig > > > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > lists.rubyonrails.org/mailman/listinfo/rails > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.3 (Darwin) > > iD8DBQFEruKrrXJnpd8Tr7MRAonqAKDb0Iw4/kICojRZrEHDKUV1mRuRywCeKxjO > cFidMjpEoFqgNnn6zwbNMKs> =aJkc > -----END PGP SIGNATURE----- > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > lists.rubyonrails.org/mailman/listinfo/rails
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I wrote the migrations to check the database in question first and only try to add columns/tables when that column/table wasn''t there already. I''ve tested this on snapshots of our production database numerous times. The problem now is that when I try to run these migrations for our production server (database is on another box) stops before it does anything, as you can see from the pasted output I gave earlier. - -Samuel On Jul 7, 2006, at 5:54 PM, Craig White wrote:> Since it''s version=0, it won''t be able to create tables in migrations > that already exist and you can manually change it to where it > should be > but recognize that if you migrate backwards, you lose data. HINT - > back > up entire database before doing anything destructive. > > Craig > > On Fri, 2006-07-07 at 17:39 -0500, Samuel Goodwin wrote: >> -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> Schema info version=0 >> >> - --Samuel >> >> On Jul 7, 2006, at 5:29 PM, Craig White wrote: >> >>> On Fri, 2006-07-07 at 17:25 -0500, Samuel Goodwin wrote: >>>> -----BEGIN PGP SIGNED MESSAGE----- >>>> Hash: SHA1 >>>> >>>> Ok, so rake migrate --trace gets you this: >>>> >>>> >>>> Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake >>>> migrate -- >>>> trace >>>> (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) >>>> ** Invoke migrate (first_time) >>>> ** Invoke db:migrate (first_time) >>>> ** Invoke environment (first_time) >>>> ** Execute environment >>>> ** Execute db:migrate >>>> ** Execute migrate >>>> >>>> then it stops, heh. >>> ---- >>> what''s the value in the schema_info table? >>> >>> Craig >>> >>> _______________________________________________ >>> Rails mailing list >>> Rails@lists.rubyonrails.org >>> lists.rubyonrails.org/mailman/listinfo/rails >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.3 (Darwin) >> >> iD8DBQFEruKrrXJnpd8Tr7MRAonqAKDb0Iw4/kICojRZrEHDKUV1mRuRywCeKxjO >> cFidMjpEoFqgNnn6zwbNMKs>> =aJkc >> -----END PGP SIGNATURE----- >> _______________________________________________ >> Rails mailing list >> Rails@lists.rubyonrails.org >> lists.rubyonrails.org/mailman/listinfo/rails > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > lists.rubyonrails.org/mailman/listinfo/rails-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (Darwin) iD8DBQFErud2rXJnpd8Tr7MRAjloAKDs/IaVceYeIb9BMCIk0SpqaxWjzACgkDnz 8+HBLdx3NHIZjNIqRJSl0+k=gKTw -----END PGP SIGNATURE-----
I would swear that we are talking the same language anyway...good luck Craig On Fri, 2006-07-07 at 18:00 -0500, Samuel Goodwin wrote:> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > I wrote the migrations to check the database in question first and > only try to add columns/tables when that column/table wasn''t there > already. I''ve tested this on snapshots of our production database > numerous times. The problem now is that when I try to run these > migrations for our production server (database is on another box) > stops before it does anything, as you can see from the pasted output > I gave earlier. > > > - -Samuel > > On Jul 7, 2006, at 5:54 PM, Craig White wrote: > > > Since it''s version=0, it won''t be able to create tables in migrations > > that already exist and you can manually change it to where it > > should be > > but recognize that if you migrate backwards, you lose data. HINT - > > back > > up entire database before doing anything destructive. > > > > Craig > > > > On Fri, 2006-07-07 at 17:39 -0500, Samuel Goodwin wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA1 > >> > >> Schema info version=0 > >> > >> - --Samuel > >> > >> On Jul 7, 2006, at 5:29 PM, Craig White wrote: > >> > >>> On Fri, 2006-07-07 at 17:25 -0500, Samuel Goodwin wrote: > >>>> -----BEGIN PGP SIGNED MESSAGE----- > >>>> Hash: SHA1 > >>>> > >>>> Ok, so rake migrate --trace gets you this: > >>>> > >>>> > >>>> Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake > >>>> migrate -- > >>>> trace > >>>> (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) > >>>> ** Invoke migrate (first_time) > >>>> ** Invoke db:migrate (first_time) > >>>> ** Invoke environment (first_time) > >>>> ** Execute environment > >>>> ** Execute db:migrate > >>>> ** Execute migrate > >>>> > >>>> then it stops, heh. > >>> ---- > >>> what''s the value in the schema_info table? > >>> > >>> Craig > >>> > >>> _______________________________________________ > >>> Rails mailing list > >>> Rails@lists.rubyonrails.org > >>> lists.rubyonrails.org/mailman/listinfo/rails > >> > >> -----BEGIN PGP SIGNATURE----- > >> Version: GnuPG v1.4.3 (Darwin) > >> > >> iD8DBQFEruKrrXJnpd8Tr7MRAonqAKDb0Iw4/kICojRZrEHDKUV1mRuRywCeKxjO > >> cFidMjpEoFqgNnn6zwbNMKs> >> =aJkc > >> -----END PGP SIGNATURE----- > >> _______________________________________________ > >> Rails mailing list > >> Rails@lists.rubyonrails.org > >> lists.rubyonrails.org/mailman/listinfo/rails > > > > _______________________________________________ > > Rails mailing list > > Rails@lists.rubyonrails.org > > lists.rubyonrails.org/mailman/listinfo/rails > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.3 (Darwin) > > iD8DBQFErud2rXJnpd8Tr7MRAjloAKDs/IaVceYeIb9BMCIk0SpqaxWjzACgkDnz > 8+HBLdx3NHIZjNIqRJSl0+k> =gKTw > -----END PGP SIGNATURE----- > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > lists.rubyonrails.org/mailman/listinfo/rails