trouble switching from sqlite to mysql
October 28th, 2008
UPDATE 9/3/2009
So you’re happily rake test ing the shit out of your app, and see nothing but dots.. Then cap deploy and you see nothing.. at all!
Why you ask? I’ll tell ya.
Using Rails 2.1.0 on my dev box, I ran sqlite as dev and test db. All was fine and happy.
Then deployed (to mysql) and all hell broke loose. Looks like Mysql doesnt like lines such as
named_scope :exclude, lambda {|id| { :conditions => ['id <> ?', id] } }
Instead, it prefers
named_scope :exclude, lambda {|id| { :conditions => ['`services`.id <> ?', id] } }
weird huh?
Sorry, comments are closed for this article.