Update to nextcloud 29.0.7

ℹ️ Support
,
1

during a update to 29.0.7 I become the fowing error message:

Aktualisierung auf 29.0.7

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

Detaillierte Protokollmeldungen

Update vorbereiten

Log-Level auf “debug” gesetzt

Wartungsmodus eingeschaltet

Reparaturschritt: Repair MySQL collation

Reparaturinformation: All tables already have the correct collation → nothing to do

Reparaturschritt: Copy data from accounts table when migrating from ownCloud

Reparaturschritt: Drop account terms table when migrating from ownCloud

Das Datenbankschema wird aktualisiert

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

Das Update ist fehlgeschlagen. Bitte melde dieses Problem an die Nextcloud Community.

Can anybody help?

2

Sounds like your databases is configured for MySQL 4-byte support

Also see:

3

Now it woks.

in Mysql I did:
ALTER TABLE oc_accounts ROW_FORMAT=DYNAMIC;
ALTER TABLE oc_whats_new ROW_FORMAT=DYNAMIC;
ALTER TABLE oc_webauthn ROW_FORMAT=DYNAMIC;
ALTER TABLE oc_vcategory_to_object ROW_FORMAT=DYNAMIC;
ALTER TABLE oc_vcategory ROW_FORMAT=DYNAMIC;
ALTER TABLE oc_users ROW_FORMAT=DYNAMIC;

Thanks for support.

1 Like
4

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