similar to: mysql_adapter.rb help please

This is my first rails app with a legacy database and I''m having a terrible time getting the models set up correctly. I have an order table that has a primary field named order_number. I have a name table with a primary of item_number. These two tables are liked by the item_number and the order_number, but not as you might think. If the order_number is 2500, then each entry in

Hi everyone, I have been trying to solve this problem for quite some time now and I really don''t have any further clue to investigate. I am running a mongrel_cluster 1.0.5-2 (mongrel verison : 1.1.5-5) on a ubuntu box with apache2 2.2.12-1ubuntu2.1 I have 4 different apps on the same box and each app has two mongrel instances. After a short period of time ( < 2 hours ) some of the

Hello all! I''m a newbie to Rails and I''m trying to get things working on an old RH9 box. I was wondering if someone could help me troubleshoot a mysql_adapter.rb error? I set everything up and created a simple test app and then generated a scaffold for it. When I try to go to the main controller and list the data, I get the following error: ArgumentError... NULL pointer

Hi, I am having Mysql connection problem for my first AddressBook application (which I took it from http://www-128.ibm.com/developerworks/linux/library/l-rubyrails/) I have gem installed the latest ruby, rails, lighttpd, fastcgi, mysql-4.1.14 on linux. Everything looks good. When I do: mysql -h localhost -u test -ptest -D AddressBook mysql> SELECT COUNT(*) FROM contacts; +----------+ |

Hello there, I am encountering segfaults with following: ruby 1.8.6 (2008-08-11) [i386-mswin32] on windows 7, rails 2.3.2, mysql (2.7.1) gem and MySQL 5.0.87-community-nt-log Tried with MySQL 5.1 and mysql gem 2.8.1 with no luck. Loga are showing: C:\Users\Alex\Documents\IT\ruote-web2>ruby script\server --port=3333 => Booting Mongrel => Rails 2.3.2 application starting on

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'' #

I get the following mysql error when I try to connect to my Linux machine using putty. Unknown database ''db_develoment'' (Mysql::Error) any idea what i need to do to avoid this. The same code works pefectly well on the Linux box. /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/ven?dor/mysql.rb:508:i n `read'': Unknown database

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 =>

When calling a Result.find_by_content on my model, I get the following error: Mysql::Error: Table ''db.results'' doesn''t exist: SHOW FIELDS FROM results Yes, I remembered to put acts_as_ferret. Any ideas? Trace:

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

Any news on the Apache Best Practice Deployment instructions? I''m getting ready to set up a production server, and would prefer to use Apache and Mongrel/Cluster. Don''t think I''ll be able to get the latest Apache though. Do I have to proxy through Pound or something to handle multiple mongrel instances? Any pointers? Any help appreciated, Brett

I need a VERY SIMPLE solution to get to my rails app. We have a WHM/Cpanel linux server with numerous virtual servers on it. I have an existing website called www.mydomain.com that lives in /home/mydomain/public_html. I have written a rails app called "test" that is in /home/mydomain/test, and it''s rails "root" is therefore /home/mydomain/test/public. I am an

To all fellow Dreamhosters out there... Sometimes my app mysteriously loses its connection to the database, resulting in a big ugly "Application Error (Rails)" page. Usually refreshing the page makes it go away, but not today. :-( In production.log I see this: MysqlError (Lost connection to MySQL server during query): Any idea why this happens? It''s rather intermittent

Sorry if this has been covered, but I finally decided to upgrade to Rails 2.0 (running Leopard and previously at rails 1.2.6) so I could start using some of the great new features. I ran the usual "sudo gem install rails --include-dependencies" to upgrade and now my development environment is all out of whack. I suspected MySQL, but I''ve already made sure I was using the

Running rails 1.1 and MySQL 5 on Kubuntu. I moved the same rails project from one machine to another. To set up the database I try to run `rake migrate` but I am greeted with the error/stack trace below. Any idea why this could be? It doesn''t seem to be a permissions problem--I can login to the database as my application just fine. I tried downgrading MySQL to v4.1 because that is

I''m three pages into the OnLamp RoR Tutorial [1] and am wrestling with what appears to be a MySQL connection problem. I''ve created a simple controller called "recipe" with a corresponding "recipes" mysql table. The recipe controller is just a simple scaffold. When I browse to "recipe/new", though, I get these errors: == NoMethodError in

I''m getting the following error unexpectedly for my rails app. I just exported the databae from dreamhost and imported it on textdrive for my rails app. Mysql::Error: MySQL client ran out of memory: SELECT COUNT(*) FROM comments WHERE (comments.listing_id = 2666) /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in

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

Hello -- Please pardon my newness -- I''m just getting started with rails, and I''m having some difficulty getting it set up with MySQL. I am able to get the basic ruby server running (script\server). When I created a new page (using script/generate controller about index), I am not able to navigate to the new page, and Ruby either crashes or gives me an error: /!\ FAILSAFE /!\

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