similar to: Invalid Statements using FastCGI w/ WinXP

Howdy, I have a model I called ''content_series''. I created it and noticed that Rails called it ''Sery'', so I added ''series'' to the uncountable thing in the config, like this: Inflector.inflections do |inflect| # inflect.plural /^(ox)$/i, ''\1en'' # inflect.singular /^(ox)en/i, ''\1'' #

Hi, I''m having a bit of a problem with a rails app and I wonder if anyone can help. It seems to run fine for a while, but if it''s left running too long (left running as a fastcgi or webrick process that is) it starts failing with an "ActiveRecord::StatementInvalid" error (i''ve included the full error from the log file below). I''m seeing this on both

Hi Everyone - I have a rails 0.10.1 application deployed on a Windows 2003 server under XAMPP Lite 1.4.12. Running under CGI, the application works fine (a bit slow, obviously, but no problems). When I run under FastCGI, the app is fine until I leave it alone for a few hours. For example, last night I switched it to FastCGI and everything seemed to be working fine. When I woke up this

I am still trying to get sentry working to encrypt a couple of attributes in the model. One of them is a password field and the other ssn#. I have crypted_password and crypted_ssn in the db. In addition, I also have validates_uniqueness_of :ssn Here is the problem... I get the error MysqlError: Unknown column ''ssn'' in ''where clause'': SELECT * FROM students

Hello, Does anyone see the following error? Is it possible that it has something to do with the connection maintained by active record timing out? /usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in `log'': Mysql::Error: MySQL server has gone away: SELECT * FROM toys WHERE (toys.id = 28) LIMIT 1

I''ve encountered a perplexing problem whilst following along the demo app in the "Agile Web Development with Rails" book. Any help would be greatly appreciated. Here is a brief time line of my tale of woe:- 0. Been programming (business apps) and designing/building DBs for two decades - but new to both Ruby and Rails (so I apologise in advance if I''ve made some

Since we upgraded to Rails 1.0 and lighty last week we''ve had the rails application crash daily with the following error in the production.log file: Errno::EPIPE (Broken pipe): /usr/local/lib/ruby/1.8/mysql.rb:1042:in `flush'' /usr/local/lib/ruby/1.8/mysql.rb:1042:in `write'' /usr/local/lib/ruby/1.8/mysql.rb:462:in `write''

I just checked out the latest sqlserver_adapter.rb from the SVN repository, and it seems to work fine. -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org [mailto:rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org] On Behalf Of Neville Burnell Sent: Thursday, 24 March 2005 2:25 PM To:

"bitsweat" has kicked AR/Oracle while it was down... http://dev.rubyonrails.org/changeset/7769 ------------------------------------------------------------------------ r7769 | bitsweat | 2007-10-06 22:29:37 -0700 (Sat, 06 Oct 2007) | 1 line MySQL: speedup date/time parsing. ------------------------------------------------------------------------ U

I have run into a very strange problem discovered through the use of the acts_as_taggable plugin, but related to quoting/sanitizing the interpolated list in a find_by_sql. Apologies for the length, but I wanted to be complete. ;-) The method from acts_as_taggable.rb is: def find_tagged_with(list) find_by_sql(["SELECT #{table_name}.* FROM #{table_name}, tags,

I am getting random can''t connect to MySQL server errors on my Rails application located at http://www.thedatingguy.com/blog Do you have any clue why this is happening? This is the error: Mysql::Error (Can''t connect to local MySQL server through socket ''/tmp/mysql.sock'' (61)):

Folks, I am using ruby 1.8.5 with rails 1.2.3 and have made changes to mysql_adapter.rb based on recommendations made here http://wiki.rubyonrails.org/rails/pages/StoredProceduresInMySql to be able to use stored procs in my code. I have changed this call in mysql_adapter.rb ConnectionAdapters::MysqlAdapter.new(mysql, logger, [host, username, password, database, port, socket], config) to

Sorry to post twice in a row, but I also wanted help with my index rebuild process - I seem to be getting timeouts when I run the rebuild_index.rb script, like this: /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in `log'': Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM search_queries

Hi, I have an application that is running fine on two different machines, but when I ported the code to a third machine, it doesn''t seem to work. More specifically, for users with a significant amount of info, it seems to stop working. All the functionality seems to be working properly on a small test set, but with a larger set I get the following error: AssociatedAp Load (0.000000)

hello can anybody help me with this bug, (this sometimes occur sometimes passes) 1) ActiveRecord::StatementInvalid in ''MailReader on Simple Tasks should not accept duplicate email'' Mysql::Error: MySQL server has gone away: ROLLBACK TO SAVEPOINT active_record_1 /home/poldz/.gem/ruby/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in

Hi (I''m resubmitting this because First question: This is the rails dev list, correct? I''d like to submit a patch and am following the steps on this page: http://dev.rubyonrails.org/ Here''s what I did (using mysql 5.0.15-nt): created 2 databases: activerecord_unittest activerecord_unittest2 created 1 user: rails (giving all priveleges to both databases) ran

This error has been driving me nuts. It happens with no regularity or pattern and causes a 500 App error. Refreshing will always display as normal (http 200) The back trace always starts with TypeError (can''t convert Bignum into Hash): /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:342:in `update''

has_many.count does not seem to support an options hash like ActiveRecord::Base.count does. Example: >> AcademicProgram.find(:first).course_requirements.count :conditions => "courses.name LIKE ''a%''", :include => :course => 40 >> ap.ap_requirements.count :conditions => "courses.name LIKE ''a%''", :include =>

I am using authlogic for authentication in rails 3.0.3 with ruby 1.9.2 Using activerecord-sqlserver-adapter (3.0.5) windows with sqlserver database when i create user details in rails console, i am getting below error, >User.create(:login=>''test'',:password=>''test123'',:password_confirmation=>''test123'')

I am not sure when it exactly occurred but I have 2 servers I am about to migrate to apache+mongrel from lighty+fastcgi oddly, both my servers seemed to have died at the same time everytime I restart within a 24 hr period ( I don''t know when, my logs don''t show it ). Can someone please point me in the direction of what I need to do to trace the cause of this. Or what you would