I am working on MySQL 5.0 with RMySQL 0.7-2. All commands except for
Select
statements work. I can create tables, Truncate then etc. When I
issue a
Select statement with dbSendQuery containing more than one column
in the
selection then R crashes. I have been looking around but could not
find any
solution to this. Does anyone knows whats wrong?
Can you send the output of sessionInfo() and also a small example that
reproduces the crash? It would be nice to know which OS you are
working on.
R version 2.8.0 (2008-10-20)
i386-pc-mingw32
locale:
LC_COLLATE=German_Germany.1252;LC_CTYPE=German_Germany.1252;LC_MONETARY=German_Germany.1252;LC_NUMERIC=C;LC_TIME=German_Germany.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] MASS_7.2-44 RMySQL_0.7-2 DBI_0.2-4 lattice_0.17-17
loaded via a namespace (and not attached):
[1] grid_2.8.0
I'm Working on Windows XP with SP3. The MySQL Server resides on an
Ubuntu Server. The failure also happens when I have the server on the
same system as R.
Okay, what's the output of the following R command readRegistry:
readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
I have a suspicion it's a version mismatch between the version of
MySQL client library with which the package was compiled and the
version installed and loaded by RMySQL on your machine. Your output
will give us the latter version, unless you have more than one installed.