Skip to content

R 2.81 crashes with MYSQL 5.31

4 messages · Brian Ripley, Jim Burke, Jeffrey Horner

Original
Jim Burke
# 
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)

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
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:

            

      
      
      
    

        
It is not 'ancient': it was current a few weeks ago.  And that is the 
cause of problem A.

            

      
      
      
    

        

      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      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:

            

      
      
      
    

        

      
      
    

            

      
      
      
    

  
  


  


      

    

    

      
      

        


  

        

      Jeffrey Horner
    

    

      
      #
    

  


  

      
Jim Burke wrote on 02/18/2009 11:17 PM:

            

      
      
      
    

        
Sigh... I was really hoping the above warning would be helpful.

The web address for the RMySQL package is:

http://biostat.mc.vanderbilt.edu/RMySQL

Please read that and follow the recommendations.

For MySQL 5.0, downloads are here:

http://dev.mysql.com/downloads/mysql/5.0.html

Best,

Jeff