Migration to other server failed with only_full_group_by-error + solution

[VincentSC]

For when somebody else gets the same problem, and also objects to use some script that assumes a too generic environment.

As the previous installation was killed by the Ubuntu 22.04 Docker situation, and I understood important files were on the community-server, I decided to migrate all to another server. As was in the documents, three volumes needed to be copied:

• logs
• data
• mysql

So I did, and all looked good. I could log in with my usual credentials, and it looked like where I left it off. Except for documents. Here I got an error Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'onlyoffice.d.folder_type' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Turning it off with SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); for both databases still gives the error.

The solution was:
add command: mysqld --sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" in docker-compose for onlyoffice-mysql-server.

[VincentSC]

Off course the SQL should be modernized, as only_full_group_by simply makes sense.