Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
ruby/sequel/mysql problem
Sean Sean
4/8/2009 11:36:00 PM
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
--
Posted via
http://www.ruby-...
.
1 Answer
Jeremy Evans
4/9/2009 2:58:00 PM
0
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_thread/thread/f0ab21...
--
Posted via
http://www.ruby-...
.
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
ruby/sequel/mysql problem
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password