Page 1 of 1

Sudden Error while opening or viewing documents

PostPosted: Thu Aug 02, 2018 10:04 pm
by francgiovanni07
Hi,

The servers were working fine and then all of a sudden it began displaying this error message on all the document sections

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


almost all other functionality is still working i think.


please help Thank you

Re: Sudden Error while opening or viewing documents

PostPosted: Fri Aug 03, 2018 7:23 am
by Maxim
Hello francgiovanni07!
1. Specify please what instruction you followed to install Onlyoffice. Is it docker or RPM/DEB?
2. "began displaying this error message on all the document sections" - attach screenshot please.
3. What is the version of Onlyoffice or Document server?

Re: Sudden Error while opening or viewing documents

PostPosted: Fri Aug 03, 2018 4:06 pm
by francgiovanni07
Hi Maxim,
Thank you for your prompt response.

1)This onlyoffice is installed on ubuntu directly with nginx.(rpm/deb)
2)Screenshots attached
3)Version Version 9.5.4.553

Maxim wrote:Hello francgiovanni07!
1. Specify please what instruction you followed to install Onlyoffice. Is it docker or RPM/DEB?
2. "began displaying this error message on all the document sections" - attach screenshot please.
3. What is the version of Onlyoffice or Document server?

Re: Sudden Error while opening or viewing documents

PostPosted: Tue Aug 07, 2018 11:50 am
by Maxim
Hello!
You need to change MySQL config - see here. It happens when database was not installed by our installation script with needed parameters but was used existed MySQL database.

Re: Sudden Error while opening or viewing documents

PostPosted: Sun Aug 19, 2018 3:21 pm
by francgiovanni07
Maxim wrote:Hello!
You need to change MySQL config - see here. It happens when database was not installed by our installation script with needed parameters but was used existed MySQL database.



Hi Maxim,

Where can I find this file on the linux installation?

Thank You!

Re: Sudden Error while opening or viewing documents

PostPosted: Tue Aug 21, 2018 1:50 pm
by Maxim
Hello francgiovanni07 !
I suppose it should be /etc/mysql/conf.d

Re: Sudden Error while opening or viewing documents

PostPosted: Tue Sep 25, 2018 4:07 am
by francgiovanni07
Unable to locate it.

I am still getting this error. Please assist in rectifying the prob.

Thank you.