Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Lists outage #306

Open
peggynewman opened this issue Jun 3, 2024 · 1 comment
Open

Lists outage #306

peggynewman opened this issue Jun 3, 2024 · 1 comment
Assignees
Milestone

Comments

@peggynewman
Copy link

Going to these URLs is erroring

https://lists.ala.org.au/speciesListItem/list/dr2201?fq=family%28matched%29%3AProteaceae&q=&max=100
https://lists.ala.org.au/speciesListItem/list/dr649?fq=family%28matched%29%3AOrchidaceae&q=&max=100

Unable to retrieve species list items. Please let us know if this error persists. 
Error:
could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
@adam-collins
Copy link
Contributor

To reproduce this error

  1. Open a list https://lists.ala.org.au/speciesListItem/list/dr2201
  2. On the left hand side, under the filter heading family(matched), click any item
  3. The fq is incorrect. It should filter the the result by the MatchedSpecies.family table join.

Fixing this requres

  1. Change family(matched) to something else. I think kvp filters work with kvp key:value so being consistent results in matched key:value, e.g. matched family:Proteaceae.
  2. Parse the matched prefix, in QueryService in a similar way to kvp.

@adam-collins adam-collins self-assigned this Jun 3, 2024
adam-collins pushed a commit that referenced this issue Jun 3, 2024
adam-collins added a commit that referenced this issue Jun 5, 2024
@qifeng-bai qifeng-bai added this to the 5.2.0 milestone Jun 26, 2024
qifeng-bai added a commit that referenced this issue Jun 30, 2024
updates included in 5.2.0 snapshot
#292 Grails 6 upgrade
#295 Support the latest AuthService Plugin
#299 Fixed the broken list upload from Spatial
#302 Fixed download list csv issue
#306 Fixed 'family(matched)' facade
#288 Improved rematching process performance
qifeng-bai added a commit that referenced this issue Jun 30, 2024
Including updates from 5.2.1 snapshot

updates included in 5.2.0 snapshot
#292 Grails 6 upgrade
#295 Support the latest AuthService Plugin
#299 Fixed the broken list upload from Spatial
#302 Fixed download list csv issue
#306 Fixed 'family(matched)' facade
#288 Improved rematching process performance
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants