search

cran / ctrdata

:exclamation: This is a read-only mirror of the CRAN R package repository. ctrdata — Retrieve and Analyze Clinical Trials in Public Registers. Homepage: https://cran.r-project.org/package=ctrdata, https://rfhb.github.io/ctrdata/ Report bugs for this package: https://github.com/rfhb/ctrdata/issues
Other
1 stars 0 forks source link

Error: no such function: jsonb_extract #1

Open nm15336 opened 4 months ago

nm15336 commented 4 months ago

Hi, When trying to query a trial, I get this error:

ctrLoadQueryIntoDb(
 queryterm = "NCT02437890",
 register = "CTGOV2",
 con = db
  )
Not overruling register label CTGOV2
* Found search query from CTGOV2: term=NCT02437890
* Checking trials using CTGOV API 2.0.0.-test, found 1 trials
(1/3) Downloading in 1 batch(es) (max. 1000 trials each; estimate: 0.1 MB total)
(2/3) Converting to NDJSON...
(3/3) Importing records into database...
JSON file #: 1 / 1                               
= Imported or updated 1 trial(s)
Error: no such function: jsonb_extract

I can't find the function jsonb_extract referenced in the source code, or anywhere, and I get the error whether I install from CRAN or build, or use other trial IDs. The sqlite file was built fine in the previous command 

db <- nodbi::[src_sqlite](https://docs.ropensci.org/nodbi/reference/src_sqlite.html)(
  dbname = "sqlite_file.sql",
  collection = "test"
)

Do you have any idea why I get this error?

Thanks

gaborcsardi commented 4 months ago

Hi, this is a read only mirror of CRAN, please see the package authors in the DESCRIPTION file. Look for Maintainer, BugReports and URL. Thanks!

nm15336 commented 4 months ago

Thanks!