Topic: fixing 500 internal server

Hi all,
         my application shows up the '500 Internal Server Error'  and some times '' Mysql::Error: Lost connection to MySQL server during query: SELECT * FROM `companies`''  how would i go to fix it.

Re: fixing 500 internal server

How are you hosting your application?  Apache/nginx? mongrel/thin/passenger?  Is mysql on the same machine?  How large is the data contained in the companies table, could it be timing out?

Re: fixing 500 internal server

am using mongrel , mysql is on the same machine my companies table has got 32 columns with 1600 active records . is this a time out issue  else other find me the way.

Re: fixing 500 internal server

A lot of good suggestions in this thread - http://www.ruby-forum.com/topic/57780

What OS is it hosted on?

Re: fixing 500 internal server

If you go to your script/console and run

@companies = Company.find(:all)

do you get the result??

Re: fixing 500 internal server

pullmonkey wrote:

A lot of good suggestions in this thread - http://www.ruby-forum.com/topic/57780

What OS is it hosted on?

am on Ubuntu 8.04

Re: fixing 500 internal server

BrazilianMan wrote:

If you go to your script/console and run

@companies = Company.find(:all)

do you get the result??

Company.find(:all) do fetch me all the records form Companys table . The problem is not only with the Company table but exists with other tables too.