I've recieved these type of problems after I add a field and forget to migrate. Is the heroku DB running your latest? heroku rake db:mgirate
Oren On Sat, May 2, 2009 at 9:34 PM, zlu <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
