Hello,
I do loggin as root, and I tried three methods listed in INSTALL file in
RSQLite, but still did not work. The whole error list is:
** libs
WARNING: R include directory is empty -- perhaps need to install R-devel.rpm
or similar
gcc -std=gnu99 -I/usr/lib/R/include -DRSQLITE_USE_BUNDLED_SQLITE
-DSQLITE_MAX_SQL_LENGTH=2000000 -DSQLITE_ENABLE_RTREE=1 -DTHREADSAFE=0
-I/usr/local/include -fpic -march=i586 -mtune=i686 -fmessage-length=0
-O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables
-fasynchronous-unwind-tables -c RS-DBI.c -o RS-DBI.o
In file included from RS-DBI.h:32,
from RS-DBI.c:19:
Rhelpers.h:16:24: error: Rversion.h: No such file or directory
Rhelpers.h:18:24: error: Rdefines.h: No such file or directory
Rhelpers.h:19:17: error: S.h: No such file or directory
Rhelpers.h:75:49: error: missing binary operator before token "("
Rhelpers.h:93:49: error: missing binary operator before token "("
In file included from RS-DBI.c:19:
RS-DBI.h:102: error: expected specifier-qualifier-list before ‘SEXPTYPE’
RS-DBI.h:172: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocManager’
RS-DBI.h:175: error: expected ‘)’ before ‘mgrHandle’
RS-DBI.h:176: error: expected ‘)’ before ‘handle’
RS-DBI.h:177: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asMgrHandle’
RS-DBI.h:178: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_managerInfo’
RS-DBI.h:181: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocConnection’
RS-DBI.h:183: error: expected ‘)’ before ‘conHandle’
RS-DBI.h:184: error: expected ‘)’ before ‘handle’
RS-DBI.h:185: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asConHandle’
RS-DBI.h:186: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_connectionInfo’
RS-DBI.h:189: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocResultSet’
RS-DBI.h:190: error: expected ‘)’ before ‘rsHandle’
RS-DBI.h:191: error: expected ‘)’ before ‘rsHandle’
RS-DBI.h:192: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asResHandle’
RS-DBI.h:193: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_resultSetInfo’
RS-DBI.h:196: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_validHandle’
RS-DBI.h:197: error: expected ‘)’ before ‘handle’
RS-DBI.h:215: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_getFieldDescriptions’
RS-DBI.h:222: error: expected ‘)’ before ‘output’
RS-DBI.h:226: error: expected ‘)’ before ‘data’
RS-DBI.h:233: error: expected ‘)’ before ‘handle’
RS-DBI.h:255: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_SclassNames’
RS-DBI.h:257: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_createNamedList’
RS-DBI.h:261: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_copyFields’
RS-DBI.h:263: error: expected declaration specifiers or ‘...’ before
‘SEXPTYPE’
RS-DBI.h:264: error: expected declaration specifiers or ‘...’ before
‘SEXPTYPE’
RS-DBI.c:21:22: error: R_ext/RS.h: No such file or directory
RS-DBI.c:35: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocManager’
RS-DBI.c:107: error: expected ‘)’ before ‘mgrHandle’
RS-DBI.c:136: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocConnection’
RS-DBI.c:205: error: expected ‘)’ before ‘conHandle’
RS-DBI.c:260: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_allocResultSet’
RS-DBI.c:307: error: expected ‘)’ before ‘rsHandle’
RS-DBI.c: In function ‘RS_DBI_allocFields’:
RS-DBI.c:348: warning: implicit declaration of function ‘malloc’
RS-DBI.c:348: warning: incompatible implicit declaration of built-in
function ‘malloc’
RS-DBI.c:355: warning: implicit declaration of function ‘calloc’
RS-DBI.c:355: warning: incompatible implicit declaration of built-in
function ‘calloc’
RS-DBI.c:362: error: ‘RS_DBI_fields’ has no member named ‘Sclass’
RS-DBI.c:362: error: ‘SEXPTYPE’ undeclared (first use in this function)
RS-DBI.c:362: error: (Each undeclared identifier is reported only once
RS-DBI.c:362: error: for each function it appears in.)
RS-DBI.c:362: error: expected expression before ‘)’ token
RS-DBI.c: In function ‘RS_DBI_freeFields’:
RS-DBI.c:370: warning: implicit declaration of function ‘free’
RS-DBI.c:370: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:371: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:372: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:373: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:374: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:375: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:376: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:377: error: ‘RS_DBI_fields’ has no member named ‘Sclass’
RS-DBI.c:377: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c:377: error: ‘RS_DBI_fields’ has no member named ‘Sclass’
RS-DBI.c:378: warning: incompatible implicit declaration of built-in
function ‘free’
RS-DBI.c: At top level:
RS-DBI.c:388: error: expected ‘)’ before ‘data’
RS-DBI.c:412: error: expected ‘)’ before ‘output’
RS-DBI.c:468: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_validHandle’
RS-DBI.c:491: error: expected ‘)’ before ‘handle’
RS-DBI.c: In function ‘RS_DBI_errorMessage’:
RS-DBI.c:526: error: ‘PROBLEM’ undeclared (first use in this function)
RS-DBI.c:526: error: expected ‘;’ before string constant
RS-DBI.c:529: error: expected ‘;’ before string constant
RS-DBI.c:532: error: expected ‘;’ before string constant
RS-DBI.c:535: error: expected ‘;’ before string constant
RS-DBI.c:522: warning: unused variable ‘driver’
RS-DBI.c: In function ‘DBI_MSG’:
RS-DBI.c:545: error: ‘PROBLEM’ undeclared (first use in this function)
RS-DBI.c:545: error: expected ‘;’ before string constant
RS-DBI.c:548: error: expected ‘;’ before string constant
RS-DBI.c:551: error: expected ‘;’ before string constant
RS-DBI.c:554: error: expected ‘;’ before string constant
RS-DBI.c: In function ‘RS_DBI_copyString’:
RS-DBI.c:566: warning: incompatible implicit declaration of built-in
function ‘malloc’
RS-DBI.c:566: warning: implicit declaration of function ‘strlen’
RS-DBI.c:566: warning: incompatible implicit declaration of built-in
function ‘strlen’
RS-DBI.c:571: warning: implicit declaration of function ‘strcpy’
RS-DBI.c:571: warning: incompatible implicit declaration of built-in
function ‘strcpy’
RS-DBI.c: In function ‘RS_DBI_nCopyString’:
RS-DBI.c:580: warning: incompatible implicit declaration of built-in
function ‘malloc’
RS-DBI.c:583: warning: implicit declaration of function ‘sprintf’
RS-DBI.c:583: warning: incompatible implicit declaration of built-in
function ‘sprintf’
RS-DBI.c:593: warning: implicit declaration of function ‘strncpy’
RS-DBI.c:593: warning: incompatible implicit declaration of built-in
function ‘strncpy’
RS-DBI.c: At top level:
RS-DBI.c:609: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_copyfields’
RS-DBI.c:641: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_createNamedList’
RS-DBI.c:679: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_SclassNames’
RS-DBI.c:711: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asMgrHandle’
RS-DBI.c:722: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asConHandle’
RS-DBI.c:734: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_asResHandle’
RS-DBI.c:747: error: expected ‘)’ before ‘handle’
RS-DBI.c:762: error: expected ‘)’ before ‘conHandle’
RS-DBI.c:781: error: expected ‘)’ before ‘rsHandle’
RS-DBI.c:856: error: expected ‘)’ before ‘handle’
RS-DBI.c:907: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_managerInfo’
RS-DBI.c:943: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_connectionInfo’
RS-DBI.c:978: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before
‘RS_DBI_resultSetInfo’
RS-DBI.c:1007: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
before ‘RS_DBI_getFieldDescriptions’
RS-DBI.c: In function ‘RS_DBI_getTypeName’:
RS-DBI.c:1050: warning: incompatible implicit declaration of built-in
function ‘sprintf’
RS-DBI.c: At top level:
RS-DBI.c:1073: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’
before ‘RS_DBI_makeSQLNames’
RS-DBI.c:1120: error: expected declaration specifiers or ‘...’ before
‘SEXPTYPE’
RS-DBI.c: In function ‘RS_na_set’:
RS-DBI.c:1125: error: ‘type’ undeclared (first use in this function)
RS-DBI.c:1126: error: ‘INTSXP’ undeclared (first use in this function)
RS-DBI.c:1128: error: ‘NA_INTEGER’ undeclared (first use in this function)
RS-DBI.c:1130: error: ‘LGLSXP’ undeclared (first use in this function)
RS-DBI.c:1132: error: ‘NA_LOGICAL’ undeclared (first use in this function)
RS-DBI.c:1134: error: ‘REALSXP’ undeclared (first use in this function)
RS-DBI.c:1136: error: ‘NA_REAL’ undeclared (first use in this function)
RS-DBI.c:1138: error: ‘CHARSXP’ undeclared (first use in this function)
RS-DBI.c:1140: warning: implicit declaration of function ‘CHAR’
RS-DBI.c:1140: error: ‘NA_STRING’ undeclared (first use in this function)
RS-DBI.c:1140: warning: assignment makes pointer from integer without a cast
RS-DBI.c: At top level:
RS-DBI.c:1145: error: expected declaration specifiers or ‘...’ before
‘SEXPTYPE’
RS-DBI.c: In function ‘RS_is_na’:
RS-DBI.c:1151: error: ‘type’ undeclared (first use in this function)
RS-DBI.c:1152: error: ‘INTSXP’ undeclared (first use in this function)
RS-DBI.c:1153: error: ‘LGLSXP’ undeclared (first use in this function)
RS-DBI.c:1155: error: ‘NA_INTEGER’ undeclared (first use in this function)
RS-DBI.c:1157: error: ‘REALSXP’ undeclared (first use in this function)
RS-DBI.c:1159: warning: implicit declaration of function ‘ISNA’
RS-DBI.c:1161: error: ‘CHARSXP’ undeclared (first use in this function)
RS-DBI.c:1163: warning: implicit declaration of function ‘strcmp’
RS-DBI.c:1163: error: ‘NA_STRING’ undeclared (first use in this function)
RS-DBI.c: At top level:
RS-DBI.c:1171: error: ‘NILSXP’ undeclared here (not in a function)
RS-DBI.c:1172: error: ‘SYMSXP’ undeclared here (not in a function)
RS-DBI.c:1173: error: ‘LISTSXP’ undeclared here (not in a function)
RS-DBI.c:1174: error: ‘CLOSXP’ undeclared here (not in a function)
RS-DBI.c:1175: error: ‘ENVSXP’ undeclared here (not in a function)
RS-DBI.c:1176: error: ‘PROMSXP’ undeclared here (not in a function)
RS-DBI.c:1177: error: ‘LANGSXP’ undeclared here (not in a function)
RS-DBI.c:1178: error: ‘SPECIALSXP’ undeclared here (not in a function)
RS-DBI.c:1179: error: ‘BUILTINSXP’ undeclared here (not in a function)
RS-DBI.c:1180: error: ‘CHARSXP’ undeclared here (not in a function)
RS-DBI.c:1181: error: ‘LGLSXP’ undeclared here (not in a function)
RS-DBI.c:1182: error: ‘INTSXP’ undeclared here (not in a function)
RS-DBI.c:1183: error: ‘REALSXP’ undeclared here (not in a function)
RS-DBI.c:1184: error: ‘CPLXSXP’ undeclared here (not in a function)
RS-DBI.c:1185: error: ‘STRSXP’ undeclared here (not in a function)
RS-DBI.c:1186: error: ‘DOTSXP’ undeclared here (not in a function)
RS-DBI.c:1187: error: ‘ANYSXP’ undeclared here (not in a function)
RS-DBI.c:1188: error: ‘EXPRSXP’ undeclared here (not in a function)
RS-DBI.c:1189: error: ‘VECSXP’ undeclared here (not in a function)
make: *** [RS-DBI.o] Error 1
chmod: cannot access `/usr/lib/R/library/RSQLite/libs/*': No such file or
directory
ERROR: compilation failed for package 'RSQLite'
** Removing '/usr/lib/R/library/RSQLite'
** Restoring previous '/usr/lib/R/library/RSQLite'
Thanks again!
Best,
Dongyan
ronggui-2 wrote:
>
> It seems you use Unix-like OS. Does it happen that you did not use
> root to install the package? BTW, RSQLite does not require sqlite
> installed separately, it is embedded in the package.
>
> Best
>
> 2009/3/17 Dongyan Song <yzhsk...@hotmail.com>:
>>
>> Dear all,
>>
>> I am trying to install RSQLite package since I want to install "sqldf",
>> and
>> I used
>>>> install.packages("RSQLite") first, which gave Error message as below:
>>
>> make: *** [RS-DBI.o] Error 1
>> chmod: cannot access `/usr/lib/R/library/RSQLite/libs/*': No such file or
>> directory
>> ERROR: compilation failed for package 'RSQLite'
>> ** Removing '/usr/lib/R/library/RSQLite'
>> ** Restoring previous '/usr/lib/R/library/RSQLite'
>>
>> The downloaded packages are in
>> /tmp/RtmpZwBFdo/downloaded_packages
>> Updating HTML index of packages in '.Library'
>> Warning message:
>> In install.packages("RSQLite") :
>> installation of package 'RSQLite' had non-zero exit status
>>
>> And then I tried
>> # R CMD INSTALL RSQLite_0.7-1.tar.gz
>> # R CMD INSTALL
>> --configure-args=--with-sqlite3-dir=/usr/lib/sqlite-3.6.11/bld/
>> RSQLite_0.7-1.tar.gz
>> # R CMD INSTALL --configure-args=--with-sqlite-dir=/usr/bin
>> RSQLite_0.7-1.tar.gz
>> and all of them gave similar error messages.
>>
>> I have sqlite installed in my computer, in the directory /usr/bin, and I
>> do
>> not have a clue how to install it then. Thank you for help!
>>
>> Best,
>> Dongyan Song
>> --
>> View this message in context:
>> http://www.nabble.com/errors-when-install-RSQLite-tp22541474p22541474.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> R-help@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.
>>
>
>
>
> --
> HUANG Ronggui, Wincent
> Tel: (00852) 3442 3832
> PhD Candidate
> Dept of Public and Social Administration
> City University of Hong Kong
> Home page: http://asrr.r-forge.r-project.org/rghuang.html
>
> A sociologist is someone who, when a beautiful women enters the room
> and everybody look at her, looks at everybody.
>
> ______________________________________________
> R-help@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.
>
>
--
View this message in context:
http://www.nabble.com/errors-when-install-RSQLite-tp22541474p22554969.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@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.
