Forum: Radiant CMS After installing radiant-copy-move and radiant-reorder-extension I get the following error.

43555bf4a37376d15100caf27151f15e?d=identicon&s=25 Marc (Guest)
on 2010-11-06 02:58
(Received via mailing list)
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$
09477c358c5897d44121a248326e16d7?d=identicon&s=25 Jim Gay (Guest)
on 2010-11-06 03:36
(Received via mailing list)
On Fri, Nov 5, 2010 at 9:57 PM, Marc <marc.boschma@gmail.com> 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
43555bf4a37376d15100caf27151f15e?d=identicon&s=25 Marc (Guest)
on 2010-11-06 06:58
(Received via mailing list)
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
This topic is locked and can not be replied to.