Hi, I've been stung when deploying a rails app to heroku, and I'm fairly
confident the problem is the difference between my local db sqlite3, and
the heroku standard free shared db which is postgres(i think).
I have a scope in my model that looks like this
scope :not_archived, :conditions => ['application_state != "archived"']
The idea is I want to get back all the records where the
application_sate value is not equal to the string "archived".
This works fine locally, but in the Heroku logs it throws up the
following error :
ActionView::Template::Error (PG::Error: ERROR: column "archived" does
SELECT COUNT(*) FROM "coach_applications" WHERE
"coach_applications"."user_id" = 10 AND (application_state !=
It's looking for a column archived, which is not what I want.
Essentially what I want is a proper Rails ORM style scope that returns
the rows in a db where the value of column is not equal to something,
instead of me having to resort to actual SQL comands in my scope.
Any suggestions would be very helpful!
I thought this would be easy to find, but the closest I can find is
which still seems pretty messy