# Db:bootstrap issue continued

**URL:** <https://www.ruby-forum.com/t/db-bootstrap-issue-continued/106386>\
**Category:** Radiant CMS\
**Created:** [June 9, 2007, 3:50pm UTC](https://www.ruby-forum.com/t/db-bootstrap-issue-continued/106386 "2007-06-09T15:50:02Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jomz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/dfb087/32.png) [@jomz](https://www.ruby-forum.com/u/jomz)\
**Post date:** [June 9, 2007, 3:50pm UTC](https://www.ruby-forum.com/t/db-bootstrap-issue-continued/106386/1 "2007-06-09T15:50:02Z")

</div>

I’m having problems with the db:bootstrap again. For some reason,  
whenever i  
bootstrap, migrate, remigrate or import, the db first gets migrated to  
latest version (15), then i’m asked to confirm again, and the db is  
reverted  
back to version 0. after that it naturally fails when trying to run the  
setup and create users…

I’m on radiant edge, i re-created the db trough mysqladmin, to no avail.  
I’m aware that i’m not in production environment, but that shouldn’t be  
an  
issue.

Here’s a trace of db:bootstrap;

# MBPjomz:~/rails/gemified bennydegezelle$ rake db:bootstrap --trace (in /Users/bennydegezelle/rails/gemified) \*\* Invoke db:bootstrap (first\_time) \*\* Invoke db:remigrate (first\_time) \*\* Invoke environment (first\_time) \*\* Execute environment Extensions cannot be used until Radiant migrations are up to date. \*\* Execute db:remigrate This task will destroy any data in the database. Are you sure you want to continue? [yn] y \*\* Invoke db:migrate (first\_time) \*\* Invoke environment \*\* Execute db:migrate \*\* Invoke db:schema:dump (first\_time) \*\* Invoke environment \*\* Execute db:schema:dump == CreateRadiantTables: migrating

# – create\_table(“config”, {:force=\>true}) -\> 0.0033s – add\_index(“config”, [“key”], {:name=\>“key”, :unique=\>true}) -\> 0.4381s – create\_table(“pages”, {:force=\>true}) -\> 0.0329s – create\_table(“page\_parts”, {:force=\>true}) -\> 0.0035s – create\_table(“snippets”, {:force=\>true}) -\> 0.0037s – add\_index(“snippets”, [“name”], {:name=\>“name”, :unique=\>true}) -\> 0.0069s – create\_table(“layouts”, {:force=\>true}) -\> 0.0035s – create\_table(“users”, {:force=\>true}) -\> 0.0041s – add\_index(“users”, [“login”], {:name=\>“login”, :unique=\>true}) -\> 0.0064s == CreateRadiantTables: migrated (0.5037s)

# == InsertInitialData: migrating

# == InsertInitialData: migrated (0.0000s)

# == RenameBehaviorColumn: migrating

# – rename\_column(:pages, :behavior, :behavior\_id) -\> 0.0210s == RenameBehaviorColumn: migrated (0.0211s)

# == RenameFilterColumn: migrating

# – rename\_column(:page\_parts, :filter, :filter\_id) -\> 0.0077s – rename\_column(:snippets, :filter, :filter\_id) -\> 0.0086s == RenameFilterColumn: migrated (0.0166s)

# == AddVirtualColumnToPage: migrating

# – add\_column(“pages”, “virtual”, :boolean, {:null=\>false, :default=\>false}) -\> 0.0177s == AddVirtualColumnToPage: migrated (0.0180s)

# == IntegerColumnsToBoolean: migrating

# == IntegerColumnsToBoolean: saving User data

# – remove\_column(“users”, “admin”) -\> 0.0056s – add\_column(“users”, “admin”, :boolean, {:null=\>false, :default=\>false}) -\> 0.0055s == IntegerColumnsToBoolean: restoring User data

# == IntegerColumnsToBoolean: saving User data

# – remove\_column(“users”, “developer”) -\> 0.0181s – add\_column(“users”, “developer”, :boolean, {:null=\>false, :default=\>false}) -\> 0.0066s == IntegerColumnsToBoolean: restoring User data

# == IntegerColumnsToBoolean: migrated (0.0396s)

# == RemoveVirtualColumnFromPage: migrating

# – remove\_column(“pages”, “virtual”) -\> 0.0744s == RemoveVirtualColumnFromPage: migrated (0.0747s)

# == AddVirtualColumnToPageAgain: migrating

# – add\_column(“pages”, “virtual”, :boolean, {:null=\>false, :default=\>false}) -\> 0.0060s == AddVirtualColumnToPageAgain: migrated (0.0061s)

# == AddContentTypeFieldToLayout: migrating

# – add\_column(“layouts”, “content\_type”, :string, {:limit=\>40}) -\> 0.0061s == AddContentTypeFieldToLayout: migrated (0.0062s)

# == MergeBehaviorsAndPages: migrating

# == MergeBehaviorsAndPages: converting behavior names to class names

# – rename\_column(:pages, :behavior\_id, :type) -\> 0.0088s == MergeBehaviorsAndPages: migrated (0.0110s)

# == RenameTypeColumnOnPageToClassName: migrating

# – rename\_column(“pages”, “type”, “class\_name”) -\> 0.0089s == RenameTypeColumnOnPageToClassName: migrated (0.0092s)

# == CreateExtensionMeta: migrating

# – create\_table(“extension\_meta”, {:force=\>true}) -\> 0.0033s == CreateExtensionMeta: migrated (0.0034s)

# == AddNotesFieldToUser: migrating

# – add\_column(“users”, “notes”, :text) -\> 0.0155s == AddNotesFieldToUser: migrated (0.0156s)

# == RenameConfigDefaultPartsKey: migrating

# == RenameConfigDefaultPartsKey: migrated (0.0064s)

# == AddOptimisticLocking: migrating

# – add\_column(:pages, :lock\_version, :integer, {:default=\>0}) -\> 0.0074s – add\_column(:layouts, :lock\_version, :integer, {:default=\>0}) -\> 0.0082s – add\_column(:snippets, :lock\_version, :integer, {:default=\>0}) -\> 0.0178s – add\_column(:users, :lock\_version, :integer, {:default=\>0}) -\> 0.0063s == AddOptimisticLocking: migrated (0.0407s)

# \*\* Invoke db:schema:dump \*\* Invoke db:schema:dump \*\* Invoke db:schema:dump This task will destroy any data in the database. Are you sure you want to continue? [yn] y == AddOptimisticLocking: reverting

# – remove\_column(:pages, :lock\_version) -\> 0.0687s – remove\_column(:layouts, :lock\_version) -\> 0.0064s – remove\_column(:snippets, :lock\_version) -\> 0.0065s – remove\_column(:users, :lock\_version) -\> 0.0908s == AddOptimisticLocking: reverted (0.1729s)

# == RenameConfigDefaultPartsKey: reverting

# == RenameConfigDefaultPartsKey: reverted (0.0011s)

# == AddNotesFieldToUser: reverting

# – remove\_column(“users”, “notes”) -\> 0.0073s == AddNotesFieldToUser: reverted (0.0075s)

# == CreateExtensionMeta: reverting

# – drop\_table(“extension\_meta”) -\> 0.0019s == CreateExtensionMeta: reverted (0.0021s)

# == RenameTypeColumnOnPageToClassName: reverting

# – rename\_column(“pages”, “class\_name”, “type”) -\> 0.0098s == RenameTypeColumnOnPageToClassName: reverted (0.0100s)

# == MergeBehaviorsAndPages: reverting

# – rename\_column(:pages, :type, :behavior\_id) -\> 0.0083s == MergeBehaviorsAndPages: converting class names back to behavior names

# == MergeBehaviorsAndPages: reverted (0.0115s)

# == AddContentTypeFieldToLayout: reverting

# – remove\_column(“layouts”, “content\_type”) -\> 0.0050s == AddContentTypeFieldToLayout: reverted (0.0052s)

# == AddVirtualColumnToPageAgain: reverting

# – remove\_column(“pages”, “virtual”) -\> 0.0063s == AddVirtualColumnToPageAgain: reverted (0.0064s)

# == RemoveVirtualColumnFromPage: reverting

# – add\_column(“pages”, “virtual”, :boolean, {:null=\>false, :default=\>false}) -\> 0.0071s == RemoveVirtualColumnFromPage: reverted (0.0073s)

# == IntegerColumnsToBoolean: reverting

# == IntegerColumnsToBoolean: saving User data

# – remove\_column(“users”, “admin”) -\> 0.0187s – add\_column(“users”, “admin”, :integer, {:null=\>false, :default=\>0, :limit=\>1}) -\> 0.0069s == IntegerColumnsToBoolean: restoring User data

# == IntegerColumnsToBoolean: saving User data

# – remove\_column(“users”, “developer”) -\> 0.0055s – add\_column(“users”, “developer”, :integer, {:null=\>false, :default=\>0, :limit=\>1}) -\> 0.0062s == IntegerColumnsToBoolean: restoring User data

# == IntegerColumnsToBoolean: reverted (0.0415s)

# == AddVirtualColumnToPage: reverting

# – remove\_column(“pages”, “virtual”) -\> 0.0070s == AddVirtualColumnToPage: reverted (0.0071s)

# == RenameFilterColumn: reverting

# – rename\_column(:page\_parts, :filter\_id, :filter) -\> 0.0106s – rename\_column(:snippets, :filter\_id, :filter) -\> 0.0342s == RenameFilterColumn: reverted (0.0452s)

# == RenameBehaviorColumn: reverting

# – rename\_column(:pages, :behavior\_id, :behavior) -\> 0.0099s == RenameBehaviorColumn: reverted (0.0101s)

# == InsertInitialData: reverting

# == InsertInitialData: reverted (0.0000s)

# == CreateRadiantTables: reverting

# – drop\_table(“pages”) -\> 0.0024s – drop\_table(“page\_parts”) -\> 0.0031s – drop\_table(“snippets”) -\> 0.0019s – drop\_table(“layouts”) -\> 0.0016s – drop\_table(“users”) -\> 0.0016s – drop\_table(“config”) -\> 0.0019s == CreateRadiantTables: reverted (0.0129s)

\*\* Invoke db:migrate  
\*\* Invoke db:schema:dump  
\*\* Execute db:bootstrap

Create the admin user (press enter for defaults).  
Name (Administrator):  
Username (admin):  
Password (radiant):  
rake aborted!  
Mysql::Error: #42S02Table ‘dequeeste\_development.users’ doesn’t exist:  
SHOW  
FIELDS FROM users  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/vendor/rails/activerecord/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' /Users/bennydegezelle/rails/gemified/config/../vendor/radiant/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:243:in`execute’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/vendor/rails/activerecord/lib/active\_record/connection\_adapters/mysql\_adapter.rb:348:in  
`columns' /Users/bennydegezelle/rails/gemified/config/../vendor/radiant/vendor/rails/activerecord/lib/active_record/base.rb:763:in`columns’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/vendor/rails/activerecord/lib/active\_record/base.rb:776:in  
`column_names' /Users/bennydegezelle/rails/gemified/config/../vendor/radiant/vendor/rails/activerecord/lib/active_record/base.rb:789:in`column\_methods\_hash’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/vendor/rails/activerecord/lib/active\_record/base.rb:1262:in  
`all_attributes_exists?' /usr/local/lib/ruby/1.8/erb.rb:741:in`all?’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/vendor/rails/activerecord/lib/active\_record/base.rb:1262:in  
`all_attributes_exists?' /Users/bennydegezelle/rails/gemified/config/../vendor/radiant/vendor/rails/activerecord/lib/active_record/base.rb:1196:in`method\_missing’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/lib/radiant/setup.rb:40:in  
`create_admin_user' /Users/bennydegezelle/rails/gemified/config/../vendor/radiant/lib/radiant/setup.rb:19:in`bootstrap’  
/Users/bennydegezelle/rails/gemified/config/…/vendor/radiant/lib/radiant/setup.rb:10:in  
`bootstrap' /Users/bennydegezelle/rails/gemified/config/../lib/tasks/database.rake:25 /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in`execute’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in  
`execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in`invoke’  
/usr/local/lib/ruby/1.8/thread.rb:135:in `synchronize' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in`invoke’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in  
`top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in`top\_level’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in  
`standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in`top\_level’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in`standard\_exception\_handling’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run’  
/usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7  
/usr/local/bin/rake:16  
MBPjomz:~/rails/gemified bennydegezelle$

If anybody has a clue as to why it asks for confirmation twice and  
revert  
the migrations, i would love to hear

Met vriendelijke groeten,

Benny D.

Gorilla webdesign  
www.gorilla-webdesign.be

---

<div class="post-metadata">

**Author:** ![jomz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/dfb087/32.png) [@jomz](https://www.ruby-forum.com/u/jomz)\
**Post date:** [June 9, 2007, 6:15pm UTC](https://www.ruby-forum.com/t/db-bootstrap-issue-continued/106386/2 "2007-06-09T18:15:21Z")

</div>

I believe I’m having the same problem, however, mine is during radiant  
instance mode install. I’m creating an empty Rails app, then running  
the radiant command on the new project dir, then running bootstrap, then  
getting the ‘users table does not exist’ error immediately after setting  
the admin username/pwd.

Any suggestions?

-Luke

---

<div class="post-metadata">

**Author:** ![jomz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/dfb087/32.png) [@jomz](https://www.ruby-forum.com/u/jomz)\
**Post date:** [June 9, 2007, 7:20pm UTC](https://www.ruby-forum.com/t/db-bootstrap-issue-continued/106386/3 "2007-06-09T19:20:25Z")

</div>

Unless you intend to hack Radiant into your Rails app (refer to the work  
Matt and Loren have been doing lately), don’t use the ‘rails’ command at  
all. Just the ‘radiant’ command will do. It’s very possible that it’s  
not correctly running the migrations because the boot/environment files  
are not being overwritten.

Sean