This project is archived and is in readonly mode.
Migrations will not run on a fresh database
Reported by Ian White | April 14th, 2008 @ 06:33 PM
When migrating to a specified version on a clean db, the schema_migrations table can't be found, and an error is raised.
On a clean rails app:
script/generate migration Foo
create db/migrate
create db/migrate/20080414172731_foo.rb
rake db:migrate VERSION=20080414172731
rake aborted!
SQLite3::SQLException: no such table: schema_migrations: SELECT version FROM schema_migrations
Comments and changes to this ticket
-
Ian White April 14th, 2008 @ 06:40 PM
Here's a git patch that adds a test for the above ticket, and fixes it
-
-
-
Sam Granieri April 14th, 2008 @ 11:08 PM
+1
Nice catch Ian, but the workflow you describe in getting to the problem is something i've never experienced
-
Ian White April 15th, 2008 @ 10:15 AM
If your test/ci stuff wipes out a database then migrates up to a particular version, then you'll see this.
The reason I saw is that this is exactly what rspec does. See http://rspec.lighthouseapp.com/p...
-
Ian White April 15th, 2008 @ 03:57 PM
The commit url http://github.com/ianwhite/rails...
(still learning github)
-
josh April 17th, 2008 @ 07:33 PM
- State changed from “new” to “open”
- Assigned user set to “josh”
- Title changed from “Since r9244, migrations broken on clean db” to “Migrations will not run on a fresh database”
-
Repository April 17th, 2008 @ 07:44 PM
- State changed from “open” to “resolved”
(from [82b4faf81218bbd8916ab559590db236c7f80e46]) Fix migrations when migrating to a specified version number with a fresh database [#1 state:resolved]
Signed-off-by: Joshua Peek
-
Repository March 2nd, 2009 @ 05:47 AM
- Tag set to “activerecord, migrations, patch”
(from [38136f86dc5504bde94dc7399d4a854023d7481f]) DDL transactions and savepoints for sqlite
Sqlite has had DDL transactions since 2.0.0[1] and savepoints since 3.6.8[2]. This patch updates the connection_adapters.
[1] http://tinyurl.com/sqlite-v2-0-0 [2] http://tinyurl.com/sqlite-v3-6-8
Signed-off-by: Michael Koziarski michael@koziarski.com [#2080 state:committed] http://github.com/rails/rails/co...
-
Repository March 2nd, 2009 @ 05:47 AM
(from [38136f86dc5504bde94dc7399d4a854023d7481f]) DDL transactions and savepoints for sqlite
Sqlite has had DDL transactions since 2.0.0[1] and savepoints since 3.6.8[2]. This patch updates the connection_adapters.
[1] http://tinyurl.com/sqlite-v2-0-0 [2] http://tinyurl.com/sqlite-v3-6-8
Signed-off-by: Michael Koziarski michael@koziarski.com [#2080 state:committed] http://github.com/rails/rails/co...
-
klkk May 23rd, 2011 @ 03:08 AM
- State changed from “resolved” to “committed”
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
<h2 style="font-size: 14px">Tickets have moved to Github</h2>
The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>
People watching this ticket
Ian White
Repository
Sam Granieri
Attachments
Tags
Referenced by
-
1109
object allocation during garbage collection phase
uname -a Linux georgiev 2.6.25.16 #1 SMP PREEMPT Thu
Sep ...
-
1158
Rails.env.environment? extremely slow
#1
0.000000 0.000000 0.000000 ( 0.001687)
$./script/perfo...
-
1158
Rails.env.environment? extremely slow
#1
0.000000 0.000000 0.000000 ( 0.000024)
-
1142
Improved parameter parsing for complex forms
Alright, here's patch #1 which restructures the guts of A...
-
831
count on HABTMs broken by Ruby 1.8.7 Array.count
I confirm this for Debian/Lenny, 2.6.26-1-686 #1 SMP, wit...
-
4437
XML Mini Parser NoMethodError :getc when application running through Phusion Passenger
Rails Version: 3.0.0 beta 3
Scenario: ActiveResource from...
-
1251
default_url_options can't be used with named routes
@@ Exception while calling 'book_path(1)': #1,
:controlle...
-
3579
ActiveRecord not setting/checking MySQL session variable time_zone
Because this is a rare, off-the-Rails-way case, I don't t...
-
3144
undefined method `^' for String - RoR 2.3.4
and also with --force, neither works. Hunk #1 FAILED at 4...
-
1788
Telling ActiveRecord::ConnectionAdapters::SchemaStatements#create_table to not create a primary key isn't effective if you manually create an id column
Problem #1 - Person should not have any primary key,
clea...
-
1801
TestSession and AbstractStore delete and update methods do not match in parameter count
I would propose the following steps: 1) Create save_test_...
-
1825
Using Fixtures docs in API RDoc needs work
Recommend moving method #3 to be the primary method, and ...
-
1355
Inflector.underscore() is not consistent with camelize()
My personal feeling is that #1 is ignoring the fundamenta...
-
2128
ActiveRecord::find_in_batches bug or feature?
I applied a fix for this to the latest version of batches...
-
2488
Ability to set the filename for inline MIME parts
patching file test/mail_service_test.rb Hunk #1 succeeded...
-
2488
Ability to set the filename for inline MIME parts
patching file test/mail_service_test.rb Hunk #1 succeeded...
-
2104
script/console execs irb, causes double process-launch and limits other impls
sorry looks like lighthouse monkeyed with my post. #1 sho...
-
2738
[PATCH] Fix zero length stylesheet cache files bug in case of missing CSS files
If we went with option #1 there is the additional complic...
-
2738
[PATCH] Fix zero length stylesheet cache files bug in case of missing CSS files
My vote is for solution #1, but I wouldn't mind some addi...
-
2738
[PATCH] Fix zero length stylesheet cache files bug in case of missing CSS files
My vote is for solution #1, but I wouldn't mind some addi...
-
4361
has_many through self join does not include table alias, so fails
patching file
activerecord/test/cases/associations/has_ma...
-
4361
has_many through self join does not include table alias, so fails
patching file
activerecord/test/cases/associations/has_ma...
-
4361
has_many through self join does not include table alias, so fails
patching file
activerecord/test/cases/associations/has_ma...
-
4361
has_many through self join does not include table alias, so fails
patching file
activerecord/test/cases/associations/has_ma...
-
4361
has_many through self join does not include table alias, so fails
patching file
activerecord/test/cases/associations/has_ma...
-
1244
caches_page does not respect Accept header
Post-action, generate the cache key from the response,
no...
-
5307
Module table_name_prefix not respected for using set_table_name
As far as #1 is concerned, I could not duplicate it, I co...
-
5307
Module table_name_prefix not respected for using set_table_name
To be clear on #1 the module's table_name_prefix is ignor...
-
6246
Time.zone is broken in most every version of rails including 3.x
Regarding point #1, "Setting Time.zone persists across th...
-
6246
Time.zone is broken in most every version of rails including 3.x
As Alex has pointed out, #1 is not a bug or an issue, Rai...