Probleme bei Upgrade auf 28.0.14

[gerribaldi]

Hello,

i try to upgrade my server from the latest 27 Version to the version 28.0.14 via updater.phar and everythings looks good in the first step.

But if i try to access the website i get the messages that i need to upgrade my server via web or via occ upgrade

If i run occ upgrade i get this error messages [1] but got no idea where to look to fix the error.

php is 8.3.14, apache 2.4.6, mariadb 10.5.68

Regards
gerribaldi

[1]

Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Turned on maintenance mode
Updating database schema
Exception: Database error when running migration 30000Date20240814180800 for app core
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
Maintenance mode is kept active
Resetting log level

[bb77]

First of all, MariaDB 5.5 is EoL since 2020: https://mariadb.org/mariadb-55-rip/

…and the last Nextcloud version that officially supported it was Nextcloud 16: https://docs.nextcloud.com/server/16/admin_manual/installation/system_requirements.html

So I strongly recommend upgrading to at least to MariaDB 10.6: https://docs.nextcloud.com/server/28/admin_manual/installation/system_requirements.html

As for your actual issue, enabling MySQL 4-byte support is likely to solve it: https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html#enabling-mysql-4-byte-support

See also here and here.

[gerribaldi]

Thanks for the reply. I take a quick look to the search but didn´t found the post …

Meanwhile i fixed the problem.
The problem was the missing was the missing 4byte support in the database. After fixing this [1], everything looks good

I changed the versions from php and mariadb in the original post, so the server is not totaly outdated . The previous information was from the wrong server

[1]
https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/mysql_4byte_support.html