1

I tried installing the sqldf package using the following code:

install.packages("sqldf")

However, I get the following error. 

Warning in install.packages :
  error 1 in extracting from zip file
Warning in install.packages :
  cannot open compressed file 'RSQLite/DESCRIPTION', probable reason 'No such file or directory'
Error in install.packages : cannot open the connection

Is there a way to fix this?

The session info -

R version 3.2.2 (2015-08-14)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252   
[3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C                          
[5] LC_TIME=English_United States.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] RODBC_1.3-13

loaded via a namespace (and not attached):
[1] tools_3.2.2
zx8754
  • 52,746
  • 12
  • 114
  • 209
NM24
  • 87
  • 1
  • 8
  • Do you have SQlite installed ? – ODelibalta Jul 18 '16 at 17:58
  • `setInternet2(TRUE)`, and check if you have enough space, then try again. – zx8754 Jul 18 '16 at 18:13
  • @ODelibalta I don't! Which version of SQLite should I install? Thank you! – NM24 Jul 19 '16 at 15:34
  • @zx8754, I tried it. It didn't work. Got the same error. Thank you – NM24 Jul 19 '16 at 15:35
  • Hard to guess, maybe it would help if you add `sessionInfo()` to your post? Also, if you haven't seen it already, see [this post](http://stackoverflow.com/questions/25721884) for other suggestions. – zx8754 Jul 19 '16 at 15:39
  • @zx8754 I have added the session info to my post. I'm going through the link you posted. Thanks! – NM24 Jul 19 '16 at 19:19
  • Can you install other packages, or is this `RSQLite` specific? Have you tried running R as an administrator? – Gregor Thomas Jul 19 '16 at 19:25
  • Can you check if you have access to `.libPaths()`? I tried on my PC with the same sessionInfo (but UK locale) it works fine. – zx8754 Jul 19 '16 at 19:29
  • @Gregor I didn't trouble installing packages like dplyr or ggplot2. I had this trouble only with SQLDF and Ratte. Yes, I tried running it as an administrator but still encountered similar issues. Thanks. – NM24 Jul 21 '16 at 15:38
  • If you installed the new RSQLite 2.0 then you will need to install the new sqldf 0.4-11; otherwise, if you are want to use the old sqldf 0.4-10 then use a version of RSQLite older than 2.0. – G. Grothendieck Jun 28 '17 at 22:39

1 Answers1

1

I had this issue too. This error is in dependence of the BH library. First update to 3.4.1 RC because 3.4.0 will fail in validation TRUE/FALSE package. Download the BH library directly from de R CRAN Library. Unpack using 7.zip and copy folder to library in R folder.

sanunes
  • 26
  • 5