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"

asked 22 May, 07:16

joseph's gravatar image

joseph
482210
accept rate: 0%

edited 22 May, 08:08


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

permanent link

answered 22 May, 11:10

Mino%20Togna's gravatar image

Mino Togna ♦♦
3323
accept rate: 7%

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

permanent link

answered 23 May, 23:54

joseph's gravatar image

joseph
482210
accept rate: 0%

Thanks Jos for reporting the solution !

Just let us know if other issues come up.

Thank you,

Mino

permanent link

answered 24 May, 17:34

Mino%20Togna's gravatar image

Mino Togna ♦♦
3323
accept rate: 7%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×44

question asked: 22 May, 07:16

question was seen: 169 times

last updated: 24 May, 17:34

Open Foris Support - 2014