Re: [Rd] Error when adding package RMySQL (PR#14044)

From: <ligges_at_statistik.tu-dortmund.de>
Date: Thu, 05 Nov 2009 21:10:30 +0100 (CET)

kare_at_modlab.se wrote:
> Full_Name: Kåre Jonsson
> Version: 2.10
> OS: WinXP
> Submission from: (NULL) (85.225.178.169)
>
>
> I made a brand new installation of R 2.10 in two machines and got the same
> problem.
>
> Machine 1 is Win XP on metal installation
> machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any
> Microsoft windows XP siftware always successfully is installed.
>
> Operation 1. Add package RMySQL from Swedish CRAN.
> Operation 2. library(RMySQL)
>
> You can see the textual dump below. I need help to understand what is wrong.
>
> Kind regards,
> Kåre Jonsson
>
>

>> utils:::menuInstallPkgs()

> --- Please select a CRAN mirror for use in this session ---
> also installing the dependency ‘DBI’
>
> trying URL 'http://ftp.sunet.se/pub/lang/CRAN/bin/windows/contrib/2.10/DBI_0.2-4.zip'
> Content type 'application/zip' length 375508 bytes (366 Kb)
> opened URL
> downloaded 366 Kb
>
> trying URL 'http://ftp.sunet.se/pub/lang/CRAN/bin/windows/contrib/2.10/RMySQL_0.7-4.zip'
> Content type 'application/zip' length 284408 bytes (277 Kb)
> opened URL
> downloaded 277 Kb
>
> package 'DBI' successfully unpacked and MD5 sums checked
> package 'RMySQL' successfully unpacked and MD5 sums checked
>
> The downloaded packages are in
> C:\Documents and Settings\Administrator\Local
> Settings\Temp\Rtmpjqc0Bc\downloaded_packages
>> library(RMySQL)

> Loading required package: DBI
> Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 2) :
>
> Registry key 'SOFTWARE\MySQL AB' not found

So you probably forgot to install MySQL?

Why do you think this is a bug in the base R distribution? Note that bugs of contributed packages (if they are really bugs) should be reported to the corresponding package maintainer rather than to the R bug tracking system.

Best,
Uwe Ligges

> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
> Error: package/namespace load failed for 'RMySQL'

>> MySQL()

> Error: could not find function "MySQL"
>> con <- dbConnect(dbDriver("MySQL"), dbname = "mysql")

> Error in do.call(as.character(drvName), list(...)) :
> could not find function "MySQL"
> Error in is(object, Cl) :
> error in evaluating the argument 'drv' in selecting a method for function
> 'dbConnect'
>> version

> _
> platform i386-pc-mingw32
> arch i386
> os mingw32
> system i386, mingw32
> status
> major 2
> minor 10.0
> year 2009
> month 10
> day 26
> svn rev 50208
> language R
> version.string R version 2.10.0 (2009-10-26)
>
> ______________________________________________
> R-devel_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel


R-devel_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Thu 05 Nov 2009 - 20:13:16 GMT

This archive was generated by hypermail 2.2.0 : Thu 05 Nov 2009 - 23:00:21 GMT