mysql5 5.0.24 upgrade note for macports users

hi list -

just a quick note to anyone using macports (nee darwinports) and mysql5 with their rails apps. yesterady i upgraded my macports system then my mysql5 install from 5.0.22 to 5.0.24. everything compiled and installed without issue, but my rails applications (1.1.6) seemed rather unhappy. generally the first access would succeed but subsequent would error out (more details below) with 'NoMethodError (undefined method `each' for #<Mysql:0x2703e0c>):'. my workaround was to uninstall rb-mysql5, clean and reinstall it - and now of course it seems kosher. perhaps this is expected but i thought i'd mention it in case it could save someone else a few minutes.   % sudo port uninstall rb-mysql5 && sudo port clean rb-mysql5 && sudo port install rb-mysql5

regards, jean-pierre

Processing CategoriesController#index (for a.b.c.d at 2006-08-25 13:44:32) [GET]   Session ID: ff27b2a706aa2be30e184f4ee3693403   Parameters: {"action"=>"index", "controller"=>"admin/categories"}   e[4;35;1mCategory Columns (0.054524)e[0m e[0mSHOW FIELDS FROM categoriese[0m

NoMethodError (undefined method `each' for #<Mysql:0x2703e0c>):     /vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:292:in `columns'     /vendor/rails/activerecord/lib/active_record/base.rb:696:in `columns'     /vendor/rails/activerecord/lib/active_record/calculations.rb:216:in `column_for'     /vendor/rails/activerecord/lib/active_record/calculations.rb:138:in `calculate'     /vendor/rails/activerecord/lib/active_record/calculations.rb:66:in `count'     /vendor/rails/actionpack/lib/action_controller/pagination.rb:172:in `count_collection_for_pagination'     /vendor/rails/actionpack/lib/action_controller/pagination.rb:196:in `paginator_and_collection_for'     /vendor/rails/actionpack/lib/action_controller/pagination.rb:129:in `paginate'     /app/controllers/admin/categories_controller.rb:14:in `list'     /app/controllers/admin/categories_controller.rb:5:in `index'     /vendor/rails/actionpack/lib/action_controller/base.rb:941:in `perform_action_without_filters'     /vendor/rails/actionpack/lib/action_controller/filters.rb:368:in `perform_action_without_benchmark'     /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'     /opt/local/lib/ruby/1.8/benchmark.rb:293:in `measure'     /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'     /vendor/rails/actionpack/lib/action_controller/rescue.rb:82:in `perform_action'     /vendor/rails/actionpack/lib/action_controller/base.rb:408:in `process_without_filters'     /vendor/rails/actionpack/lib/action_controller/filters.rb:377:in `process_without_session_management_support'     /vendor/rails/actionpack/lib/action_controller/session_management.rb:117:in `process'     /vendor/rails/railties/lib/dispatcher.rb:38:in `dispatch'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel/rails.rb:73:in `process'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:551:in `process_client'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:550:in `process_client'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:636:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:636:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:625:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:956:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel.rb:955:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/bin/mongrel_rails:127:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/mongrel/command.rb:199:in `run'     /opt/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/bin/mongrel_rails:235     /opt/local/bin/mongrel_rails:18

Rendering /path/../vendor/rails/actionpack/lib/action_controller/templates/rescues/layout.rhtml (500 Internal Error)