Forum: Ruby ruby/sequel/mysql problem

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
D24265d5b8fefde8243a51b4bba568f9?d=identicon&s=25 Sean Sean (stangbos)
on 2009-04-09 01:35
newbie here.

have ruby/sequel/sqlite and windows 2003 server working smooth.

but have problem with mysql

"gem install mysql"

run a basic ruby test script, got error popop

"this application has failed to start because LIBMYSQL.dll was not
found. Re-installing the application may fix the problem."

Then copy LIBMYSQL.dll from my sql/bin to ruby/bin

this fixed the problem. Basic ruby / sql connection passed.

Then try to use sequel model with my sql code as following,

DB = Sequel.mysql(db_name, db_user, db_password, db_host, db_port)
class Test < Sequel::Model(:test)
end
tt = DB["test"].filter(:key => 'key').first

got error:

C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/lib/sequel_core/
adapters/mysql.rb:149:in `query': Mysql::Error Commands out of sync;
you can't run this command now (Sequel::DatabaseError)
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/adapters/mysql.rb:149:in `_execute'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/adapters/mysql.rb:108:in `execute'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/connection_pool.rb:109:in `hold'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/database.rb:440:in `synchronize'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/adapters/mysql.rb:108:in `execute'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/dataset.rb:477:in `execute'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/adapters/mysql.rb:343:in `execute'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/adapters/mysql.rb:285:in `fetch_rows'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/dataset.rb:462:in `_each'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/dataset.rb:213:in `each'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/dataset/convenience.rb:181:in `singl
e_record'
        from C:/dev-tools/ruby/lib/ruby/gems/1.8/gems/sequel-2.11.0/
lib/sequel_core/dataset/convenience.rb:52:in `first'
        from main.rb:137

connection looks ok but error on the filter().first  same code works
for sqlite.

Any idea?

Appreciate.
Sean
F183bcc4176b308c9edabe79299e448f?d=identicon&s=25 Jeremy Evans (jeremyevans)
on 2009-04-09 16:57
Sean Sean wrote:
>
> newbie here.
>
> have ruby/sequel/sqlite and windows 2003 server working smooth.
>
> ...

See the sequel-talk thread:
http://groups.google.com/group/sequel-talk/browse_...
This topic is locked and can not be replied to.