similar to: Windows "Lost connection to MySQL server during query"

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

So, install Ruby and gem and then read the wiki post about getting MySQL working and installed that mysql.so into the right dirs, and actually everything works fine. Except that it''s unstable - after maybe 4 or 5 queries, Webrick will crash with a segmentation fault in basically a random module - never the same spot. Anyone got any suggestions? Is it just the mysql.so - does it need to

Hi I would like to write my first application with Active Record: this is my database table: id PRIMAREY KEY auto_increment german_name varchar(50) english_name varchar(50) | wingspan this is my code: ======================= #!/usr/local/bin/ruby -w require ''rubygems'' require_gem ''activerecord'', ">= 1.10.1"

Hi - I am trying to use eager associations to cut down on database queries. I have a feeds table, an items table, a categories table, and a categories_items table. feeds have items, and items have many categories (and categories can be assigned to many items), thus the categories_items table which is a many-many join table. I do @feed = Feed.find(1) which works fine, but now I want to use

I''m running Ruby on Rails on Fedora Core 4 with lighttpd and fastcgi. I also used the login generator (don''t know if relevant). I have the following problem: At day time I work on the server and create/modify ruby files on the server, all pages work fine. Than the next day I want to open de server I get the error at the end of this message (on all pages, including non protected).

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; +----------+ |

I''ve been using Rails for more than six months and until today I had no problem with mysql connection. It''s a Mac OS X 10.4 box having rails installed and updated by gem. I use a remote mysql server no local instance installed. Here''s my config: development: adapter: mysql database: hdchat host: 10.0.0.1 username: webuser password: test: adapter:

i hope its minor, i''m running lighty1.4x ruby 1.8x mysql 5.0.1x and i can see my rails app on 127.0.0.1:3000 but if i try run a app with database connection (scaffold) i get this error NameError in Message#index uninitialized constant Mysql RAILS_ROOT: ./config/.. Application Trace | Framework Trace | Full Trace

I''m trying to set up RoR on a laptop and having all sorts of troubles. I''m running XP SP2, I did a quick install of appache/mysql using Xampp, which worked fine. I grabbed the latest windows install of ruby and rails, installed it ok and got it running. The moment I try to run a rails page that queries a database, it fails every time, and I get the following error:

hi. i''ve an application which is using a local mysql server (on localhost). i then moved the mysql server to another machine (remote host) and changed accordingly the "database.yml" file. when i launch webrick from the "localhost", it can connect to the database but as soon as i call a controller of the application (for example

Hi! I have a little problem with 0.14.3. I followed the http://wiki.rubyonrails.com/rails/pages/HowtoUseSymLinksToGraftRailsOntoYourWebsite but it''s not work. My rails directory is /home/boci/ujautoszalon and I symlinked the public dir to /home/httpd/htdocs/ujautoszalon2, but it''s not find the database.yml file. Here is the whole log:

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

OK, I''m diving into new things - a .net programmer and windows user trying to develop in Rails on my Mac. Initial setup was easy, and I had things working and was thrilled with myself. Then I shut down. Next time I booted up, mysql was acting all kinds of funny. I finally got that working again (I *think* it mostly had to do with me not having the right path, I unfortunately

Hi, I''m totally new to Ruby and Rails and I''m trying to set up a prototype web site. Unfortunately, I''m having problems with ActiveRecord using multiple threads. What I want to do is fairly simple. I have a Controller that receives and saves data from the web in the DB, but once that''s done I want to process this data in another thread and then save the

Most likely due to something I misconfigured and/or broke when trying to get the new polymorphic acts_as_taggable to work...In short, after installing that gem and then trying to run gem install mysql on my windows server, I''ve been getting this weird error on every page I try to hit. If anyone give give me any insight into how I messed this up or how to fix, it would be much

I set my app on the Rails edge yesterday via rake freeze_edge and that broke my app. If I take the ..\vendor\rails folder out and restart the server (webrick), it works fine. I don''t get any errors. But if I re-add the ..\vendor\rails folder I get errors when accessing any views that have pagination. Is this a known issue or problem? This is the error: ActiveRecord::StatementInvalid in

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

Trying to get Rails and mysql running on OS X, and I''m a Nuby. Everything ran smoothly when I first installed, but after rebooting things were out of whack. I finally got back into mysql after re-installing, and at first when I tried to connect with Rails/Ruby I got a message that my client was not up to date. So after reading some info online, I set my mysql passwords with

Hi everybody, I''ve been reading lot of material about Ruby on Rails, and it looks like really rocks. I''ve downloaded the one-click version for Windows and started to build the example cookbook app, found in: http://www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html?page=1 Everything looks good, but when I''m trying to create a new Recipe

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