[R] RSQLite error

[Paul Hammer]

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