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

[Jim Burke]

Hi everyone, I have some c++ odbc coding experience. How about either of 
the below to help get this error out of the way?

1. I have VC++ 6.0 Its old but works. So perhaps the build environment 
plus source.
2. Just the debug version of the dll. At least we might could get some 
information.

Just wondering, do we need the debug mysql version of their libmySQL.dll?

Thanks,
Jim Burke

Prof Brian Ripley wrote:
> 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
>>
>