Multisite extension


#1

And again - hi there !

following this routine result in

Processing SitesController#index (for 87.158.175.28 at 2009-04-21
05:47:50) [GET]
Session ID:
BAh7CToOcmV0dXJuX3RvMDoMY3NyZl9pZCIlMWY2NjJhNjMzYTgxN2Y2MDlm
ZDNkZGQyYjZkNjFiOGMiDHVzZXJfaWRpBiIKZmxhc2hJQzonQWN0aW9uQ29u
dHJvbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==–145849f0397ba8ad35ab01195a15e6fdc0af8beb
Parameters: {“action”=>“index”, “controller”=>“sites”}

ActiveRecord::StatementInvalid (SQLite3::SQLException: no such table:
sites: SELECT * FROM “sites” ORDER BY position ASC):
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:147:in
log' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:inexecute’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:372:in
catch_schema_changes' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:inexecute’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:275:in
select' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:inselect_all_without_query_cache’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in
select_all' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:80:incache_sql’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:59:in
select_all' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/base.rb:586:infind_by_sql’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/base.rb:1345:in
find_every' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/base.rb:540:infind_without_order’
(eval):9:in find' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/base.rb:560:inall’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/app/controllers/admin/resource_controller.rb:120:in
load_models' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/../../activesupport/lib/active_support/callbacks.rb:173:insend’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/…/…/activesupport/lib/active_support/callbacks.rb:173:in
evaluate_method' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/../../activesupport/lib/active_support/callbacks.rb:161:incall’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/filters.rb:191:in
call' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/filters.rb:591:inrun_before_filters’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/filters.rb:577:in
call_filters' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/filters.rb:572:inperform_action_without_benchmark’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
perform_action_without_rescue' /usr/local/lib/ruby/1.8/benchmark.rb:293:inmeasure’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
perform_action_without_rescue' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/rescue.rb:201:inperform_action_without_caching’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:in
perform_action' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:33:incache’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in
cache' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:inperform_action’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/base.rb:529:in
send' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/base.rb:529:inprocess_without_filters’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/filters.rb:568:in
process_without_session_management_support' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/session_management.rb:130:insass_old_process’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/plugins/haml/lib/sass/plugin/rails.rb:19:in
process' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/base.rb:389:inprocess’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:149:in
handle_request' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:107:indispatch’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:in
synchronize' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:104:indispatch’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:120:in
dispatch_cgi' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.7.1/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:35:indispatch’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel/rails.rb:76:in
process' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/rails.rb:74:insynchronize’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel/rails.rb:74:in
process' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:159:inprocess_client’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel.rb:158:in
each' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:158:inprocess_client’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel.rb:285:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:ininitialize’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel.rb:285:in
new' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:285:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel.rb:268:in
initialize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel.rb:268:innew’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel.rb:268:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/configurator.rb:282:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/…/lib/mongrel/configurator.rb:281:in
each' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/configurator.rb:281:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:128:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/../lib/mongrel/command.rb:212:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.1.5/bin/mongrel_rails:281
/usr/local/bin/mongrel_rails:19:in `load’
/usr/local/bin/mongrel_rails:19

Rendering /var/pr/public/500.html (500 Internal Server Error)

For my part - I must confess extending Radiant is still more a curse
than a blessing - …


#2

SQLite3::SQLException: no such table:
sites: SELECT * FROM “sites” ORDER BY position ASC

makes me think the db migration was not run? Did u run it, and if so,
was it on the correct environment? ie production / development etc