ActiveRecord::StatementInvalid with Production ENV

[Bolo]

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 :(

I don't really understand where is the problem

Thanks You

[Francois Beausoleil]

Hi,

2006/11/30, Bolo <mal...@gmail.com>:

> 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/

[Bolo]

Hello Francois,

> t would help if you posted more of the error message.

Full message. http://pastie.caboo.se/25729

> 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

[Timothy....@gmail.com]

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.

[Bolo]

Yes working righ now

Tks