Question: RSQLite reverse dependencies
0
2.4 years ago by
biostR0
biostR0 wrote:

Hi,

This is the first time I am posting an issue online, I also posted this on Biostars:

https://www.biostars.org/p/262617/#262622

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:

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)

Any suggestions?

Thank you very much in advance.

R rsqlite • 1.6k views
modified 2.4 years ago by James W. MacDonald51k • written 2.4 years ago by biostR0
1
2.4 years ago by
United States
James W. MacDonald51k wrote:

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.

0
2.4 years ago by
tcalvo30
tcalvo30 wrote:

Are you using R in which operating system? If linux, you may have to install some dependencies via terminal, such as RSQLite.