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

Ruby Apps Radiant CMS
1

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:inexecute’
/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:inexecute’
/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:inselect_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:infind_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:infind_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:inbottom_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:inadd_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:inevaluate_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:inrun’
/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:insend’
/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:inrun_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:increate’
/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:increate_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:insave_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:insend’
/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:intransaction’
/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:inwith_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:inrollback_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:increate_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:increate_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:increate_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:increate_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:increate_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:inbootstrap’
/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:incall’
/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:ineach’
/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:ininvoke_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:ininvoke_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:ininvoke_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:ineach’
/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:instandard_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:inrun’
/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:inrun’
/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$

2

On Fri, Nov 5, 2010 at 9:57 PM, Marc [email protected] 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

3

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