# After installing radiant-copy-move and radiant-reorder-extension I get the following error

**URL:** <https://www.ruby-forum.com/t/after-installing-radiant-copy-move-and-radiant-reorder-extension-i-get-the-following-error/198725>\
**Category:** Radiant CMS\
**Created:** [November 6, 2010, 2:58am UTC](https://www.ruby-forum.com/t/after-installing-radiant-copy-move-and-radiant-reorder-extension-i-get-the-following-error/198725 "2010-11-06T02:58:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/77aa72/32.png) [@Dobai-Pataky\_BSSSSl](https://www.ruby-forum.com/u/Dobai-Pataky_BSSSSl)\
**Post date:** [November 6, 2010, 2:58am UTC](https://www.ruby-forum.com/t/after-installing-radiant-copy-move-and-radiant-reorder-extension-i-get-the-following-error/198725/1 "2010-11-06T02:58:20Z")

</div>

Hello,

I’ve come unstuck and would appreciate some help…

Just kicking the tires of Radiant and was having fun until I got the  
following error after installing radiant-copy-move and radiant-reorder  
extensions:

SQLite3::SQLException: no such column: position: SELECT \* FROM “pages”  
WHERE (parent\_id IS NULL) ORDER BY position DESC LIMIT 1

I’ve rake production db:bootstrap trace to see if that would fix  
things and get:

# Marcia:heroku\_radiant marc$ rake production db:bootstrap --trace (in /Users/marc/src/radiant/heroku\_radiant) \*\* Invoke production (first\_time) \*\* Execute production \*\* Invoke environment (first\_time) \*\* Execute environment \*\* Invoke db:bootstrap (first\_time) \*\* Invoke db:remigrate (first\_time) \*\* Invoke environment \*\* Execute db:remigrate This task will destroy any data in the database. Are you sure you want to continue? [yn] y == ChangeUserLanguageToLocale: reverting

# – rename\_column(“users”, “locale”, “language”) -\> 0.0370s == ChangeUserLanguageToLocale: reverted (0.0371s)

# == RenameDeveloperRoleToDesigner: reverting

# – rename\_column(“users”, “designer”, “developer”) -\> 0.0720s == RenameDeveloperRoleToDesigner: reverted (0.0722s)

# == AddUserLanguage: reverting

# – remove\_column(:users, :language) -\> 0.0137s == AddUserLanguage: reverted (0.0138s)

# == AddIndexes: reverting

# – remove\_index(:page\_parts, {:name=\>“parts\_by\_page”}) -\> 0.0006s – remove\_index(:pages, {:name=\>“pages\_published”}) -\> 0.0009s – remove\_index(:pages, {:name=\>“pages\_child\_slug”}) -\> 0.0006s – remove\_index(:pages, {:name=\>“pages\_parent\_id”}) -\> 0.0005s – remove\_index(:pages, {:name=\>“pages\_class\_name”}) -\> 0.0004s == AddIndexes: reverted (0.0033s)

# == RemoveSessionExpireFromUsers: reverting

# – add\_column(:users, :session\_expire, :datetime) -\> 0.0006s == RemoveSessionExpireFromUsers: reverted (0.0007s)

# == AddSessionInfoToUsers: reverting

# – remove\_column(:users, :session\_token) -\> 0.0134s – remove\_column(:users, :session\_expire) -\> 0.0125s == AddSessionInfoToUsers: reverted (0.0262s)

# == AddSaltToUsers: reverting

# – remove\_column(:users, :salt) -\> 0.0685s == AddSaltToUsers: reverted (0.0686s)

# == AddDescriptionAndKeywordsToPages: reverting

# – remove\_column(:pages, :keywords) -\> 0.0099s – remove\_column(:pages, :description) -\> 0.0087s == AddDescriptionAndKeywordsToPages: reverted (0.0189s)

# == RenameCreatedByUpdatedByColumns: reverting

# – rename\_column(“pages”, :created\_by\_id, :created\_by) -\> 0.0096s – rename\_column(“pages”, :updated\_by\_id, :updated\_by) -\> 0.0136s – rename\_column(“snippets”, :created\_by\_id, :created\_by) -\> 0.0736s – rename\_column(“snippets”, :updated\_by\_id, :updated\_by) -\> 0.0103s – rename\_column(“layouts”, :created\_by\_id, :created\_by) -\> 0.0055s – rename\_column(“layouts”, :updated\_by\_id, :updated\_by) -\> 0.0055s – rename\_column(“users”, :created\_by\_id, :created\_by) -\> 0.0087s – rename\_column(“users”, :updated\_by\_id, :updated\_by) -\> 0.0104s == RenameCreatedByUpdatedByColumns: reverted (0.1380s)

# == AddSessions: reverting

# – drop\_table(:sessions) -\> 0.0006s == AddSessions: reverted (0.0008s)

# == AddOptimisticLocking: reverting

# – remove\_column(:pages, :lock\_version) -\> 0.0667s – remove\_column(:layouts, :lock\_version) -\> 0.0067s – remove\_column(:snippets, :lock\_version) -\> 0.0101s – remove\_column(:users, :lock\_version) -\> 0.0092s == AddOptimisticLocking: reverted (0.0933s)

# == RenameConfigDefaultPartsKey: reverting

# == RenameConfigDefaultPartsKey: reverted (0.0046s)

# == AddNotesFieldToUser: reverting

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

# == CreateExtensionMeta: reverting

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

# == RenameTypeColumnOnPageToClassName: reverting

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

# == MergeBehaviorsAndPages: reverting

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

# == AddContentTypeFieldToLayout: reverting

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

# == AddVirtualColumnToPageAgain: reverting

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

# == RemoveVirtualColumnFromPage: reverting

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

# == IntegerColumnsToBoolean: reverting

# == IntegerColumnsToBoolean: saving User data

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

# == IntegerColumnsToBoolean: saving User data

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

# == IntegerColumnsToBoolean: reverted (0.0920s)

# == AddVirtualColumnToPage: reverting

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

# == RenameFilterColumn: reverting

# – rename\_column(:page\_parts, :filter\_id, :filter) -\> 0.0059s – rename\_column(:snippets, :filter\_id, :filter) -\> 0.0096s == RenameFilterColumn: reverted (0.0158s)

# == RenameBehaviorColumn: reverting

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

# == InsertInitialData: reverting

# == InsertInitialData: reverted (0.0000s)

# == CreateRadiantTables: reverting

# – drop\_table(“pages”) -\> 0.0004s – drop\_table(“page\_parts”) -\> 0.0005s – drop\_table(“snippets”) -\> 0.0005s – drop\_table(“layouts”) -\> 0.0003s – drop\_table(“users”) -\> 0.0004s – drop\_table(“config”) -\> 0.0004s == CreateRadiantTables: reverted (0.0031s)

# \*\* 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.0012s – add\_index(“config”, [“key”], {:name=\>“key”, :unique=\>true}) -\> 0.0006s – create\_table(“pages”, {:force=\>true}) -\> 0.0019s – create\_table(“page\_parts”, {:force=\>true}) -\> 0.0008s – create\_table(“snippets”, {:force=\>true}) -\> 0.0010s – add\_index(“snippets”, [“name”], {:name=\>“name”, :unique=\>true}) -\> 0.0003s – create\_table(“layouts”, {:force=\>true}) -\> 0.0010s – create\_table(“users”, {:force=\>true}) -\> 0.0015s – add\_index(“users”, [“login”], {:name=\>“login”, :unique=\>true}) -\> 0.0004s == CreateRadiantTables: migrated (0.0095s)

# == InsertInitialData: migrating

# == InsertInitialData: migrated (0.0000s)

# == RenameBehaviorColumn: migrating

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

# == RenameFilterColumn: migrating

# – rename\_column(:page\_parts, :filter, :filter\_id) -\> 0.0046s – rename\_column(:snippets, :filter, :filter\_id) -\> 0.0072s == RenameFilterColumn: migrated (0.0120s)

# == AddVirtualColumnToPage: migrating

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

# == IntegerColumnsToBoolean: migrating

# == IntegerColumnsToBoolean: saving User data

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

# == IntegerColumnsToBoolean: saving User data

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

# == IntegerColumnsToBoolean: migrated (0.0201s)

# == RemoveVirtualColumnFromPage: migrating

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

# == AddVirtualColumnToPageAgain: migrating

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

# == AddContentTypeFieldToLayout: migrating

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

# == MergeBehaviorsAndPages: migrating

# == MergeBehaviorsAndPages: converting behavior names to class names

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

# == RenameTypeColumnOnPageToClassName: migrating

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

# == CreateExtensionMeta: migrating

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

# == AddNotesFieldToUser: migrating

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

# == RenameConfigDefaultPartsKey: migrating

# == RenameConfigDefaultPartsKey: migrated (0.0007s)

# == AddOptimisticLocking: migrating

# – add\_column(:pages, :lock\_version, :integer, {:default=\>0}) -\> 0.0007s – add\_column(:layouts, :lock\_version, :integer, {:default=\>0}) -\> 0.0005s – add\_column(:snippets, :lock\_version, :integer, {:default=\>0}) -\> 0.0004s – add\_column(:users, :lock\_version, :integer, {:default=\>0}) -\> 0.0004s == AddOptimisticLocking: migrated (0.0024s)

# == AddSessions: migrating

# – create\_table(:sessions) -\> 0.0010s – add\_index(:sessions, :session\_id) -\> 0.0004s – add\_index(:sessions, :updated\_at) -\> 0.0004s == AddSessions: migrated (0.0020s)

# == RenameCreatedByUpdatedByColumns: migrating

# – rename\_column(“pages”, :created\_by, :created\_by\_id) -\> 0.0097s – rename\_column(“pages”, :updated\_by, :updated\_by\_id) -\> 0.0117s – rename\_column(“snippets”, :created\_by, :created\_by\_id) -\> 0.0095s – rename\_column(“snippets”, :updated\_by, :updated\_by\_id) -\> 0.0651s – rename\_column(“layouts”, :created\_by, :created\_by\_id) -\> 0.0061s – rename\_column(“layouts”, :updated\_by, :updated\_by\_id) -\> 0.0066s – rename\_column(“users”, :created\_by, :created\_by\_id) -\> 0.0115s – rename\_column(“users”, :updated\_by, :updated\_by\_id) -\> 0.0088s == RenameCreatedByUpdatedByColumns: migrated (0.1299s)

# == AddDescriptionAndKeywordsToPages: migrating

# – add\_column(:pages, :description, :string) -\> 0.0011s – add\_column(:pages, :keywords, :string) -\> 0.0005s == AddDescriptionAndKeywordsToPages: migrated (0.0019s)

# == AddSaltToUsers: migrating

# – add\_column(:users, :salt, :string) -\> 0.0005s == AddSaltToUsers: migrated (0.0009s)

# == AddSessionInfoToUsers: migrating

# – add\_column(:users, :session\_token, :string) -\> 0.0005s – add\_column(:users, :session\_expire, :datetime) -\> 0.0003s == AddSessionInfoToUsers: migrated (0.0010s)

# == RemoveSessionExpireFromUsers: migrating

# – remove\_column(:users, :session\_expire) -\> 0.0677s == RemoveSessionExpireFromUsers: migrated (0.0679s)

# == AddIndexes: migrating

# – add\_index(:pages, :class\_name, {:name=\>“pages\_class\_name”}) -\> 0.0006s – add\_index(:pages, :parent\_id, {:name=\>“pages\_parent\_id”}) -\> 0.0004s – add\_index(:pages, [“slug”, “parent\_id”], {:name=\>“pages\_child\_slug”}) -\> 0.0005s – add\_index(:pages, [“virtual”, “status\_id”], {:name=\>“pages\_published”}) -\> 0.0007s – add\_index(:page\_parts, [“page\_id”, “name”], {:name=\>“parts\_by\_page”}) -\> 0.0003s == AddIndexes: migrated (0.0029s)

# == AddUserLanguage: migrating

# – add\_column(:users, :language, :string) -\> 0.0005s == AddUserLanguage: migrated (0.0006s)

# == RenameDeveloperRoleToDesigner: migrating

# – rename\_column(“users”, “developer”, “designer”) -\> 0.0120s == RenameDeveloperRoleToDesigner: migrated (0.0121s)

# == ChangeUserLanguageToLocale: migrating

# – rename\_column(“users”, “language”, “locale”) -\> 0.0110s == ChangeUserLanguageToLocale: migrated (0.0112s)

\*\* Invoke db:schema:dump (first\_time)  
\*\* Invoke environment  
\*\* Execute db:schema:dump  
\*\* Invoke db:schema:dump (first\_time)  
\*\* Invoke environment  
\*\* Execute db:schema:dump  
\*\* Execute db:bootstrap

Create the admin user (press enter for defaults).  
Name (Administrator):  
Username (admin):  
Password (radiant):

Initializing configuration…OK

Select a database template:

1. Empty
2. Roasters (a coffee-themed blog / brochure)
3. Simple Blog
4. Styled Blog  
[1-4]: 2

Creating Snippets…OK  
Creating Pages…FAILED  
rake aborted!  
SQLite3::SQLException: no such column: position: SELECT \* FROM “pages”  
WHERE (parent\_id IS NULL) ORDER BY position DESC LIMIT 1  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/connection\_adapters/abstract\_adapter.rb:  
221:in `log' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb: 172:in`execute’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/connection\_adapters/sqlite\_adapter.rb:  
417:in `catch_schema_changes' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb: 172:in`execute’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/connection\_adapters/sqlite\_adapter.rb:  
320:in `select' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/connection_adapters/abstract/ database_statements.rb:7:in`select\_all\_without\_query\_cache’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/connection\_adapters/abstract/  
query\_cache.rb:62:in `select_all' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/base.rb:664:in`find\_by\_sql’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/base.rb:1578:in `find_every' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/base.rb:1535:in`find\_initial’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/base.rb:616:in `find' /Users/marc/src/radiant/heroku_radiant/vendor/extensions/reorder/ vendor/plugins/acts_as_list/lib/active_record/acts/list.rb:198:in`bottom\_item’  
/Users/marc/src/radiant/heroku\_radiant/vendor/extensions/reorder/  
vendor/plugins/acts\_as\_list/lib/active\_record/acts/list.rb:190:in  
`bottom_position_in_list' /Users/marc/src/radiant/heroku_radiant/vendor/extensions/reorder/ vendor/plugins/acts_as_list/lib/active_record/acts/list.rb:181:in`add\_to\_list\_bottom’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activesupport/lib/active\_support/callbacks.rb:178:in `send' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activesupport/lib/active_support/callbacks.rb:178:in`evaluate\_method’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activesupport/lib/active\_support/callbacks.rb:166:in `call' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activesupport/lib/active_support/callbacks.rb:93:in`run’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activesupport/lib/active\_support/callbacks.rb:92:in `each' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activesupport/lib/active_support/callbacks.rb:92:in`send’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activesupport/lib/active\_support/callbacks.rb:92:in `run' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activesupport/lib/active_support/callbacks.rb:276:in`run\_callbacks’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/callbacks.rb:344:in `callback' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/callbacks.rb:265:in`create’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/base.rb:2915:in  
`create_or_update_without_callbacks' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/callbacks.rb:250:in`create\_or\_update’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/base.rb:2573:in  
`save_without_validation' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/validations.rb:1090:in`save\_without\_dirty’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/dirty.rb:79:in  
`save_without_transactions' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/transactions.rb:229:in`send’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/transactions.rb:229:in  
`with_transaction_returning_status' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/connection_adapters/abstract/ database_statements.rb:136:in`transaction’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/transactions.rb:182:in `transaction' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/transactions.rb:228:in`with\_transaction\_returning\_status’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/transactions.rb:196:in `save' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/ activerecord/lib/active_record/transactions.rb:208:in`rollback\_active\_record\_state!’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/vendor/rails/  
activerecord/lib/active\_record/transactions.rb:196:in `save' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 148:in`create\_records’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
147:in `each' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 147:in`create\_records’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
208:in `step' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 146:in`create\_records’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
195:in `feedback' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 142:in`create\_records’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
141:in `each' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 141:in`create\_records’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
79:in `load_database_template' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb: 22:in`bootstrap’  
/opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/radiant/setup.rb:  
10:in `bootstrap' /opt/local/lib/ruby/gems/1.8/gems/radiant-0.9.1/lib/tasks/ database.rake:24 /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in`call’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in  
`execute' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in`each’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in  
`execute' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in`invoke\_with\_call\_chain’  
/opt/local/lib/ruby/1.8/monitor.rb:242:in `synchronize' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in`invoke\_with\_call\_chain’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in  
`invoke' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in`invoke\_task’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in  
`top_level' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in`each’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in  
`top_level' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in`standard\_exception\_handling’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in  
`top_level' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in`run’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in  
`standard_exception_handling' /opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in`run’  
/opt/local/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31  
/opt/local/bin/rake:19:in `load’  
/opt/local/bin/rake:19  
Marcia:heroku\_radiant marc$

---

<div class="post-metadata">

**Author:** ![marc](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@marc](https://www.ruby-forum.com/u/marc)\
**Post date:** [November 6, 2010, 3:36am UTC](https://www.ruby-forum.com/t/after-installing-radiant-copy-move-and-radiant-reorder-extension-i-get-the-following-error/198725/2 "2010-11-06T03:36:36Z")

</div>

On Fri, Nov 5, 2010 at 9:57 PM, Marc [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hello,
> 
> I’ve come unstuck and would appreciate some help…
> 
> Just kicking the tires of Radiant and was having fun until I got the  
> following error after installing radiant-copy-move and radiant-reorder  
> extensions:
> 
> SQLite3::SQLException: no such column: position: SELECT \* FROM “pages”  
> WHERE (parent\_id IS NULL) ORDER BY position DESC LIMIT 1

The error says “no such column: position”

Did you run “rake db:migrate:extensions” after installing your  
extensions?  
Or run each one individually like “rake  
radiant:extensions:reorder:migrate”

Reorder might be written in a way that makes it difficult to bootstrap  
while it is installed.  
I assume that it adds information about a “position” column when the  
application initializes (which happens during bootstrap) but if you  
don’t have that column in the database then it fails because the code  
requires it.

For now, do this:

mv vendor/extensions/reorder vendor/reorder  
rake db:bootstrap  
mv vendor/reorder vendor/extensions/reorder  
rake db:migrate:extensions

---

<div class="post-metadata">

**Author:** ![marc](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/8dc957/32.png) [@marc](https://www.ruby-forum.com/u/marc)\
**Post date:** [November 6, 2010, 6:58am UTC](https://www.ruby-forum.com/t/after-installing-radiant-copy-move-and-radiant-reorder-extension-i-get-the-following-error/198725/3 "2010-11-06T06:58:44Z")

</div>

Thanks for the answer

Ah, it helps to do both

> rake db:bootstrap  
> rake db:migrate:extensions

and

> rake production db:bootstrap  
> rake production db:migrate:extensions

I was running my server with in production doh

Still learning

Regards,

Marc