# Bug report

**URL:** <https://www.ruby-forum.com/t/bug-report/139766>\
**Category:** Rails\
**Created:** [June 6, 2008, 8:43pm UTC](https://www.ruby-forum.com/t/bug-report/139766 "2008-06-06T20:43:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [June 6, 2008, 8:43pm UTC](https://www.ruby-forum.com/t/bug-report/139766/1 "2008-06-06T20:43:02Z")

</div>

I assume this is a bug with find :last?

> > capella.ps.last  
> > =\> #\<Program id: 888, name: "Post-… deleted\_reason: nil\> # worked
> 
> > capella.ps.find :last  
> > ActiveRecord::RecordNotFound: Couldn’t find Program with ID=6329 AND  
> > (programs.school\_id = 6)  
> > from  
> > /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/base.rb:1267:in  
> > `find_one' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:1250:in`find\_from\_ids\_without\_coercion’  
> > from  
> > /Users/rogerpack/dev/degreesearch/vendor/plugins/acts\_as\_sluggable/lib/active\_record\_overrides.rb:12:in  
> > `find_from_ids' from /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active_record/base.rb:504:in`find’  
> > from  
> > /opt/local/lib/ruby/gems/1.8/gems/activerecord-2.0.2/lib/active\_record/associations/has\_many\_association.rb:66:in  
> > `find’  
> > from (irb):7  
> > from :0

🙂  
Before I submit it wanted to check.

-R

---

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [June 7, 2008, 11:36am UTC](https://www.ruby-forum.com/t/bug-report/139766/2 "2008-06-07T11:36:15Z")

</div>

On Jun 6, 7:43 pm, Roger P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> I assume this is a bug with find :last?\>\> capella.ps.last
> 
> =\> #\<Program id: 888, name: "Post-… deleted\_reason: nil\> # worked\>\> capella.ps.find :last

Nope it’s because you’re running rails 2.0.2, which doesn’t have  
find :last.  
capella.ps.last works but that’s an array.last (ie the same as  
[1,2,3,4].last: it’s loading the whole array and then returning the  
last element

Fred

---

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [June 7, 2008, 2:12pm UTC](https://www.ruby-forum.com/t/bug-report/139766/3 "2008-06-07T14:12:16Z")

</div>

-----BEGIN PGP SIGNED MESSAGE-----  
Hash: SHA1

On Friday 06 June 2008 20:43:02 Roger P. wrote:

> =\> #\<Program id: 888, name: "Post-… deleted\_reason: nil\> # worked
> 
> > > capella.ps.find :last

Instead, do

capella.ps.find :first, :order =\> “id DESC”

Which item is “last” in a SQL query depends on what you’re ordering the  
query on, so you could use created\_at or something else instead of id.

Ciao,  
Sheldon.  
-----BEGIN PGP SIGNATURE-----  
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFISnr8pGJX8XSgas0RApgqAJ9splmd5cj+uBtvUDde/3vd+AWVQwCgq8lK  
9Amp8nwap4tHngfJVb4t36g=  
=Bhg1  
-----END PGP SIGNATURE-----

---

<div class="post-metadata">

**Author:** ![rogerdpack](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/45deac/32.png) [@rogerdpack](https://www.ruby-forum.com/u/rogerdpack)\
**Post date:** [June 7, 2008, 4:41pm UTC](https://www.ruby-forum.com/t/bug-report/139766/4 "2008-06-07T16:41:23Z")

</div>

> Nope it’s because you’re running rails 2.0.2, which doesn’t have  
> find :last.  
> capella.ps.last works but that’s an array.last (ie the same as  
> [1,2,3,4].last: it’s loading the whole array and then returning the  
> last element
> 
> Fred

cool. thanks!