ropensci / taxizedb

Tools for Working with Taxonomic SQL Databases
Other
30 stars 7 forks source link

404 error when downloading COL #46

Closed chulmelowe closed 5 years ago

chulmelowe commented 5 years ago
R version 3.6.0 (2019-04-26)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 16299)

Matrix products: default

Random number generation:
 RNG:     Mersenne-Twister 
 Normal:  Inversion 
 Sample:  Rounding 

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252   
[3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C                          
[5] LC_TIME=English_United States.1252    

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

other attached packages:
 [1] taxizedb_0.1.4    R.utils_2.9.0     R.oo_1.22.0       R.methodsS3_1.7.1 jsonlite_1.6     
 [6] lemon_0.4.3       openxlsx_4.1.0.1  timeDate_3043.102 askpass_1.1       lubridate_1.7.4  
[11] RODBC_1.3-15      scales_1.0.0      ggplot2_3.2.0     dplyr_0.8.3      

loaded via a namespace (and not attached):
 [1] Rcpp_1.0.2        ape_5.3           lattice_0.20-38   xlsxjars_0.6.1    zoo_1.8-6        
 [6] assertthat_0.2.1  zeallot_0.1.0     digest_0.6.20     foreach_1.4.7     R6_2.4.0         
[11] plyr_1.8.4        backports_1.1.4   RSQLite_2.1.2     pillar_1.4.2      rlang_0.4.0      
[16] lazyeval_0.2.2    RPostgreSQL_0.6-2 curl_4.0          rstudioapi_0.10   data.table_1.12.2
[21] blob_1.2.0        labeling_0.3      RMySQL_0.10.17    stringr_1.4.0     bit_1.1-14       
[26] munsell_0.5.0     compiler_3.6.0    xfun_0.8          pkgconfig_2.0.2   tidyselect_0.2.5 
[31] tibble_2.1.3      gridExtra_2.3     httpcode_0.2.0    codetools_0.2-16  reshape_0.8.8    
[36] hoardr_0.5.2      dbplyr_1.4.2      crayon_1.3.4      withr_2.1.2       rappdirs_0.3.1   
[41] crul_0.8.0        grid_3.6.0        nlme_3.1-140      gtable_0.3.0      DBI_1.0.0        
[46] magrittr_1.5      zip_2.0.3         cli_1.1.0         stringi_1.4.3     reshape2_1.4.3   
[51] xml2_1.2.0        vctrs_0.2.0       iterators_1.0.12  tools_3.6.0       bold_0.9.0       
[56] bit64_0.9-7       glue_1.3.1        purrr_0.3.2       parallel_3.6.0    colorspace_1.4-1 
[61] memoise_1.1.0     rJava_0.9-11      knitr_1.23 

When I attempt to download Catalog of Life using the 'db_download_col()' function I get an error message that reads:

Error in curl::cur_download(db_url, db_path, quiet = TRUE) : HTTP error 404

sckott commented 5 years ago

thanks for the report - COL has changed the URL. They now for the current years data provide a darwin core archive dump. So to make it easier, working on fixing GBIF and COL to create SQL DBs on the web, and then users can just download those here to load them in. So it will be next week hopefully

sckott commented 5 years ago

@chulmelowe reinstall from github remotes::install_github("ropensci/taxizedb") Changed COL to be a sqlite database now. shouldn't present problems now, but let me know if it does