Sqldf not working after upgrade

Question

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

r sqldf

tomaz 26 oct. '14 at 8:36

source to share

3 answers

tomaz · Answer 1 · 2014-10-26T14:20:58+0000

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

opplatek · Answer 2 · 2014-10-29T16:57:03+0000

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 .

Jazzmine · Answer 3 · 2015-02-07T22:30:31+0000

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.