install workspace app alert mysql error

[luguangdong]

I'm using nextcloud:26.0.2-apache, database version: 8.0.28 MySQL Community Server, both nc and db were installed in docker on an server running CentOS Linux release 7.5.1804.
Trying to install workspace, so I copied the folder into /app, and tried to active via web Gui, and then it gives me an error:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 3072 bytes

Is there anyway to solve this?

[zak39]

Hmmm... It's very strange for your case 🤔

From a few days, we published the new release 3.0.2. Can you try to download it ? Then, can you tell me if it's okay for you ?

Did you install the groupfolders app before ? You have to install groupfolder before to install workspace.

I hope I have helped you

[luguangdong]

I have installed the latest version of Workspace 3.0.2, but I am still experiencing the same error. Before installing Workspace, I had already installed GroupFolders 14.0.2.

[zak39]

Hi @luguangdong

Can you share your database configuration, please ?

It seems to be coming from the engine. But, I will investigate on this subject.

[zak39]

Hi @luguangdong , do you still have the problem ?