Repeat of #63

[KaiAragaki]

db_download_gbif appears to point to a file that holds little to no information - this appears to be a repeat of issue #63.

> sessionInfo()
R version 4.3.2 (2023-10-31)
Platform: x86_64-pc-linux-gnu (64-bit)
Running under: Linux Mint 21.1

Matrix products: default
BLAS:   /usr/lib/x86_64-linux-gnu/blas/libblas.so.3.10.0 
LAPACK: /usr/lib/x86_64-linux-gnu/lapack/liblapack.so.3.10.0

locale:
 [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
 [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
 [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
 [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
 [9] LC_ADDRESS=C               LC_TELEPHONE=C            
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       

time zone: America/New_York
tzcode source: system (glibc)

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] taxizedb_0.3.1 testthat_3.2.1 devtools_2.4.5 usethis_2.2.3 

loaded via a namespace (and not attached):
 [1] rappdirs_0.3.3    utf8_1.2.4        generics_0.1.3    RSQLite_2.3.5    
 [5] stringi_1.8.3     digest_0.6.34     magrittr_2.0.3    pkgload_1.3.4    
 [9] fastmap_1.1.1     blob_1.2.4        pkgbuild_1.4.3    sessioninfo_1.2.2
[13] brio_1.1.4        DBI_1.2.2         urlchecker_1.0.1  promises_1.2.1   
[17] purrr_1.0.2       fansi_1.0.6       cli_3.6.2         shiny_1.8.0      
[21] rlang_1.1.3       crayon_1.5.2      dbplyr_2.4.0      ellipsis_0.3.2   
[25] bit64_4.0.5       remotes_2.4.2.1   cachem_1.0.8      tools_4.3.2      
[29] memoise_2.0.1     dplyr_1.1.4       httpuv_1.6.14     curl_5.2.1       
[33] vctrs_0.6.5       R6_2.5.1          mime_0.12         lifecycle_1.0.4  
[37] stringr_1.5.1     fs_1.6.3          htmlwidgets_1.6.4 bit_4.0.5        
[41] miniUI_0.1.1.1    hoardr_0.5.4      pkgconfig_2.0.3   pillar_1.9.0     
[45] later_1.3.2       glue_1.7.0        profvis_0.3.8     Rcpp_1.0.12      
[49] tidyselect_1.2.0  tibble_3.2.1      xtable_1.8-4      htmltools_0.5.7  
[53] compiler_4.3.2   

[stitam]

Thanks @KaiAragaki, yes this seems to be a repeat of the issue.

[sckott]

@stitam looks like it ran succesfully after a small fix https://github.com/sckott/gbif-backbone-sql/actions/runs/8637394844/job/23679466889

[stitam]

Many thanks @sckott! db_download_gbif() seems to works on my end, @KaiAragaki can you please test it on yours?

[KaiAragaki]

@stitam Works beautifully! Thank you both!