Running on XP, Rails v1.1.6, Ruby 1.8.4, mysql 5.0.24, WEBrick 1.3.1
just doing a basic ‘scaffold’ against a table in mysql, I originally got
the “undefined method ‘each’” error at all times then saw something
advising to uninstall the gem mysql package, which I did.
then it seemed to work! - but only the first ‘list’ call to the website
returns the data from the table - reloading the identical page
thereafter generates this error, so it is not at all stable. Restarting
WEBrick again works first call only
I’m having EXACTLY the same problem however I’m running Apache 2. The
first call works however if I refresh the page, it no longer works (or
any other call to the database) and I get:
I also run MSSQL server on this machine and if I point the database.yml
to that instead (took a lot of setting up but finally got it working),
it works perfectly. Which is odd…
I’m having EXACTLY the same problem however I’m running Apache 2. The
first call works however if I refresh the page, it no longer works (or
any other call to the database) and I get:
I also run MSSQL server on this machine and if I point the database.yml
to that instead (took a lot of setting up but finally got it working),
it works perfectly. Which is odd…
Any help greatly appreciated.
Nick
I had this exact problem on a development based windows machine. The
problem was my libmysql.dll was not in sync with the MySQL server that i
had running. (I used instantrails for the mysql server and just
downloaded the 5.0 release dll from MySQL.com)
So i suggest if you have upgraded your MySQL install make sure that you
have the mysql gem re compiled so that it is linked with the same mysql
libraries.
The funny thing is that I have only ever used MySQL v.5.0. I did however
use InstantRails at one point just to see what it was like. I didn’t
like it, uninstalled it and reinstalled MySQL v.5.0.
Another odd thing is that I was having problems making Rails work at all
with the DB… I read somewhere that all I needed to do was copy the
libmySQL.dll file to my Windows\System32 directory. Which I did. Worked.
However, then I started experiencing these problems described above!
Finally, sorry to sound like a fool, but what exactly do you mean by
“have the mysql gem re compiled” and how would I go about doing that?
Thanks for the reply but that wasn’t the problem in the end. I have
successfully found what the problem was!
Having rumaged around on the web for days, I came across someone
suggesting that I install a different mysql.so in the
“C:\ruby\lib\ruby\site_ruby\1.8\i386-msvcrt” folder. I did. Nothing
changed. While trying the two different files, I was constantly changing
the names to mysql.so_old or something like that. At one point BOTH were
named _old and _new… i.e. Ruby couldn’t find a SINGLE mysql.so.
And would you believe this actually worked!
It was the mysql.so file that was causing problems… Simply removing
the file made it all work again!
Ok sorry i thought you were on a *nix type platform where the gem’s are
linked against your library’s. If you are on windows then just make sure
that you are using the proper libmysql.dll from your distribution.
Normally it is located in the bin directory of your mysql install.
Also i actually perfer to put the libmysql.dll in the directory where
the ruby.exe is located. that way i don’t have stuff cluttering up the
Windows system dir. Also scan your harddrive and see if there is more
instances of libmysql.dll that you might not know about that ruby is
picking up.
The major problem is that there does not appear to be ONE SINGLE
installation tutorial for Ruby/Apache/MySQL on Windows XP that actually
works. Everyone I spoke to has had to use a strange mix of numerous
different tutorials to finally get it working.
Naturally, I tried numerous different things to finally get mine working
and probaby one of them involved installing this stupid mysql.so file.
Nick,
I think when you deleted the mysql.so file you actually put the mysql
gem into ruby only mode. So you will have alot slower times doing stuff
with the database. instead of using a native module. (Though i am not
100% sure on this though) And i know your pain. I currently have 3
seperate environments (Linux, Windows, MacOSX) that i do development in
and Windows one has been the hardest to setup.
Rob S.
hey man,
before i used to use the instant rails because it was so easy, but
recently i just installed MySQL v.5.0. with ruby 1.8 and i get this
error. and i am using webrick do you know what i need to do to make this
work ?
Nick,
I think when you deleted the mysql.so file you actually put the mysql
gem into ruby only mode. So you will have alot slower times doing stuff
with the database. instead of using a native module. (Though i am not
100% sure on this though) And i know your pain. I currently have 3
seperate environments (Linux, Windows, MacOSX) that i do development in
and Windows one has been the hardest to setup.
FYI:
This problem can be caused by an a mismatch between versions of the
mySQL gem and the version of mySQL. If you are using version 2.7.3 of
the mySQL driver, make sure you upgrade your mySQL installation to
5.0.27 from 5.0.24 - that can fix the problem (worked for me…)
John
Thomas Walter wrote:
Hi Nick,
I had the same problem - and you helped me very much! Renaming mysql.so
solves all , now Rails works fine.
This error drives me crazy! For the last 3 hours I was trying to
unsuccessfully find out what is wrong with my script, I have pinpointed
it to this:
I am running two SELECT queries like this:
require ‘mysql’
dbh = Mysql.connect("localhost", "aaa", "aaa", "aaa")
#Query 1
res = dbh.query("SELECT id FROM logs WHERE id='10'");
puts "Number of rows returned: #{res.num_rows}"
res.free
#Query 2
res = dbh.query("SELECT id FROM logs WHERE id='10'");
puts "Number of rows returned: #{res.num_rows}"
res.free
And here is what I’m getting:
For the first query everything is ok: Number of rows returned:0
For the 2nd: undefined method ‘num_rows’ for #Mysql:0x34eaaa18
(NoMethodError)
For some reason the second query does not return an object of class
Mysql::Result and I have no idea why. I even tried to dbh.close and
reopen - it does not help! The INSERTS are working fine, I tried several
insert statements, and they work without a glitch.
My set-up:
OS: Windows VISTA
MySQL GEM: 2.7.3
MySQL: 5.1.22
Ruby: 1.8.6
For some reason the second query does not return an object of class
Mysql::Result and I have no idea why. I even tried to dbh.close and
reopen - it does not help! The INSERTS are working fine, I tried several
insert statements, and they work without a glitch.
I’ve managed to go around it, although I do not understand what caused
an issue. Any way, when I use the block notation, it works fine:
dbh.query(“SELECT id FROM logs WHERE id=‘10’”) { |res| puts “Number of
rows returned: #{res.num_rows}” }
Hope it helps someone, and if you can explain what causes that
behaviour, will be very good.
This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.