|
Dear all, I changed step 005 base-unit-weight: <- NA to <- 1 but remain to get error, who knows solution? Thanks Joseph Error in 'R Scripts - Processing chain' 2017-05-22 07:03:20 step : 1-init.R INFO: Processing chain started Loading required package: methods Loading required package: DBI Loading required package: gsubfn Loading required package: proto Loading required package: RSQLite Loading required package: RSQLite.extfuns 2017-05-22 07:03:32 step : - ERROR: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result : ERROR: column "weight" is of type numeric but expression is of type boolean LINE 7: set "weight" = "r"."weight" from "r" where "mabiotis"."bioto... ^ HINT: You will need to rewrite or cast the expression. In addition, when running the script in R no errors are recorded ecept: Error in calc.getQuotedFileContent(filename) : could not find function "dbQuoteString" |
|
Thanks Jos for reporting the solution ! Just let us know if other issues come up. Thank you, Mino |
|
Hi Jos, make sure the weight is of type numeric. Also, make sure the libraries 'RPostgreSQL' and 'sqldf' are installed. Please let me know if that helps. Thanks, Mino |
|
I tried your suggestions but the error messages continued to appear. Finally I reinstalled R2.3.5, before running a script I was then asked to open a CRAN mirror, i used 0 cloud, upon library packages start loading/installing... maybe this i skipped before or did not wait long enough to let the installing finish! After this the script ran without error messages. Fixed, so fellow users see that R is installed completely with required libraries. Thanks Mino |