Question: RSQLite reverse dependencies
0
gravatar for biostR
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:

"...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)

Any suggestions?

Thank you very much in advance. 

R rsqlite • 1.6k views
ADD COMMENTlink modified 2.4 years ago by James W. MacDonald51k • written 2.4 years ago by biostR0
Answer: RSQLite reverse dependencies
1
gravatar for James W. MacDonald
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.

ADD COMMENTlink written 2.4 years ago by James W. MacDonald51k

Thanks. 

ADD REPLYlink written 2.4 years ago by biostR0
Answer: RSQLite reverse dependencies
0
gravatar for tcalvo
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.

 

 

ADD COMMENTlink written 2.4 years ago by tcalvo30

This is not the answer to the user's problem.

ADD REPLYlink written 2.4 years ago by Martin Morgan ♦♦ 24k
Please log in to add an answer.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 16.09
Traffic: 385 users visited in the last hour