I was using the one built into rails. I installed the one via gem install and my blog is working again
Thanks Scott & Steve. On 12/07/2006, at 2:41 PM, Scott Laird wrote: > Which MySQL driver are you using? The one built into Rails or the > .gem one? Try swapping for the other one. > > > Scott > > On 7/11/06, Ian Holsman <[EMAIL PROTECTED]> wrote: >> >> ok.. I added it, >> but I still have the same problem. >> I don't think it is a timeout issue, as it happens straight after >> I launch >> mongrel (or WEBBrick). >> i'm thinking its a SQL issue. >> >> >> On 12/07/2006, at 2:09 PM, Steve Longdo wrote: >> I would guess in the environment.rb, add the line above: >> ActionMailer::Base.default_charset = 'utf-8' >> >> Actually anywhere you put it in there it should get picked up. >> You might >> cross check with the mongrel mailing list to see what they recommend. >> >> -Steve >> http://www.stevelongdo.com >> >> On 7/11/06, Ian Holsman <[EMAIL PROTECTED] > wrote: >>> >>> >>> nope. >>> where do I put that ? >>> >>> >>> >>> >>> On 12/07/2006, at 1:21 PM, Steve Longdo wrote: >>> >>> Do you have ActiveRecord MySQL timeout setup for mongrel? >>> >>> http://mongrel.rubyforge.org/faq.html >>> >>> From the FAQ: >>> >>> Q: Mongrel stops working if it's left alone for a long time. >>> >>> If you find that Mongrel stops working after a long idle time and >>> you're >> using MySQL then you're hitting a bug in the MySQL driver that >> doesn't >> properly timeout connections. What happens is the MySQL server >> side of the >> connection times out and closes, but the MySQL client doesn't >> detect this >> and just sits there. >>> >>> What you have to do is set: ActiveRecord::Base.verification_timeout >>> = 14400 >>> >>> >>> Or to any value that is lower than the MySQL server's >>> interactive_timeout >> setting. This will make sure that ActiveRecord checks the >> connection often >> enough to reset the connection. >>> >>> >>> On 7/11/06, Ian Holsman <[EMAIL PROTECTED] > wrote: >>>> Hi guys. >>>> I'm on the latest SVN trunk (1123) and using mysql 5.0.19 . >>>> >>>> I'm not sure what is going on.. as I just moved hosting >>>> providers and >>>> not if it is that or typo. >>>> >>>> regards >>>> Ian >>>> >>>> ActiveRecord::StatementInvalid (Mysql::Error: Lost connection to >>>> MySQL server during query: UPDATE sessions SET `sessid` = >>>> '6b08673361b2d7cd5780f3593d3e592a', `data` = >>>> >> 'BAh7CDoOcmV0dXJuX3RvMDoJdXNlcm86CVVzZXIGOhBAYXR0cmlidXRlc3sQ >>>> >> \nIhZub3RpZnlfdmlhX2phYmJlciIGMCIJbmFtZSIQSWFuIEhvbHNtYW4iHW5v >>>> >> \ndGlmeV93YXRjaF9teV9hcnRpY2xlczAiFW5vdGlmeV92aWFfZW1haWwiBjAi >>>> >> \nB2lkIgYyIgtqYWJiZXIiFmtyeXRvbkBqYWJiZXIub3JnIhdub3RpZnlfb25f >>>> >> \nY29tbWVudHMiBjAiDXBhc3N3b3JkIi1hYTU5ZjMzMTUwZTRmMzhkMjM5ZDE0 >>>> >> \nY2MwNjA4NzRmNWE2ZWI3NDQ3Igpsb2dpbiIJaWFuaCIbbm90aWZ5X29uX25l >>>> >> \nd19hcnRpY2xlcyIGMCIKZW1haWwiACIKZmxhc2hJQzonQWN0aW9uQ29udHJv >>>> \nbGxlcjo6Rmxhc2g6OkZsYXNoSGFzaHsABjoKQHVzZWR7AA==\n', >> `updated_at` = >>>> '2006-07-11 21:35:40' WHERE id = 64708): >>>> >> /vendor/rails/activerecord/lib/active_record/connection_adapters/ >>>> abstract_adapter.rb:120:in `log' >>>> >> /vendor/rails/activerecord/lib/active_record/connection_adapters/ >>>> mysql_adapter.rb:184:in `execute' >>>> >> /vendor/rails/activerecord/lib/active_record/connection_adapters/ >>>> mysql_adapter.rb:199:in `update' >>>> >> /vendor/rails/activerecord/lib/active_record/base.rb:1723:in >>>> `update_without_lock' >>>> >> /vendor/rails/activerecord/lib/active_record/locking.rb:33:in >>>> `update_without_callbacks' >>>> >> /vendor/rails/activerecord/lib/active_record/callbacks.rb:274:in >>>> `update_without_timestamps' >>>> >> /vendor/rails/activerecord/lib/active_record/timestamp.rb:39:in >>>> `update' >>>> >> /vendor/rails/activerecord/lib/active_record/base.rb:1718:in >>>> `create_or_update_without_callbacks' >>>> >> /vendor/rails/activerecord/lib/active_record/callbacks.rb:249:in >>>> `create_or_update' >>>> >> /vendor/rails/activerecord/lib/active_record/base.rb:1392:in >>>> `save_without_validation' >>>> >> /vendor/rails/activerecord/lib/active_record/validations.rb: >>>> 724:in `save_without_transactions' >>>> >> /vendor/rails/activerecord/lib/active_record/transactions.rb: >>>> 126:in `save' >>>> >> /vendor/rails/activerecord/lib/active_record/connection_adapters/ >>>> abstract/database_statements.rb:51:in `transaction' >>>> >> /vendor/rails/activerecord/lib/active_record/transactions.rb: >>>> 91:in `transaction' >>>> >> /vendor/rails/activerecord/lib/active_record/transactions.rb: >>>> 118:in `transaction' >>>> >> /vendor/rails/activerecord/lib/active_record/transactions.rb: >>>> 126:in `save' >>>> >> /vendor/rails/actionpack/lib/action_controller/session/ >>>> active_record_store.rb:307:in `update' >>>> >> /vendor/rails/activerecord/lib/active_record/base.rb:794:in >>>> `silence' >>>> >> /vendor/rails/actionpack/lib/action_controller/session/ >>>> active_record_store.rb:307:in `update' >>>> >> /vendor/rails/actionpack/lib/action_controller/session/ >>>> active_record_store.rb:314:in `close' >>>> /usr/local/lib/ruby/1.8/cgi/session.rb:330:in >> `close' >>>> >> /vendor/rails/actionpack/lib/action_controller/base.rb:984:in >>>> `close_session' >>>> >> /vendor/rails/actionpack/lib/action_controller/base.rb:1026:in >>>> `process_cleanup_without_flash' >>>> >> /vendor/rails/actionpack/lib/action_controller/flash.rb:147:in >>>> `process_cleanup_without_filters' >>>> >> /vendor/rails/actionpack/lib/action_controller/filters.rb:439:in >>>> `process_cleanup_without_session_management_support' >>>> /vendor/rails/actionpack/lib/action_controller/ >>>> session_management.rb:126:in >> `process_cleanup_without_components' >>>> >> /vendor/rails/actionpack/lib/action_controller/components.rb: >>>> 182:in `process_cleanup' >>>> >> /vendor/rails/actionpack/lib/action_controller/base.rb:385: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' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/mongrel/ >>>> rails.rb:73:in `process' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/ >>>> mongrel.rb:551:in `process_client' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/ >>>> mongrel.rb:550:in `process_client' >>>> >> /usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/ >>>> mongrel.rb :636:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/ >>>> mongrel.rb:636:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/ >>>> mongrel.rb:625:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/ >>>> mongrel.rb:956:in `run' >>>> >> /usr/local/lib/ruby/gems/1.8/gems/mongrel-0.3.13.3/lib/ >>>> mongrel.rb :955:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/bin/ >>>> mongrel_rails:127:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/lib/mongrel/ >>>> command.rb:199:in `run' >>>> /usr/local/lib/ruby/gems/1.8/gems/mongrel- >> 0.3.13.3/bin/ >>>> mongrel_rails:235 >>>> /usr/local/bin/mongrel_rails:18 >>>> >>>> _______________________________________________ >>>> Typo-list mailing list >>>> [email protected] >>>> http://rubyforge.org/mailman/listinfo/typo-list >>>> >>> >>> >>> _______________________________________________ >>> Typo-list mailing list >>> [email protected] >>> http://rubyforge.org/mailman/listinfo/typo-list >>> >>> >>> _______________________________________________ >>> Typo-list mailing list >>> [email protected] >>> http://rubyforge.org/mailman/listinfo/typo-list >>> >>> >> >> _______________________________________________ >> Typo-list mailing list >> [email protected] >> http://rubyforge.org/mailman/listinfo/typo-list >> >> _______________________________________________ >> Typo-list mailing list >> [email protected] >> http://rubyforge.org/mailman/listinfo/typo-list >> >> > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
