R 2.81 crashes with MYSQL 5.31
I think you have MySQL 5.1.31, not 5.31. You need to build RMySQL from the sources to match your version of MySQL.
On Wed, 18 Feb 2009, Jim Burke wrote:
R crashes with the following code. Lots of us would really would like to use R with MYSQL. So please help. As mentioned in another note, where might I find a 5.0 libmySQL.dll? PROBLEM A: the dbSendQuery (see below) SQL crashes R. Wants to send an error report to Microsoft. (MAJOR) PROBLEM B: the initial library load points to an ancient mysql version. (minor)
It is not 'ancient': it was current a few weeks ago. And that is the cause of problem A.
OPERATING SYSTEM INFORMATION ---------------------------- OS..........: Win XP sp3 R...........: 2.8.1 RMySQL.dll..: 0.7-3 MYSQL.......: 5.31 libmySQL.dll: 1/23/2009 3:45am (no version info, tsk tsk tsk Sun Microsystems) R WINDOW EXECUTION ----------------------------
library(RMySQL)
Loading required package: DBI Warning message: In inDL(x, as.logical(local), as.logical(now), ...) : RMySQL was compiled with MySQL 5.0.67 but loading MySQL 5.1.31 instead! This may cause problems with your database connections. Please install MySQL 5.0.67. If you have already done so, you may need to set your environment variable MYSQL_HOME to the proper install directory.
mycon <- dbConnect(MySQL(), user='root', dbname="mysql",
password='f5^b678&')
rs <- dbSendQuery(mycon,
+ "SELECT * + FROM precinct + WHERE `Precinct-Ballot Style` LIKE '1120%';" + ) Thanks, Jim Burke
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595