ActiveRecord::StatementInvalid with Production ENV

Rails
1

Hello,

I was deploying my application on my server ,when i test my application
http://www.expay.uag-histoire.com/faq_categories i can see this error

ActiveRecord::StatementInvalid in Faq categoriesController#index

ActiveRecord::StatementInvalid

Perhaps in my dev environement i don’t have this problem :frowning:

I don’t really understand where is the problem

Thanks You

2

Hi,

2006/11/30, Bolo [email protected]:

I was deploying my application on my server ,when i test my application
http://www.expay.uag-histoire.com/faq_categories i can see this error

ActiveRecord::StatementInvalid in Faq categoriesController#index

ActiveRecord::StatementInvalid

It would help if you posted more of the error message. Nonetheless, I
have had similar problems since upgrading an app to 1.2RC1. My
problem was a difference in the MySQL server version between my
development environment vs my production environment. I was using
4.0.12 in dev, and 5.0.24 in production.

Once I had the same version on dev and production, I could investigate
the errors, correct them, and deploy anew.

Hope that helps !

François Beausoleil
http://blog.teksol.info/
http://piston.rubyforge.org/

3

Hello Francois,

t would help if you posted more of the error message.
Full message. Parked at Loopia

have had similar problems since upgrading an app to 1.2RC1.
Me too

Me i use Sqlite3 for production and dev environement. Do you find a
solution

4

For reference, the problem Bolo was having is detailed
http://forums.planetargon.com/forums/3/topics/40?page=1#posts-107

Basically, rake migrate wasn’t working quite the way he expected it to,
so none of his tables existed.

5

Yes working righ now

Tks