View visitor profile not loading

Dear Team,
I’m getting following 500 series error. On click of visitors tab-> Visitor log->view visitor profile.

On click of “View Visitor profile” Never loads

On click of View Visitor profile link. Below http transactions happens
I used fiddler to capture following information.
Following endpoint is executed

Below is the Exception

Piwik # Web Analytics

SQLSTATE[HY000]: General error: 1111 Invalid use of group function

Please lets us know what is the solution for the above error.

With regards

hey @jeevi_tesh, that is indeed peculiar error. Which version are you using? Were you maybe conducting any update lately? Such issues might occur when codebase was not fully overwritten when updating it.

This error is due to a MySQL config setting that prevents “malformed” ANSI SQL queries from running. If you are using 2.16.0 already (if not, upgrade to this release), please create a bug report at: Issues · matomo-org/piwik · GitHub