3

I'm getting an error when I'm running the sqldf command in R: ‘package ‘RSQLite.extfuns’ could not be loaded’

Here's my code:

install.packages("RSQLite")
library("RSQLite")
install.packages("sqldf")
library("sqldf")
Ent_forecast<-sqldf("select day,
                year,
                date,
                sales_offered_calls
                from R_input")

The first error (after the install): Error: package ‘RSQLite.extfuns’ could not be loaded

The second error (after using function: sqldf): Error: could not find function "sqldf"

...I think this may have something to do with the RSQLite.extfuns package being removed from the CRAN library:

http://cran.r-project.org/web/packages/RSQLite.extfuns/index.html

Any help would be very much appreciated!

Thanks!

Ryan Chase
  • 2,384
  • 4
  • 24
  • 33
  • can you do a `sessionInfo()` to show which version of `RSQLite` and `sqldf` you have loaded? – MrFlick Feb 10 '15 at 17:10
  • R version 3.0.2 (2013-09-25) Platform: x86_64-w64-mingw32/x64 (64-bit) locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252 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] RSQLite_1.0.0 DBI_0.3.1 gsubfn_0.6-6 proto_0.3-10 loaded via a namespace (and not attached): [1] tcltk_3.0.2 tools_3.0.2 – Ryan Chase Feb 10 '15 at 17:21
  • 2
    Update R, update your packages and all will be fine. – IRTFM Feb 10 '15 at 17:59
  • Yes. Version 3.0.2 is somewhat older now. We're at version 3.1.2. The latest version of sqldf required R (≥ 3.1.0) – MrFlick Feb 10 '15 at 18:02

0 Answers0