Couldn't share file with non-english letters in pydio cells

For first post, please answer the questions below!

Describe your issue in detail

I have encountered a problem sharing a document with a non-English letter filename. But renaming it with English letters works fine.

What version of Cells are you using?

Pydio Cells Home Edition 4.4.1

What is the server OS? Database name/version? Browser name or mobile device description (if issue appears client-side)?

Server: Fedora Workstation 39
Database: Mariadb

What steps have you taken to resolve this issue already?

I tried renaming the file using English letters and it worked. The current language I am trying with is Amharic (አማርኛ)
Here is server log

GroupPath : /headoffice/finance/
HttpProtocol : HTTP/2.0
JsonZaps : {"ContentType":"application/json"}
Level : error
Logger : pydio.rest.share
Msg : Rest Error 500 - {"Id":"","Code":0,"Detail":"Error 1366 (22007): Incorrect string value: '\\xE1\\x8B\\xA8\\xE1\\x8B\\xB0...' for column `cells`.`idm_workspaces`.`label` at row 1","Status":""}
RemoteAddress : 192.168.4.62
SpanUuid : 4c5fa1a0-4fcf-41e6-a3d5-5f97612d4a70
Ts : 1717833961
UserAgent : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36
UserName : seid-finance
UserUuid : e23a54d9-c07c-4b85-8efd-09d73dd9f7b8

Hi,

Try to verify the charset & collation of idm_workspace.label column. It might be “utf8mb4”

SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME, CHARACTER_SET_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA="cells" and TABLE_NAME = "idm_workspaces"

Following configuration work correctly on my server

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLLATION_NAME CHARACTER_SET_NAME
def cells idm_workspaces uuid utf8mb4_general_ci utf8mb4
def cells idm_workspaces label utf8mb4_general_ci utf8mb4
def cells idm_workspaces description utf8mb4_general_ci utf8mb4
def cells idm_workspaces attributes utf8mb4_general_ci utf8mb4
def cells idm_workspaces slug utf8mb4_general_ci utf8mb4
def cells idm_workspaces scope NULL NULL
def cells idm_workspaces last_updated NULL NULL
1 Like

@c12simple Thank you for replying
Mine is different when I check the result of the query you have suggested, is there a way to change that from the admin section or do I need to change it from Mariadb?

Hi,
You can only change from MariaDB.

Let try to change just the collation & charset of label column

Don’t forget to take a backup :wink:

1 Like

Thank you but, isn’t this should be a default thing in Pydio Cells?