[R-sig-DB] R 2.81 crashes with MYSQL 5.31

[Prof Brian Ripley]

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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using 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