search

ropensci / rfishbase

R interface to the fishbase.org database
https://docs.ropensci.org/rfishbase
111 stars 40 forks source link

Error with query #75

Closed amroco closed 8 years ago

amroco commented 8 years ago

Hi there, getting the following error: Any thoughts?

valid_name <- validate_names(c("Opistognathus maxillosus")) Warning messages: 1: In error_checks(parsed, resp = resp) : Mysql2::Error: Unknown column 'ColStatus' in 'field list': SELECT SynGenus,SynSpecies,Valid,Misspelling,ColStatus,Synonymy,Combination,SpecCode,SynCode,CoL_ID,TSN,WoRMS_ID FROM synonyms WHERE synonyms.SynSpecies = 'maxillosus' AND synonyms.SynGenus = 'Opistognathus' LIMIT 50 for query http://fishbase.ropensci.org/synonyms?SynSpecies=maxillosus&SynGenus=Opistognathus&limit=50&fields=SynGenus%2CSynSpecies%2CValid%2CMisspelling%2CColStatus%2CSynonymy%2CCombination%2CSpecCode%2CSynCode%2CCoL_ID%2CTSN%2CWoRMS_ID 2: No match found for species 'Opistognathus maxillosus'

Cheers, A

cboettig commented 8 years ago

Hmm, I cannot replicate this error. Can you give me the output of sessionInfo()?

@sckott Can you replicate? I'm not sure exactly where that API query is coming from, the query in the URL link above does indeed give that error. However, the validate_names() function on the species listed seems to work fine for me in rfishbase v2.1.0:

valid_name <- validate_names(c("Opistognathus maxillosus"))
> valid_name
[1] "Opistognathus maxillosus"
sckott commented 8 years ago

That works for me.

sckott commented 8 years ago

closing as works for us, and inactivity