Rails - Mar 2005 - Invalid argument in find_by_sql

I''m getting an error in Rails, but only under FastCGI w/Apache --
doesn''t happen in script/console or script/server. The error is:

Invalid argument: SELECT patients.*, accounts.first_name,
accounts.last_name FROM patients, accounts WHERE patients.account_id accounts.id
ORDER BY last_name, first_name

That statement is perfectly legal -- executes just fine directly
against MySQL, and again works just fine under WEBRick and
script/console. Some Googling seems to indicate that this is a
password issue (or at least people got this during the upgrade form
old to new password approaches for MySQL). I saw one user who reported
this problem with FastCGI, but go no responses to his query.

Any ideas?

Thanks,
Arien

On Mar 28, 2005 9:04 PM, Arien Malec
<arien.malec-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> I''m getting an error in Rails, but only under FastCGI w/Apache --
> doesn''t happen in script/console or script/server. The error is:
> 
> Invalid argument: SELECT patients.*, accounts.first_name,
> accounts.last_name FROM patients, accounts WHERE patients.account_id >
accounts.id ORDER BY last_name, first_name
It looks like this is related to moving between networks
(suspend/resume into a different network). Apache/FastCGI/Ruby wants
to be restarted to hit MySQL.

Arien