The file was built for DuckDB version 'v1.1.3', but we can only load extensions built for DuckDB version '19864453f7'.

[javierlenzi]

Hello,

I know that this issue has been discussed here but due that I'm new in programming, I haven't been able to solve the issue by myself. Please, if you could help me I would really appreciate that.

I'm trying to do a very basic analysis using the rfishbase package with the aim to extract, filter and join data from the fishbase and sealifebase databases. When I call the fb_tbl() function I get the error described below coming from DuckDB. This is a reproducible example:

remotes::install_github("ropensci/rfishbase")
library("rfishbase")

eco <- fb_tbl("ecosystem")

Error in duckdb_result():
! rapi_execute: Failed to run query
Error: IO Error: Failed to install 'httpfs'
The file was built for DuckDB version 'v1.1.3', but we can only load extensions built for DuckDB version '19864453f7'.

The function fb_tbl is as follows:
fb_tbl <- function(tbl,
server = c("fishbase", "sealifebase"),
version = "latest",
db = NULL,
collect = TRUE) {
urls <- fb_urls(server, version)
names(urls) <- tbl_name(urls)
out <- duckdbfs::open_dataset(urls[tbl])

if(collect) out <- dplyr::collect(out)

out
}

Thanks.

Regards.
Javier.

[meztez]

Reinstall duckdbfs from github, author pushed a fix last night.

pak::pkg_install("cboettig/duckdbfs")
or
remotes::install_github("cboettig/duckdbfs")

[javierlenzi]

Hello,

Thank you very much for your rapid response.

The solution worked perfectly, thanks!

Kind regards,