Re: [R] RSQLite error

From: Paul Hammer <paul.hammer_at_tfh-wildau.de>
Date: Fri, 29 Feb 2008 16:56:27 +0100

Gavin Simpson schrieb:
> Paul,
>
> Do you have the RSQLite package installed?
>
> In a clean R, what does
>
> require(RSQLite)
>
> return?
>
> If you don't have it installed, then install the package:
>
> install.package("RSQLite", dep = TRUE)
>
> If that proceeds correctly - you may need external libraries of headers
> for RSQLite to compile against, try to load the genefilter package again
> and see if this has rectified the problem.
>
> HTH
>
> G
>
> On Fri, 2008-02-29 at 16:04 +0100, Paul Hammer wrote:
>
>> hi members,
>>
>> i try to load the package genefilter but i get always this error message:
>>
>> _R code:_
>> >library(genefilter)
>> Error in dyn.load(file, ...) :
>> unable to load shared library
>> '/usr/local/lib64/R/library/RSQLite/libs/RSQLite.so':
>> /usr/local/lib64/R/library/RSQLite/libs/RSQLite.so: undefined symbol:
>> sqlite3_column_text
>> Error: package/namespace load failed for 'genefilter'
>> >library(RSQLite)
>> Error in dyn.load(file, ...) :
>> unable to load shared library
>> '/usr/local/lib64/R/library/RSQLite/libs/RSQLite.so':
>> /usr/local/lib64/R/library/RSQLite/libs/RSQLite.so: undefined symbol:
>> sqlite3_column_text
>> Error: package/namespace load failed for 'RSQLite'
>>
>> -------------------------------------------------------------------
>>
>> the file RSQLite.so exists and has all rights. i use fedora 7 with 64
>> bit technology.
>>
>> any suggestions?
>>
>> thanks
>> paul
>>
>> > sessionInfo()
>> R version 2.6.2 (2008-02-08)
>> x86_64-unknown-linux-gnu
>>
>> locale:
>> LC_CTYPE=en_US.UTF-8;LC_NUMERIC=C;LC_TIME=en_US.UTF-8;LC_COLLATE=en_US.UTF-8;LC_MONETARY=en_US.UTF-8;LC_MESSAGES=en_US.UTF-8;LC_PAPER=en_US.UTF-8;LC_NAME=C;LC_ADDRESS=C;LC_TELEPHONE=C;LC_MEASUREMENT=en_US.UTF-8;LC_IDENTIFICATION=C
>>
>> attached base packages:
>> [1] splines tools stats graphics grDevices utils datasets
>> [8] methods base
>>
>> other attached packages:
>> [1] survival_2.34 Biobase_1.16.3 DBI_0.2-4
>>
>> loaded via a namespace (and not attached):
>> [1] rcompgen_0.1-17
>>
>> [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help_at_r-project.org mailing list
>>
https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>

dear gavin,

the RSQLite package was installed. i just reinstalled it and now it works. the same i did twice time before but without rebooting my system. i guess the reboot with the re-installation brought the success:)

thanks
paul



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Fri 29 Feb 2008 - 16:03:16 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 29 Feb 2008 - 16:30:17 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive