NoMethodError set_result

[Phil]

Hi, I am hoping someone can help shed some light on this error
message. I am pretty sure that I have installed all the dependencies
and have compiled everything correctly now. However, when attempting
to run a simple test i get an undefined method error.

Environment: Ubuntu 10.4 64bit

DEBUG OUTPUT:

ubuntu@ip-10-204-65-115:~$ irb -d
Exception `LoadError' at /usr/lib/ruby/1.8/irb/init.rb:209 - no such
file to load -- /home/ubuntu/.irbrc
irb(main):001:0> require 'rubygems'
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems.rb:1113 - no such
file to load -- rubygems/defaults/operating_system
Exception `NoMethodError' at /usr/lib/ruby/1.8/rational.rb:78 -
undefined method `gcd' for Rational(1, 2):Rational
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/config_file.rb:34
- no such file to load -- Win32API
=> true
irb(main):002:0> require 'geocoder/us'
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
31 - no such file to load -- geocoder/us
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
31 - no such file to load -- sqlite3
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
31 - no such file to load -- sqlite3/1.8/sqlite3_native
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
38 - no such file to load -- sqlite3/1.8/sqlite3_native
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
31 - no such file to load -- text
Exception `LoadError' at /usr/lib/ruby/1.8/rubygems/custom_require.rb:
31 - no such file to load -- levenshtein
=> true
irb(main):003:0> db = Geocoder::US::Database.new("/home/ubuntu/data/
oregon.db")
=> #<Geocoder::US::Database:0x7f3945cd0750 @debug=false, @st={},
@threadsafe=false, @db=#<SQLite3::Database:0x7f3945cd0660>>
irb(main):004:0> p db.geocode("6950 NE Campus Way, Hillsboro, OR,
97124")
Exception `NoMethodError' at /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-
US-2.0.0/lib/geocoder/us/database.rb:64 - undefined method
`set_result' for #<SQLite3::Database::FunctionProxy:0x7f3945cc0508>
Exception `NoMethodError' at /usr/lib/ruby/1.8/irb/workspace.rb:81 -
undefined method `set_result' for #<SQLite3::Database::FunctionProxy:
0x7f3945cc0508>
NoMethodError: undefined method `set_result' for
#<SQLite3::Database::FunctionProxy:0x7f3945cc0508>
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:64
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
database.rb:318:in `call'
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
database.rb:318
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
resultset.rb:66:in `call'
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
resultset.rb:66:in `step'
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
resultset.rb:66:in `next'
from /var/lib/gems/1.8/gems/sqlite3-ruby-1.3.1/lib/sqlite3/
resultset.rb:97:in `each'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:138:in `execute_statement'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:46:in `synchronize'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:46:in `synchronize'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:135:in `execute_statement'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:122:in `execute'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:151:in `places_by_zip'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:339:in `find_candidates'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:654:in `geocode_address'
from /home/ubuntu/.gem/ruby/1.8/gems/Geocoder-US-2.0.0/lib/
geocoder/us/database.rb:724:in `geocode'
from (irb):4
from :0irb(main):005:0>

[Kate Chapman]

I have not tried the geocoder with a Ubuntu 10.04. Make sure dynamic extension loading is enabled in SQLite.  Did You compile SQLite from source.

Kate

[Phil Taylor]

I did not compile from source. Maybe that is the problem. Thanks for the advice.

Phil

Sent from my iPhone