SQLite3 exception after upgrade to 0.6.4

Ruby Apps Radiant CMS
1

Hi everyone,
I have a Radiant 0.6.3 site which I am trying to update to 0.6.4

I followed these instructions:

  1. gem update radiant

  2. Change the RADIANT_GEM_VERSION constant in config/environment.rb

    to “0.6.4”.

  3. Run the update rake task:

    rake radiant:update

When I start the site and try to access it, I get a

SQLite3::SQLException in SiteController#show_page

unsupported file format

Here’s the full trace. Can anyone help?

Thank you

Christian

Processing SiteController#show_page (for 127.0.0.1 at 2007-12-21
08:49:46)
[GET]
Parameters: {“action”=>“show_page”, “url”=>"/", “controller”=>“site”}

SQLite3::SQLException (unsupported file format):
/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/errors.rb:94:in
check' /usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/statement.rb:71:ininitialize’
/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:184:in
new' /usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:184:inprepare’
/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:232:in
execute2' /usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/pragmas.rb:249:intable_info’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:359:in
table_structure' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:210:incolumns’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:763:in
columns' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:776:incolumn_names’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:789:in
column_methods_hash' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1265:inall_attributes_exists?’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1012:in
all?' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1265:ineach’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1265:in
all?' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1265:inall_attributes_exists?’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:1199:in
method_missing' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/app/models/radiant/config.rb:34:in[]’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/app/controllers/site_controller.rb:49:in
dev?' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/app/controllers/site_controller.rb:57:inlive?’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/app/controllers/site_controller.rb:16:in
show_page' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:1101:insend’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:1101:in
perform_action_without_filters' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/filters.rb:696:incall_filters’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/filters.rb:688:in
perform_action_without_benchmark' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:inperform_action_without_rescue’
/usr/local/lib/ruby/1.8/benchmark.rb:293:in measure' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:inperform_action_without_rescue’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in
perform_action' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:435:insend’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:435:in
process_without_filters' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/filters.rb:684:inprocess_without_session_management_support’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in
process' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:334:inprocess’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/railties/lib/dispatcher.rb:41:in
dispatch' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:78:inprocess’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:in
synchronize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:inprocess’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:618:in
process_client' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:ineach’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in
process_client' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in
initialize' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:innew’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:ininitialize’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in
new' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:271:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:ineach’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:127:inrun’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb:211:in
run' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:243 /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:inload’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
load' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:342:innew_constants_in’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
load' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4 /vendor/rails/railties/lib/commands/servers/mongrel.rb:60 /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
require' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:inrequire’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
new_constants_in' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:inrequire’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4
/vendor/rails/railties/lib/commands/server.rb:39
/usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:inrequire’
script/server:3

2

Well I answered my own question, sqlite3-ruby on mac os X needs special
attention.
Following this article did fix it.

http://www.edalytical.com/articles/2007/05/27/rails-migrations-using-sqlite3-on-mac-os-x

On 12/21/07, Christian B. [email protected] wrote:

  1. gem update radiant
    When I start the site and try to access it, I get a

execute2' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activerecord/lib/active_record/base.rb:789:in all_attributes_exists?’
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/base.rb:1101:in
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
process' /usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:618:in new’
/usr/local/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in
/usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.4/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
require' /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in require’
script/server:3

–
Christian B.
Director of IT
Warmlyyours.com, inc.

Phone: (800) 875-5285 ext.800
Fax: (847) 550-2600
Email: [email protected]

WarmlyYours
Honeywell authorized licensee
2 Corporate Dr., Suite 100
Long Grove, Illinois 60047

Visit the WarmlyYours website at: www.warmlyyours.com

24/7 Installation Support • Lifetime Technical Assistance • Free Design
Service
This email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they are
addressed.
If you have received this email in error please notify the system
manager.
Please note that any views or opinions presented in this email are
solely
those of the author and do not necessarily represent those of the
company.