Hi Haix,
Thanks for reporting this issue.
First, the correct way to execute this SQL statement would be to use the HAVING clause. For example:
SELECT DISTINCT message, COUNT(message) TheCount, method
FROM CurrentView
WHERE response = '200'
GROUP BY message
HAVING TheCount > 20
ORDER BY TheCount DESC
However, LogViewPlus should fail more gracefully. I ran a few tests, and LogViewPlus gracefully reported a "COUNT method not found' error. I will continue testing to try and recreate an application failure.
The issue with error reporting can happen if the application does not have proxy server access or is blocked by antivirus. As a work around, you could email me the error.report file found in the %AppData%\LogViewPlus directory. To do this, we would need to first start an email thread.
Thanks again,
Toby