Sudden Error while opening or viewing documents

Tech support for Enterprise Version
Post Reply
francgiovanni07
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Sudden Error while opening or viewing documents

Post by francgiovanni07 » Thu Aug 02, 2018 10:04 pm

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

Maxim
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Post by Maxim » Fri Aug 03, 2018 7:23 am

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?

francgiovanni07
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Post by francgiovanni07 » Fri Aug 03, 2018 4:06 pm

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?
Attachments
email.PNG
ADDITIONAL EMAIL ERROR
email.PNG (122.46 KiB) Viewed 1197 times
documents.png
SCREENSHOT OF ERROR FROM DOCUMENT SECTION
documents.png (140.08 KiB) Viewed 1197 times

Maxim
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Post by Maxim » Tue Aug 07, 2018 11:50 am

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.

francgiovanni07
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Post by francgiovanni07 » Sun Aug 19, 2018 3:21 pm

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!

Maxim
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Post by Maxim » Tue Aug 21, 2018 1:50 pm

Hello francgiovanni07 !
I suppose it should be /etc/mysql/conf.d

francgiovanni07
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Post by francgiovanni07 » Tue Sep 25, 2018 4:07 am

Unable to locate it.

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

Thank you.

Post Reply