errors when install RSQLite
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 <yzhskdls at 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 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.
-- 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 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.
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.