[RMySQL] unable to establish connection since R-1.8.0 upgrade
Hi Laurent, The issue is a very simple one to correct --- you only need to re-install RMySQL with the R version you're currently using. The issue is that the internal representation of objects in the methods package changed in 1.8.0, and thus packages that use S4 classes and methods and save their images (like RMySQL) and were installed prior to 1.8.0 need to be re-installed to be used with newer R versions. Hope this helps, -- David
Laurent Faisnel wrote:
Hi David, I have problems with RMySQL since I have upgraded to R-1.8.0 (now I have R-1.8.1). I have been using this package for quite a long time (don't konw if you remember, you helped me out with a function lean.exec which runs queries much faster than the standard dbGetQuery), without trouble, but there seems to be something incompatible with R >= R-1.8.0. The error comes up when I try to establish a connection :
> library(DBI)
> library(RMySQL)
> dbConnect("MySQL")
Error in initialize(value, ...) : Invalid names for slots of class MySQLDriver: Id This is the error I have after having added to the NAMESPACE file of the "methods" package the line : export(.valueClassTest) following John Chambers' piece of advice (see http://maths.newcastle.edu.au/~rking/R/devel/03b/0861.html). Before adding that line I had the same problem Fernando mentionned (see previous link). My settings are : Red Hat Linux 8.0 R-1.8.1 RMySQL-0.5.2 I don't have a sufficient knowledge of the way R is programmed to fix the problem by myself. What's your opinion about that ? Should RMySQL be updated ? Are you working on that ? In the previous debate you seemed to believe the problem lies in R (>= 1.8.0), and not in RMySQL. I'm enclined to think you may be right, since I had a few difficulties with R >= 1.8.0 (new library to be added for X11, eg). If you think this can be useful to others you can cc your answer to R-devel. Thanks in advance for any help, Best regards, Laurent