ActiveRecord::StatementInvalid with Production ENV

rubyonrails-talk
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,

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 !

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