# SQLite3 exception after upgrade to 0.6.4 **URL:** \ **Category:** Radiant CMS\ **Created:** [December 21, 2007, 3:55pm UTC](https://www.ruby-forum.com/t/sqlite3-exception-after-upgrade-to-0-6-4/123869 "2007-12-21T15:55:35Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![chrisbotor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f14d63/32.png) [@chrisbotor](https://www.ruby-forum.com/u/chrisbotor)\ **Post date:** [December 21, 2007, 3:55pm UTC](https://www.ruby-forum.com/t/sqlite3-exception-after-upgrade-to-0-6-4/123869/1 "2007-12-21T15:55:35Z")
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 3. Run the update rake task: 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:in`initialize’ /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:in`prepare’ /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:in`table\_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:in`columns’ /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:in`column\_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:in`all\_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:in`each’ /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:in`all\_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:in`live?’ /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:in`send’ /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:in`call\_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:in`perform\_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:in`perform\_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:in`send’ /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:in`process\_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:in`process’ /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:in`process’ /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:in`process’ /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:in`each’ /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:in`run’ /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:in`new’ /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:in`initialize’ /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:in`run’ /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:in`each’ /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:in`run’ /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:in`load’ /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:in`new\_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:in`gem\_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:in`require’ /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:in`require’ /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:in`require’ script/server:3 ---
**Author:** ![chrisbotor](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f14d63/32.png) [@chrisbotor](https://www.ruby-forum.com/u/chrisbotor)\ **Post date:** [December 21, 2007, 4:16pm UTC](https://www.ruby-forum.com/t/sqlite3-exception-after-upgrade-to-0-6-4/123869/2 "2007-12-21T16:16:07Z")
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](http://www.edalytical.com/articles/2007/05/27/rails-migrations-using-sqlite3-on-mac-os-x) On 12/21/07, Christian B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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](http://Warmlyyours.com), inc. Phone: (800) 875-5285 ext.800 Fax: (847) 550-2600 Email: removed\_email\_address@domain.invalid WarmlyYours Honeywell authorized licensee 2 Corporate Dr., Suite 100 Long Grove, Illinois 60047 Visit the WarmlyYours website at: [www.warmlyyours.com](http://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.