Mise à jour 15.0.10 erreur with CREATE TABLE oc_personal_sections

🌐 Non-english support 🇫🇷 Français (french)
1

Bonjour
ma mise à jour est bloquée avec cette erreur :
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing ‘CREATE TABLE oc_personal_sections (id VARCHAR(64) NOT NULL, class VARCHAR(255) NOT NULL, priority INT DEFAULT 0 NOT NULL, UNIQUE INDEX personal_sections_class (class), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Un paramètre mysql à modifier ? Des droits à appliquer ?
serveur debian 9, php 7.0.33-0 +deb9u3
MERCI BEAUCOUP

2

You’re not writing from which Nextcloud version you want to update to which new version. This is important because afaik Nextcloud 15 is the last version which supports PHP 7.0.
Additionally you should make sure that you’ve converted your database tables to bigint as described here to prevent such problems. As similar problem has been reported here:

1 Like
3

Bonjour, hello.

I not sure what your issue is, but on debian9, you may need to have a 7.1 or higher php version for nextcloud to work.
Pas sure de ton probleme, mais sous debian9, php doit etre en 7.1 ou superieur pour fonctionner.

Otherwise, it look like a DB format as i think you are using mariadb, in antilope format. You need to be in barracuda format.
Cela peut etre due a mariaDB en format antilope, il faut barracuda.
verifi:
Check:

/etc/mysql/mariadb.conf.d/50-mysqld_large.cnf

[mysqld]
innodb_large_prefix=on
innodb_file_format=Barracuda

Puis/Then :slight_smile:

systemctl stop mariadb.service
systemctl start mariadb.service
1 Like
4

Oui merci, c’est réglé !