Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

🎯 πŸ“š πŸ“• FAQ βž• KNOWN ISSUES #23369

Open
kesselb opened this issue Oct 12, 2020 · 3 comments
Open

🎯 πŸ“š πŸ“• FAQ βž• KNOWN ISSUES #23369

kesselb opened this issue Oct 12, 2020 · 3 comments
Labels
overview papercut Annoying recurring issue with possibly simple fix.

Comments

@kesselb
Copy link
Contributor

kesselb commented Oct 12, 2020

Important Known Issues

Frequently Asked Questions

Critical changes for developers & admins

@kesselb kesselb added the papercut Annoying recurring issue with possibly simple fix. label Oct 12, 2020
@kesselb kesselb pinned this issue Oct 12, 2020
@kesselb
Copy link
Contributor Author

kesselb commented Oct 12, 2020

1071 Specified key was too long; max key length is 767 bytes

Usually there are two ways to fix this:

A) Configure your database server to support utf8mb4 (https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html).

B) If the database server does not support utf8mb4, disable it by setting 'mysql.utf8mb4' => false in config.php (emojis in filename, calendar events, etc. are not possible than and you have to accept the warning).

What happens for most people is: They change the maria/mysql configuration temporary to enable utf8mb4 but forget to write the changes to the configuration file. The next time a update is installed the sql server is restarted and the temporary configuration changes are lost. Some weeks later they try to upgrade Nextcloud and run into those utf8mb4 errors again.

Original report: #15058

@nextcloud nextcloud deleted a comment from dirigit Oct 13, 2020
@Dennis1993 Dennis1993 unpinned this issue Nov 11, 2020
@kesselb kesselb pinned this issue Nov 12, 2020
@solracsf solracsf changed the title FAQ 🎯 πŸ“š πŸ“• FAQ βž• KNOWN ISSUES Nov 14, 2020
@nextcloud nextcloud locked as spam and limited conversation to collaborators Nov 14, 2020
@szaimen szaimen unpinned this issue Sep 20, 2021
@szaimen szaimen pinned this issue Sep 20, 2021
@pierreozoux

This comment was marked as resolved.

@kesselb

This comment was marked as resolved.

@SystemKeeper SystemKeeper unpinned this issue Nov 10, 2022
@SystemKeeper SystemKeeper pinned this issue Nov 10, 2022
@szaimen szaimen unpinned this issue Sep 6, 2023
@szaimen szaimen pinned this issue Sep 6, 2023
@ghost ghost unpinned this issue Sep 9, 2023
@susnux susnux pinned this issue Mar 4, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
overview papercut Annoying recurring issue with possibly simple fix.
Projects
None yet
Development

No branches or pull requests

3 participants