Rails - Nov 2006 - ActiveRecord::StatementInvalid with Production ENV

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


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Hi,

2006/11/30, Bolo <malavoi@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/

--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

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


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

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.


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Yes working righ now

Tks


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---