sheltermanager

Open full view…

Error in downloaded report

jimdunne
Tue, 13 Aug 2019 12:33:10 GMT

I have just downloaded the 'Medical History with Log' report, and when I run it, get the following error '(1054, "Unknown column 's.SpeciesName' in 'field list'")' SQL is not my thing, so how do I resolve this please?

robinrt
Tue, 13 Aug 2019 13:52:19 GMT

change the offending reference to sp.SpeciesName. Or, you could delete and reinstall the report, I've fixed it in the repository

jimdunne
Tue, 13 Aug 2019 18:50:54 GMT

Found another error - "INNER JOIN species sp ON s.ID = a.SpeciesID" is wrong (line 4), should be "INNER JOIN species sp ON sp.ID = a.SpeciesID" I changed that and the report works.