Failed to upgrade from Matromo 4.16.0 to 5.0.0

Support & Bugs
1

Hi,

I tried to upgrade Matomo from 4.16 to 5.0 on my local environnement and I got this error while upgrading database schema :

/var/www/analytics/matomo/core/Updates/5.0.0-b1.php: Error trying to execute the migration ‘ALTER TABLE log_conversion ADD COLUMN pageviews_before SMALLINT UNSIGNED DEFAULT NULL;’. The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

I am using MariaDB.

Any idea ?

2

Fixed with :

Option 1 from https://matomo.org/faq/troubleshooting/how-do-i-fix-the-error-1118-row-size-too-large-the-maximum-row-size-for-the-used-table-type-not-counting-blobs-is-8126

ALTER TABLE log_conversion ROW_FORMAT=DYNAMIC;

1 Like
3

Ich habe ein Fehler beim Update von 4.16 nach 5.0

Fehler:

ERROR [14:22:07] 153364 Uncaught exception: /plugins/CoreUpdater/Commands/Update.php(267): Matomo could not be updated! See above for more information. [Query: , CLI mode: 1]

Kritischer Fehler während der Aktualisierung:
Mysqli prepare error: Unknown column ‘description’ in ‘field list’