Clever Geek Handbook

Sqldf not working after upgrade

When I run the first example from the sqldf documentation:

library(sqldf)
a1s <- sqldf("select * from warpbreaks limit 6")

I am getting the error:

Error in if (.allows_extensions(db)) { :missing value where TRUE/FALSE needed

This error appeared today after updating some packages to the latest versions. Any suggestions how to fix this or how to revert to previous versions?

+3


source to share


3 answers


Adding the following code to the top of my script solved the problem



library(checkpoint)
checkpoint("2014-10-08") # the date when the script worked fine
+6


source


Updating the sqldf package solved it for me. However, the latest version may not be available through the official CRAN. You have to do it manually.



The update is explained here .

0


source


I am adding this as the link above opplatek returns Object Not Found (404) error.

So, the location of all versions of sqldf package archives:

Apart from fixing the sqldf error for me, I had to upgrade to R 3.1.2 - Pumpkin Helmet.

0


source






More articles:


All Articles