# 2.2.2 simple\_captcha upgrade error

**URL:** <https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461>\
**Category:** Rails\
**Created:** [December 28, 2008, 6:57am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461 "2008-12-28T06:57:22Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 28, 2008, 6:57am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/1 "2008-12-28T06:57:22Z")

</div>

So thanks to Craig, i got up and running on rails 2.2.2, though now i’m  
dealing with a whole new can of worms. I’ve done a good bit o searching  
and haven’t found any solid leads. I’m using the simple\_captcha plugin  
on my site, and all is well until i call that plugin.

[http://www.pastie.org/347721](http://www.pastie.org/347721)

ActionView::TemplateError (undefined method `transaction\_status’ for  
#PGconn:0x6a8ae20) on line #43 of  
app/views/forms/\_slang\_form.html.erb:  
42:  
43: \<%= show\_simple\_captcha %\>  
44:  
45: \<%= @f.submit “Submit” %\>  
46:

The plugin works great in 2.1.0, Has anyone seen anything like this  
before??

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 28, 2008, 8:15am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/2 "2008-12-28T08:15:12Z")

</div>

It’s actually a problem with the postgres gem. I ran into this the  
other day at work, if I remember correctly you just need to switch  
which gem you hav installed. Unfortunately I don’t remember which one  
to use and I’m not at the office.

On Dec 27, 11:57 pm, Richard S. \<rails-mailing-l…@andreas-

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 28, 2008, 5:48pm UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/3 "2008-12-28T17:48:00Z")

</div>

That does make sense given all i’ve read about this error, thanks a  
bunch!! I’m not in too much of a hurry to play wih 2.2.2, if its not too  
much trouble whenever you get back to the office, could you let me know  
what version of pgsql worked for you ( so i’m not just shooting in the  
dark) ?

Right now i’m running 8.3.3 and if memory serves me correctly i had too  
much trouble directly installing the gem, so I used mac ports. I tried  
installing 8.2 from ports and wasn’t able to, i’m assuming whatever  
version i end up with, i’ll have completely uninstall 8.3.3 first if i’m  
using ports ?

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 29, 2008, 6:19am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/4 "2008-12-29T06:19:23Z")

</div>

It’s not the postgres (psql) version thats the problem, its actually  
the ruby postgres gem that ActiveRecord uses to connect to psql. I  
will be in the office tomorrow and will check it out.

On Dec 28, 10:48 am, Richard S. \<rails-mailing-l…@andreas-

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 29, 2008, 9:57am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/5 "2008-12-29T09:57:38Z")

</div>

how shud we create tooltip in rails application…

Thanks in advance

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 29, 2008, 4:50pm UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/6 "2008-12-29T16:50:52Z")

</div>

I asked my boss what gem it was he determined we need to be on, he  
claims “pr”, so I tried to install it and it fails to compile, so now  
im back to square one. I really thought I had this all sorted out a  
few weeks ago, maybe it was on a different computer.

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 29, 2008, 9:45pm UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/7 "2008-12-29T21:45:42Z")

</div>

richard$ gem list  
…  
postgres-pr (0.4.0)  
…

richard$ sudo gem install postgres-pr  
Password:  
Successfully installed postgres-pr-0.5.0  
richard$ script/server  
=\> Booting Mongrel (use ‘script/server webrick’ to force WEBrick)  
=\> Rails 2.2.2 application starting on [http://0.0.0.0:3000](http://0.0.0.0:3000)

It worked great, Thanks!! No problems starting up or showing any of my  
database entries, my app works just as it did before. Thanks for  
everyone’s help!!

---

<div class="post-metadata">

**Author:** ![indigoi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/b3f665/32.png) [@indigoi](https://www.ruby-forum.com/u/indigoi)\
**Post date:** [December 29, 2008, 6:35am UTC](https://www.ruby-forum.com/t/2-2-2-simple-captcha-upgrade-error/156461/8 "2008-12-29T06:35:10Z")

</div>

## Try to install the postgres-pr gem install and use that.

Ryan B.  
Freelancer

> **[frozenplague.net](http://frozenplague.net)**
>
> This domain may be for sale!
