# Help with ActiveRecord

**URL:** <https://www.ruby-forum.com/t/help-with-activerecord/59724>\
**Category:** Ruby\
**Created:** [May 5, 2006, 7:42pm UTC](https://www.ruby-forum.com/t/help-with-activerecord/59724 "2006-05-05T19:42:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PJ\_Hyett](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e95f7d/32.png) [@PJ\_Hyett](https://www.ruby-forum.com/u/PJ_Hyett)\
**Post date:** [May 5, 2006, 7:42pm UTC](https://www.ruby-forum.com/t/help-with-activerecord/59724/1 "2006-05-05T19:42:00Z")

</div>

Model:

class AdminQueue \< ActiveRecord::Base  
set\_table\_name ‘adminqueue’  
end

Interacting with it in script/console

> > AdminQueue.new  
> > =\> #\<AdminQueue:0x240a910 @attributes={“topic\_id”=\>nil,  
> > “resolved”=\>nil, “updated\_on”=\>nil, “action”=\>nil, “type”=\>nil,  
> > “post\_id”=\>nil, “mod\_name”=\>nil, “count”=\>1, “user\_id”=\>nil,  
> > “comment”=\>nil}, @new\_record=true\>

> > AdminQueue.find(:all)  
> > SyntaxError: (eval):1:in `compute_type': compile error (eval):1: parse error, unexpected tINTEGER Object::0 ^ from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:1244:in`compute\_type’  
> > from  
> > /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/base.rb:983:in  
> > `instantiate_without_callbacks' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/callbacks.rb:215:in`instantiate’  
> > from  
> > /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/base.rb:390:in  
> > `find_by_sql' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:390:in`find\_by\_sql’  
> > from  
> > /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active\_record/base.rb:924:in  
> > `find_every' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:381:in`find’  
> > from (irb):7

Any ideas?

Thanks,  
PJ

---

<div class="post-metadata">

**Author:** ![PJ\_Hyett](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e95f7d/32.png) [@PJ\_Hyett](https://www.ruby-forum.com/u/PJ_Hyett)\
**Post date:** [May 5, 2006, 7:42pm UTC](https://www.ruby-forum.com/t/help-with-activerecord/59724/2 "2006-05-05T19:42:06Z")

</div>

Sorry guys, I meant to post this in the Rails mailing list.

-PJ

---

<div class="post-metadata">

**Author:** ![PJ\_Hyett](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e95f7d/32.png) [@PJ\_Hyett](https://www.ruby-forum.com/u/PJ_Hyett)\
**Post date:** [May 5, 2006, 7:51pm UTC](https://www.ruby-forum.com/t/help-with-activerecord/59724/3 "2006-05-05T19:51:43Z")

</div>

Any field named ‘type’ is special in Rails, it enables single table  
inheritance and is expected to be a character field. Try renaming the  
field to ‘queue\_type’ or something along those lines.

Dave

---

<div class="post-metadata">

**Author:** ![PJ\_Hyett](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/p/e95f7d/32.png) [@PJ\_Hyett](https://www.ruby-forum.com/u/PJ_Hyett)\
**Post date:** [May 5, 2006, 9:21pm UTC](https://www.ruby-forum.com/t/help-with-activerecord/59724/4 "2006-05-05T21:21:45Z")

</div>

Thanks Dave, I had a naming conflict just yesterday as well, I really  
need to pay closer attention.

-PJ
