« You have a nil object when you didn’t expect it!
Music Video Playlists for myspace - jamzee.com »

Rails error: syntax error, unexpected tINTEGER Object::1

When trying to do a model.find(), I ran into the error, ’syntax error, unexpected tINTEGER Object::1′. If you have a table that uses a magic or reserved name, such as type, you will get this error. This error was a pain in the ass, but I figured out that you can get by it:

class SomeModel < ActiveRecord::Base
    self.inheritance_column = ''
end

The inheritance_column override is the key, basically giving it a different value to use. Hope this helps!

 

Tags: , , , ,

This entry was posted on Thursday, December 27th, 2007 at 11:28 am and is filed under Ruby on Rails. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

8 Responses to “Rails error: syntax error, unexpected tINTEGER Object::1”

  1. Jabi Says:
    June 18th, 2008 at 2:18 am

    It helped to find a bug, thanks a bunch!

  2. andro Says:
    June 18th, 2008 at 3:41 pm

    You are my hero! Exactly what I need: “type” as column name was the problem!

    thx a lot!

  3. Jeff Says:
    July 30th, 2008 at 5:35 pm

    Thank you. I was going crazy with this.

  4. Alex Says:
    August 16th, 2008 at 6:39 am

    Your blog is interesting!

    Keep up the good work!

  5. Satish Says:
    October 20th, 2008 at 10:53 am

    Thanks a lot!

  6. Paul Says:
    January 28th, 2009 at 2:01 pm

    Thanks a lot :) that really helped us :)

  7. ZeiP Says:
    April 22nd, 2009 at 12:37 pm

    Thanks, helped a lot… The error message is really bad. I had no idea about the cause…

  8. jimmy Says:
    July 2nd, 2009 at 2:28 pm

    Your blog was the first thing Google found and it fixed my problem immediately. Thanks!

Leave a Reply