Syntax errors on Heroku, but not on local server (postgresql related?)
- by Phil_Ken_Sebben
I'm trying to deploy my first app on Heroku (rails 3). It works fine on my local server, but when I pushed it to Heroku and ran it, it crashes, giving a number of syntax errors. These are related to a collection of scopes I use like the one below:
scope :scored, lambda { |score = nil|
score.nil? ? {} : where('products.votes_count >= ?', score)
}
it produces errors of this form:
"syntax error, unexpected '=', expecting '|' "
"syntax error, unexpected '}', expecting kEND"
Why is this syntax making Heroku choke and how can I correct it? Thanks!
EDIT: I was using sqlite on my local machine and Heroku does not support that. Trying to make sure the db is properly configured for PG. I believe I have done that by specifying in the gemfile that sqlite only be used in development. Yet I still get these syntax errors, that interrupt even the db:migrate.
EDIT: So now it seems more likely that my scope syntax doesn't work in postgreSQL. Does anyone know how to convert this properly?