Try the fastest and simplest way to install ONLYOFFICE

Sudden Error while opening or viewing documents

Tech support for Enterprise Version

Sudden Error while opening or viewing documents

Postby 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
francgiovanni07
 
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Postby 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?
Maxim
 
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Postby 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 925 times
documents.png
SCREENSHOT OF ERROR FROM DOCUMENT SECTION
documents.png (140.08 KiB) Viewed 925 times
francgiovanni07
 
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Postby 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.
Maxim
 
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Postby 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!
francgiovanni07
 
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm

Re: Sudden Error while opening or viewing documents

Postby Maxim » Tue Aug 21, 2018 1:50 pm

Hello francgiovanni07 !
I suppose it should be /etc/mysql/conf.d
Maxim
 
Posts: 1747
Joined: Tue Oct 11, 2016 2:34 pm

Re: Sudden Error while opening or viewing documents

Postby 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.
francgiovanni07
 
Posts: 4
Joined: Thu Aug 02, 2018 9:47 pm


Return to Enterprise Version

Who is online

Users browsing this forum: No registered users and 3 guests