Query regarding compatibility of ORSEE with MySQL version 8

[therealLucasPaul]

Author: Shimodaira Recently, we upgraded our PHP to v8.1.14 and MySQL to v8.0.32 in our environment. While most of the functions seem to be working fine, we encountered an issue with the System statistics feature where the SQL's GROUP BY query does not function correctly. I came across two relevant threads on the ORSEE support forum: System statistics with invalid SQL query and Query Error on Experiments Overview pages. I attempted to implement the suggested solution from the past, which involved setting the variable with the following options:

However, upon setting this variable, the MySQL daemon failed to start.

I further googled the issue and discovered a rumor suggesting that the NO_AUTO_CREATE_USER option might not be compatible with MySQL v8. As a result, I modified the variable to exclude the NO_AUTO_CREATE_USER option, using the following configuration:

This adjustment appeared to resolve the problem with the System statistics functionality.

Although we have not yet conducted comprehensive testing of the entire system, I wanted to inquire if you guys are aware of any other potential inconveniences or challenges that we might encounter when using MySQL v8 with ORSEE.

Warm regards,

[therealLucasPaul]

Author: Dave Bruner Thank you for sharing this. We have been getting the same error from System statistics. Hopefully, this will fix it.