It seems like the user_id field is a string. How did you specify it in your migration?
On Sat, May 2, 2009 at 10:14 PM, zlu <[email protected]> wrote: > > Oren, > > Yes I did a db:migrate and just in case I did one again: > > zlu-macbook:teresa zlu$ heroku rake db:migrate > (in /disk1/home/slugs/12955_c9ee63e_1e40/mnt) > > Also if I do a console command I get this: > > zlu-macbook:teresa zlu$ heroku console Status.all > [#<Status id: 125061337, type: nil, stat: "801 Gateway Blvd, South San > Francisco", longitude: nil, latitude: nil, user_id: "1046706807", > created_at: "2009-04-30 19:06:19", updated_at: "2009-04-30 19:06:19">] > > As you can see, the user_id field contains correct data. > > Zhao > > On May 2, 10:05 pm, Oren Teich <[email protected]> wrote: >> 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 -~----------~----~----~----~------~----~------~--~---
