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:incolumns’
/vendor/rails/activerecord/lib/active_record/base.rb:696:in
columns' /vendor/rails/activerecord/lib/active_record/calculations.rb:216:incolumn_for’
/vendor/rails/activerecord/lib/active_record/calculations.rb:138:in
calculate' /vendor/rails/activerecord/lib/active_record/calculations.rb:66:incount’
/vendor/rails/actionpack/lib/action_controller/pagination.rb:172:in
count_collection_for_pagination' /vendor/rails/actionpack/lib/action_controller/pagination.rb:196:inpaginator_and_collection_for’
/vendor/rails/actionpack/lib/action_controller/pagination.rb:129:in
paginate' /app/controllers/admin/categories_controller.rb:14:inlist’
/app/controllers/admin/categories_controller.rb:5:in index' /vendor/rails/actionpack/lib/action_controller/base.rb:941:inperform_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:inperform_action_without_rescue’
/opt/local/lib/ruby/1.8/benchmark.rb:293:in measure' /vendor/rails/actionpack/lib/action_controller/benchmarking.rb:69:inperform_action_without_rescue’
/vendor/rails/actionpack/lib/action_controller/rescue.rb:82:in
perform_action' /vendor/rails/actionpack/lib/action_controller/base.rb:408:inprocess_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:inprocess’
/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:inprocess’
/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:inprocess_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:inrun’
/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:inrun’
/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:inrun’
/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)