Hi Everyone,
I just found sequel and it looks like it could be pretty nice for some
of the stuff I'm working on. I installed version 2.6.0 using ruby
gems on an Ubuntu system, but I get an error when I execute the
following script (simplified to protect the innocent):
#!/usr/bin/ruby
require 'rubygems'
require 'sequel'
require 'csv'
TEST_ORDER_ID = 81350
DB = Sequel.mysql('my_db', :user => 'me', :password => 'mypass', :host
=> 'localhost')
order_info = DB[:orders].where(:order_id => TEST_ORDER_ID)
order_info.each do |row|
puts row
end
When I try to execute this I get the following:
/var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/adapters/mysql.rb:
105:in `connect': uninitialized constant Mysql::CLIENT_MULTI_RESULTS
(NameError)
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
database.rb:60:in `initialize'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:158:in `call'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:158:in `make_new'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:150:in `available'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:141:in `acquire'
from /usr/lib/ruby/1.8/thread.rb:135:in `synchronize'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:140:in `acquire'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
connection_pool.rb:100:in `hold'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
database.rb:335:in `synchronize'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
adapters/mysql.rb:138:in `execute'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
dataset.rb:437:in `execute'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
adapters/mysql.rb:305:in `execute'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
adapters/mysql.rb:258:in `fetch_rows'
from /var/lib/gems/1.8/gems/sequel-2.6.0/lib/sequel_core/
dataset.rb:200:in `each'
from ./export_commercial_invoice_data.rb:25
I've installed the mysql gem (2.7) using rubygems and have been using
that, but I'm wondering if maybe I have an incompatible version or
something? It basically looks like the mysql library that's getting
used doesn't have the "CLIENT_MULTI_RESULTS" constant defined.
Any help would be appreciated.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
