I have a very simple app, which runs fine locally but fails on heroku. There are two activerecord tables: users and statuses. status has a user_id column.
If you access this url: http://followme.heroku.com/users/ you will get the user_id, then if you access this url: http://followme.heroku.com/users/1046706807/statuses you are supposed to see the statuses of the user (which works locally) but instead you'll get an error. heroku logs shows the following error: ActionView::TemplateError (PGError: ERROR: operator does not exist: character varying = integer LINE 1: ...T * FROM "statuses" WHERE ("statuses".user_id = 10467068... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. : SELECT * FROM "statuses" WHERE ("statuses".user_id = 1046706807) ) on line #1 of statuses/index.html.erb: 1: <% @statuses.each do |status| %> 2: <%= status.stat %> 3: <% end %> The code is very simple and I feel it has to be some postgre problem. Could someone help? Thanks, Zhao --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
