Hi All, My R installation is acting strangely and I'm hoping somebody might have an idea what's going on: I can't seem to load the "RMySQL" function. It seems to have installed without a problem, but when I enter: library(RMySQL) R tells me: Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth 2) : Registry key 'SOFTWARE\MySQL AB' not found Error : .onLoad failed in 'loadNamespace' for 'RMySQL' Error: package/namespace load failed for 'RMySQL' Moreover, If I try to get information about a function (fisher exact test, for example) by typing: ?fisher.test R tells me: Error in shell.exec(url) : access to 'http://127.0.0.1:12625/library/stats/html/fisher.test.html' denied If I manually open, in a web browser, the html file whose address is given, I can see and read the document. I'm wondering whether there is some kind of problem with the registry (any ideas at all welcome). Thanks, Jon [[alternative HTML version deleted]]
On 26/01/2010 4:54 PM, Jonathan wrote:> Hi All, > My R installation is acting strangely and I'm hoping somebody might have > an idea what's going on:You need to give more details. Which R version? (If less than 2.10.1, install that and try again.) Do you have MySQL installed on that machine? (If not, install it.) Which Windows version are you using? Are you able to open other URLs from R, e.g. does browseURL("http://www.r-project.org") work? Duncan Murdoch> > I can't seem to load the "RMySQL" function. It seems to have installed > without a problem, but when I enter: > > library(RMySQL) > > R tells me: > Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth > 2) : > Registry key 'SOFTWARE\MySQL AB' not found > Error : .onLoad failed in 'loadNamespace' for 'RMySQL' > Error: package/namespace load failed for 'RMySQL' > > > Moreover, > If I try to get information about a function (fisher exact test, for > example) by typing: > ?fisher.test > > R tells me: > Error in shell.exec(url) : > access to 'http://127.0.0.1:12625/library/stats/html/fisher.test.html' > denied > If I manually open, in a web browser, the html file whose address is given, > I can see and read the document. > > I'm wondering whether there is some kind of problem with the registry (any > ideas at all welcome). > > Thanks, > Jon > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
Phil, The version of RMySQL you forwarded me installed, though I got the following message:> library(RMySQL)Warning message: package 'RMySQL' was built under R version c(2, 4, 0) and help will not work correctly Please re-install it That being said, I am getting farther along than I did with the version I installed from the server via install.packages("RMySQL"), so perhaps I'll be alright with the older version. Best, Jonathan ---------- Forwarded message ---------- From: Phil Spector <spector@stat.berkeley.edu> Date: Tue, Jan 26, 2010 at 5:07 PM Subject: Re: [R] unidentifiable problem.. To: Jonathan <jonsleepy@gmail.com> Jonathon - When my students have had this problem, I've pointed them to an earlier version of the package, which seems to work: http://www.stat.berkeley.edu/classes/s133/RMySQL_0.5-11.zip Download the file, and choose Packages -> Install Packages from Local Zip File. Hope this helps. - Phil Spector Statistical Computing Facility Department of Statistics UC Berkeley spector@stat.berkeley.edu On Tue, 26 Jan 2010, Jonathan wrote: Hi All,> My R installation is acting strangely and I'm hoping somebody might have > an idea what's going on: > > I can't seem to load the "RMySQL" function. It seems to have installed > without a problem, but when I enter: > > library(RMySQL) > > R tells me: > Error in utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth > 2) : > Registry key 'SOFTWARE\MySQL AB' not found > Error : .onLoad failed in 'loadNamespace' for 'RMySQL' > Error: package/namespace load failed for 'RMySQL' > > > Moreover, > If I try to get information about a function (fisher exact test, for > example) by typing: > ?fisher.test > > R tells me: > Error in shell.exec(url) : > access to 'http://127.0.0.1:12625/library/stats/html/fisher.test.html' > denied > If I manually open, in a web browser, the html file whose address is given, > I can see and read the document. > > I'm wondering whether there is some kind of problem with the registry (any > ideas at all welcome). > > Thanks, > Jon > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > >[[alternative HTML version deleted]]