Nevermind, sorry to be a pain. Looks like I had two versions of the
ruby mysql lib installed, and the older version was being used instead
of the version from ruby gems.
On Oct 28, 1:26 pm, Davertron <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
