Upgrade to NC 29 gives error

Robert_Rijken · April 25, 2024, 2:57am

Was running NC 28 and tried upgrading to 29 from when RC2 was out but upgrade ended with:

Exception: Database error when running migration 1030Date20240205103243 for app dav
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes
Update failed

Tried with all other RC and now with the final released version but I keep getting the same and cannot upgrade to NC 29.

Ubuntu 22.04, PHP 8.1, MariaDB

in my.cnf I have the following:
innodb_default_row_format=dynamic
innodb_file_format=barracuda
innodb_file_per_table=true
innodb_large_prefix=true

What am I missing? Help is appreciated!

Robert

tflidd · April 25, 2024, 7:48am

Do you use the utf8mb4 format?

github.com/nextcloud/server

🎯 📚 📕 FAQ ➕ KNOWN ISSUES

opened 08:18AM - 12 Oct 20 UTC

kesselb

papercut overview

**Important Known Issues** - https://github.com/nextcloud/server/issues/44358 …- #39744 - #6899 - #22482 - #24240 - #14074 - https://github.com/nextcloud/richdocuments/issues/1282 **Frequently Asked Questions** - https://github.com/nextcloud/password_policy/issues/117 - https://github.com/nextcloud/docker/issues/1574 - 1071 Specified key was too long; max key length is 767 bytes: https://github.com/nextcloud/server/issues/23369#issuecomment-707313974 - https://github.com/nextcloud/server/issues/8546 / https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/encryption_configuration.html#invalid-private-key-for-encryption-app **Critical changes for developers & admins** - Release notes: https://docs.nextcloud.com/server/latest/admin_manual/release_notes/index.html - App upgrade guides: https://docs.nextcloud.com/server/latest/developer_manual/app_publishing_maintenance/app_upgrade_guide/index.html

Robert_Rijken · April 26, 2024, 7:14am

Many thanks! In my config.php I have:

‘mysql.utf8mb4’ => true,

So I guess yes, but am not sure.

ran a [ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;] just in case

NC 28 is working without problems, they all started when NC 29 came along and only in the DAV module.

system · May 4, 2024, 7:14am

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.