I updated R to the latest version. When I tried to use latest version of affycoretools package an error message told me that I should use an updated version of RSQLite:
"...namespace ‘RSQLite’ 1.1-2 is already loaded, but >= 2.0 is required.."
When I upgraded RSQLite to 2.0 version attaching affycoretools package gives the following error:
library(affycoretools)
No methods found in "RSQLite" for requests: dbGetQuery
Trying to upload an annotation package is also problematic:
biocLite("pd.hg.u133.plus.2")...
No methods found in "RSQLite" for requests: dbGetQuery
*** arch - x64
No methods found in "RSQLite" for requests: dbGetQuery
* DONE (pd.hg.u133.plus.2)
This issue is due to a problem with the NAMESPACE for affycoretools (and oligoClasses as well), where both packages are importing dbGetQuery from RSQLite, rather than the DBI package. The function is defined in DBI and is imported and then exported by RSQLite, and importing the function from RSQLite used to be copacetic, but apparently no longer. Although weirdly this only pops up with the devel version of Bioconductor, not the released version:
> library(oligoClasses)
Welcome to oligoClasses version 1.38.0
> sessionInfo()
R version 3.4.0 (2017-04-21)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Debian GNU/Linux 8 (jessie)
> library(oligoClasses)
No methods found in "RSQLite" for requests: dbGetQuery
Welcome to oligoClasses version 1.39.0
> sessionInfo()
R version 3.4.0 (2017-04-21)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Debian GNU/Linux 8 (jessie)
The fixes will appear in affycoretools 1.49.4 and oligoClasses 1.39.1, which will propagate through the build servers in a day or so.
Thanks.