Skip to content
Back to formatted view

Raw Message

Message-ID: <22554969.post@talk.nabble.com>
Date: 2009-03-17T09:06:34Z
From: Dongyan Song
Subject: errors when install RSQLite
In-Reply-To: <38b9f0350903162317i64fcccdfscf8e9a99dc4f54e5@mail.gmail.com>

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.